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
Q12: _ references change when formulas are copy
Q25: Which function would you use to find
Q31: Match the following terms with their description:
Q52: The COUNTBLANK function will count cells that
Q57: When entering functions, the square brackets, [],
Q66: If you omit the fourth argument in
Q67: The HLOOKUP function can only be used
Q77: You could use both A3>b9 or B9<A3
Q79: The inputs in a function are specified
Q100: This is not a valid way to