Matching
Match the following terms to their description.
Premises:
VLOOKUP
INDEX
MATCH
INDIRECT
IFERROR
Responses:
ref_text,[a1]
lookup_value,lookup_array,[match_type]
value,value_if_error
array,row_number,[column_number]
lookup_value,table_array,col_index_number,[range_lookup]
Correct Answer:
Premises:
Responses:
VLOOKUP
INDEX
MATCH
INDIRECT
IFERROR
Premises:
VLOOKUP
INDEX
MATCH
INDIRECT
IFERROR
Responses:
Related Questions
Q58: The INDEX function works with the MATCH
Q59: _ functions enable evaluation and choices to
Q60: The third argument of the AVERAGEIF function
Q61: Which of the following is the correct
Q62: VLOOKUP and HLOOKUP are two functions used
Q64: The _ function is the most common
Q65: The _ function is a database function
Q66: Match the following terms to their description.
Q67: Advantages of using the _ function instead
Q68: The MATCH function looks for a value