The ____ function tells you the relative position of an item in a range or table,which is the same as a specified value in a specified order.
A) ALIGN
B) COMPARE
C) MATCH
D) LINK

Question

Quizplus · Accepted Answer

The MATCH function is designed to find the position of a particular value within a range or table. It can be used in combination with other functions like VLOOKUP or INDEX to retrieve the corresponding data. The ALIGN function is not related to finding the position of an item. The COMPARE function is used to compare two values and return a logical result. The LINK function is not a valid Excel function.

The ____ Function Tells You the Relative Position of an Item