Multiple Choice
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
Correct Answer:
Verified
Correct Answer:
Verified
Q16: The Lookup function argument called lookup_vector is
Q17: The ISBLANK function checks whether a specified
Q18: The CHOOSE function can return a value
Q19: With the INDEX function, you can use
Q20: Identify the letter of the choice that
Q22: In a LOOKUP function, the argument _
Q23: In a one-dimensional table, Excel searches one
Q24: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Mark is
Q25: The LOOKUP function uses a _ lookup
Q26: A data list that categorizes values you