What is the purpose of the Row_num argument in the following INDEX function?
=INDEX(A2:B5,MATCH(MAX(B2:B5 ),B2:B5,0 ),1 )
A) To return the highest value in the range B2:B5
B) To return the row of the highest value in the range B2:B5
C) To return the column to the left of the highest values in the range B2:B5
D) To return the position of the highest value in the range B2:B5
D
You might also like to view...
MC When an object is created, it said to be______ .
a) instantiated. b) referenced. c) casted. d) None of the above.
Describe a column chart and the suggested limits of this type of chart
What will be an ideal response?
________ are used to add predesigned page designs and formats
Fill in the blank(s) with correct word
If you have a table containing sales data, you could use ________ rules to identify the three highest sales transactions
A) Extremes B) Top/Bottom C) Maximum/Minimum D) High/Low