Multiple Choice
FIGURE EX 3-1 In Figure EX 3-1 above, when the formula in cell B11 is copied to cell C13, ____.
A) the relative column references change and the absolute row references do not
B) the relative column references do not change and the absolute row references do
C) the absolute column references change and the relative row references do not
D) the absolute column references do not change and the relative row references do
Correct Answer:

Verified
Correct Answer:
Verified
Q35: To quickly switch between displaying values and
Q36: In the function =SUM(B8:B11), which is the
Q37: When you click the Sum button arrow,
Q38: Case EX 3-2 Bernadette has created a
Q39: A cell with an error displays a
Q40: When you click the Error Checking button,
Q41: An Excel formula must begin with the
Q42: When a cell is active, you can
Q43: Identify the letter of the choice that
Q44: You can enter a formula by pressing