Solved

What Is the Purpose of the Row_num Argument in the Following

Question 30

Multiple Choice

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 position 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 row of the highest value in the range B2:B5

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q25: What is the purpose of an Excel

Q26: Match the following functions with their categories

Q27: If you need to find the day

Q28: An INDEX function returns the position of

Q29: Which is the Array argument in =INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)?<br>A)MAX(B2:B5)<br>B)MATCH(MAX(B2:B5),B2:B5,0)<br>C)1<br>D)A2:B5

Q31: Which financial function calculates the net present

Q32: What best describes a criteria range?<br>A)The table

Q33: What is < > equivalent to in

Q34: The YEARFRAC function returns the number of

Q35: A MATCH function returns the value of