Solved

Which Is the Array Argument in =INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)

Question 29

Multiple Choice

Which is the Array argument in =INDEX(A2:B5,MATCH(MAX(B2:B5) ,B2:B5,0) ,1) ?

A) MAX(B2:B5)
B) MATCH(MAX(B2:B5) ,B2:B5,0)
C) 1
D) A2:B5

Related Questions

Q24: The _ function calculates the total future

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

Q30: What is the purpose of the Row_num

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