Multiple Choice
Why would you nest MATCH in an INDEX function?
A) To handle multiple outcomes
B) To find the highest or lowest value in an array
C) To use the position returned in the Match function as an argument in the index function
D) To use the value returned in the Match function as a lookup in the index function
Correct Answer:

Verified
Correct Answer:
Verified
Q12: A(n)_ is a schedule that calculates the
Q13: The _ function calculates the total number
Q14: Match each of the following functions to
Q15: NPER calculates the periodic interest rate of
Q16: Which function calculates the Reduction in C2
Q18: A(n)_ is a schedule that calculates the
Q19: The criteria range must contain _ at
Q20: Match each of the following terms to
Q21: Advanced filtering will not copy results to
Q22: DSTDEV calculates the standard deviation of a