Multiple Choice
Match the following terms with their description:
i. VLOOKUP
II. HLOOKUP
III. Lookup table
IV. Lookup value
v. Column index number
A) Data is organized in rows
B) Column that contains the return values
C) Cell that contains the value to be looked up
D) Has the data used with HLOOKUP or VLOOKUP
E) Data is organized in columns
Correct Answer:

Verified
Correct Answer:
Verified
Q12: _ references change when formulas are copy
Q22: The _ function is similar to the
Q44: Using _ simplifies adding complex mathematical formulas
Q60: If the annual interest rate is 12%
Q61: Which of the following is not a
Q62: Match the following terms with their description:<br>i.
Q66: If you omit the fourth argument in
Q67: The HLOOKUP function can only be used
Q81: If the cell reference $A5 in a
Q96: A function's _ defines the rules by