Multiple Choice
MATCHING
Identify the letter of the choice that best matches the definition of the word or phrase.
-Looks up the greatest value that does not exceed a specified value anywhere in a table or range
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
Q44: The function =_(index_num,value1,value2,…) can return up to
Q45: If a lookup_value is smaller than the
Q46: When using a VLOOKUP function, it's not
Q47: The _ function looks up the greatest
Q48: The data you are looking up is
Q50: Internal values are those pieces of data
Q51: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Violet is
Q52: If the values you want to look
Q53: In an INDEX function, the argument _
Q54: You can only use a LOOKUP function