MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Designed to return the relative position (such as 1, 2, or 3) of an item in a list
A)vertical lookup table
B)horizontal lookup table
C)LOOKUP function
D)INDEX function
E)MATCH function
F)CHOOSE function
G)IFERROR

Question

Quizplus · Accepted Answer

The MATCH function is designed to return the relative position of an item in a list.

Note: The LOOKUP function is used to find a value within a range, the INDEX function is used to return a value from a specific location within an array or range, the CHOOSE function is used to select a value from a list of possible values based on a numeric index, the IFERROR function is used to handle errors in formulas, and both the vertical and horizontal lookup tables are types of Excel tables that can be used for searching and retrieving data.

MATCHING Identify the Letter of the Choice That Best Matches the the Definition