Case EX 4-2 Ben is copying some formulas and wants to make sure he has the cell references correct. Ben wants to copy a formula that is the sum of five rows. He wants the formula to change as he copies it so that it shows the sum of five rows for each column. What type of cell reference should Ben use?
A) Absolute
B) Relative
C) Mixed
D) None of the above

Question

Quizplus · Accepted Answer

Ben should use relative cell reference since he wants the formula to change as he copies it. Relative cell references change automatically when copied across or down.

Case EX 4-2 Ben Is Copying Some Formulas and Wants