Multiple Choice
What is a lookup table used for?
A) It looks up a value and returns a related result.
B) It contains data for the basis of a lookup and the data to be retrieved.
C) It is the lowest value for a specific category or series.
D) It is a reference to a cell containing a value to look up.
Correct Answer:
Verified
Correct Answer:
Verified
Q21: A relative cell _ indicates a cell's
Q41: The lookup value<br>A) is the argument in
Q71: Match the range names to their descriptions:
Q72: Match the argument types to their function:
Q73: Match the formulas to their descriptions:
Q75: The nper in a PMT function is:<br>A)the
Q77: Match the terms to their descriptions:
Q78: The first argument in a PMT function
Q79: A range name:<br>A)indicates a cell's specific location
Q80: The _ function returns one value if