Multiple Choice
A function Screen Tip
A) automatically inserts functions such as SUM (B4:C4) .
B) calculates the total of values contained in two or more cells.
C) automatically inserts formulas such as =B4+C4.
D) is a small pop-up description that displays the arguments for a function as you enter it.
Correct Answer:
Verified
Correct Answer:
Verified
Q78: Excel displays a green arrow in the
Q79: If a formula contains a reference to
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
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