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

Computer Science & Information Technology

You might also like to view...

Which Cold War program played an important role in advancing integrated circuit technology?

a. B-52 bomber b. Hydrogen bomb c. Mark 37 torpedo d. Minuteman II ballistic missile e. NORAD radar network

Computer Science & Information Technology

The Internet Protocol (IP) primarily works to transmit and deliver data between devices on internetworks.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology