Question

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

It returns the lookup value located in a specific location.

It returns a value that is the same as the lookup value.

It returns the cell reference of the lookup value.

It returns the relative position of a lookup value, either as a row or column number, within the selected array.

Answer 1

d

Step-by-step explanation:

Answer 2

D: It returns the relative position of a lookup value, either as a row or column number, within the selected array

Step-by-step explanation:

In Microsoft, the MATCH function is a function that is easily used to look for a specific item in a range of cells, and thereafter it now returns the relative position of that item in that same range of cells.

Thus, the correct answer is Option D