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
Answer: C
Computer Science & Information Technology
You might also like to view...
__________________ recursion results from the lack of a base case.
a) Indirect b) Direct c) Infinite d) Spiral e) none of the above
Computer Science & Information Technology
Define the signal-to-noise ratio.
What will be an ideal response?
Computer Science & Information Technology
The ________ in VBA determines the amount by which a loop is incremented during each cycle
A) loop B) counter variable C) step value D) iteration
Computer Science & Information Technology
A USB flash drive is a program used to create and manage folders and files
Indicate whether the statement is true or false
Computer Science & Information Technology