Solved

Which of the Following Functions Returns a Value or the Reference

Question 3

Multiple Choice

Which of the following functions returns a value or the reference to a value within a range based on X and Y coordinates?

A) MATCH
B) INDEX
C) VLOOKUP
D) HLOOKUP

Related Questions

Q5: Match the following terms with the corresponding

Q7: Match the following terms with the corresponding

Q15: The CUMPRINC function requires both starting and

Q24: _ calculates the standard deviation of a

Q35: The _ function returns the position of

Q43: Which database function should be used to

Q44: =INDEX(A2:<br>B5,MATCH(MAX(B2:<br>B5),B2:<br>B5,0),1)is an example of a nested function.

Q70: What is the maximum number of IF

Q89: Which of the following has the ability

Q99: If no values exist in the logical