4
QuizMultiple Choice

Unit Test — Cumulative exam

Question 4 • LHS Computer Applications

What type of result does the MATCH function, when used on its own, return?

Answer
A
It returns the lookup value located in a specific location.
B
It returns a value that is the same as the lookup value.
C
It returns the cell reference of the lookup value.
D
It returns the relative position of a lookup value, either as a row or column number, within the selected array.

Explanation

MATCH searches an array for a specified lookup value and returns its relative position in that array. For example, if the value is the third item in a selected column, MATCH returns 3. It does not return the value itself or a cell reference, so the correct choice is “It returns the relative position of a lookup value, either as a row or column number, within the selected array.”

AI-written and checked against the verified answer.

Previous
Next