Multiple Choice
The Table Array
A) is the argument in a VLOOKUP function that identifies from which column to return a value.
B) looks up a value in a horizontal table where the first row contains the values to compare with the lookup value.
C) calculates the periodic payment for a loan with a fixed interest rate and fixed term.
D) is a range containing a 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,
Q87: The NOW function<br>A) contains another function embedded
Q88: The VLOOKUP function.<br>A) is the argument in
Q89: A function is a<br>A) predefined formula that
Q90: One benefit of using range names in