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
Q44: Using _ simplifies adding complex mathematical formulas
Q45: Which status bar statistic can you not
Q46: What actually changes the value Excel stores
Q47: What error will you get if you
Q48: Which of the following will not return
Q50: When you use the VLOOKUP function, the
Q51: If a cell contains =$N$21 and two
Q52: The COUNTBLANK function will count cells that
Q53: Match the following terms with their description:<br>
Q54: The _ function finds the largest value