In Excel, what combination of functions can produce the label for an item that equals a given number?
A) MAX and INDEX
B) MAX and MIN
C) MATCH and INDEX
D) MATCH and MAX
E) ABS and MAX

Question

Quizplus · Accepted Answer

The MATCH function can be used to find the position of a given number in a range of cells, and the INDEX function can be used to return the label or text in a corresponding range of cells. Therefore, by combining these two functions, we can produce the desired label for an item that equals a given number.

In Excel, What Combination of Functions Can Produce the Label