1659
QuizMultiple Choice

Modeling with Rational Functions — Unit test

Question 1659 • Crowley Credit Recovery Algebra II B

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