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
Q90: When a(n)_ function is nested in the
Q91: Advantages of using the _ function instead
Q92: A conditional _ function can calculate on
Q93: The _ function expands on the AVERAGEIF
Q94: If letters appear for the column headings,the
Q95: The _ function sums data and allows
Q96: _ is code that uses the structure
Q97: A(n)_ function is used to look up
Q98: Match the following terms to their description.
Q100: Match the following terms to their description.
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents