A nested function
A) contains data for the basis of the lookup and data to be retrieved.
B) is the lowest value for a specific category or series in a lookup table.
C) looks up a value and returns a related result from the lookup table.
D) contains another function embedded inside one or more of its arguments.
Correct Answer:
Verified
Q18: The MEDIAN function
A) displays the lowest value
Q19: For a basic mathematical expression it is
Q20: A mixed cell reference
A) occurs when a
Q21: The PV is
A) a set of range
Q22: The COUNTA function
A) evaluates a condition and
Q24: The TODAY function
A) evaluates a condition and
Q25: The logical test
A) is the lowest value
Q26: The column index number
A) is the periodic
Q27: A lookup table
A) looks up a value
Q28: The Table Array
A) is the argument in
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents