Multiple Choice
One benefit of using range names in formulas is
A) it directly or indirectly refers to the cell containing the formula.
B) it contains both an absolute and a relative cell reference.
C) it identifies the present value of the loan.
D) if you copy the formula, you do not have to make the cell reference absolute.
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
Q88: The VLOOKUP function.<br>A) is the argument in
Q89: A function is a<br>A) predefined formula that