Case EX 4-2 Ben is copying some formulas and wants to make sure he has the cell references correct. Ben also wants to copy a formula from the bottom of the spreadsheet and put it at the top of the spreadsheet in a summary section. He wants the formula to stay exactly the same and result in the same figure. What type of cell reference should Ben use?
A) Mixed
B) Relative
C) Absolute
D) None of the above

Question

Quizplus · Accepted Answer

Ben should use absolute cell reference because it will lock the cell reference and prevent any changes when the formula is copied to a different location.

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