Matching
Match the following terms with their description:
Premises:
VLOOKUP
Column index number
HLOOKUP
Lookup value
Lookup table
Responses:
Cell that contains the value to be looked up
Data is organized in rows
Has the data used with HLOOKUP or VLOOKUP
Data is organized in columns
Column that contains the return values
Correct Answer:
Premises:
Responses:
VLOOKUP
Column index number
HLOOKUP
Lookup value
Lookup table
Premises:
VLOOKUP
Column index number
HLOOKUP
Lookup value
Lookup table
Responses:
Related Questions
Q86: In the HLOOKUP function, the third argument
Q87: If you are looking up exact values
Q88: A lookup table should contain at least
Q89: The default calculation using the PMT function
Q90: Functions can be nested inside the arguments
Q92: Match the example with the function or
Q93: Match the result with the function using
Q94: Match the example by replacing the ???
Q95: Match the example with the function or
Q96: Match the following terms with 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