Multiple Choice
The VLOOKUP function.
A) is the argument in a function that describes to which column to return a value.
B) is a range containing a lookup table.
C) is a reference to a cell containing a value to look up.
D) looks up a value and returns a related result from the lookup table.
Correct Answer:
Verified
Correct Answer:
Verified
Q80: A mixed cell reference<br>A) occurs when a
Q81: The _ is the number of payments
Q82: The H_ function looks up a value
Q83: A function Screen Tip<br>A) automatically inserts functions
Q84: The MEDIAN function<br>A) displays the lowest value
Q85: The RATE is the periodic interest rate,
Q86: The Table Array<br>A) is the argument in
Q87: The NOW function<br>A) contains another function embedded
Q89: A function is a<br>A) predefined formula that
Q90: One benefit of using range names in