Matching
Match the following terms with their description:
Premises:
Lookup value
Column index number
Lookup table
VLOOKUP
HLOOKUP
Responses:
Data is organized in columns
Has the data used with HLOOKUP or VLOOKUP
Column that contains the return values
Cell that contains the value to be looked up
Data is organized in rows
Correct Answer:
Premises:
Responses:
Lookup value
Column index number
Lookup table
VLOOKUP
HLOOKUP
Premises:
Lookup value
Column index number
Lookup table
VLOOKUP
HLOOKUP
Responses:
Related Questions
Q83: The HLOOKUP function can only be used
Q85: If you omit the fourth argument in
Q86: In the HLOOKUP function, the third argument
Q88: A lookup table should contain at least
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