Sally has been using spreadsheets in making purchasing decisions at her job. She is getting a promotion, and has been asked to train James as her replacement. James has never used a spreadsheet.
-Sally tells James that a worksheet will automatically update to reflect any rows or columns that are deleted or copied.Sally tells James that if he does not want the cell reference to change,he should use a(n)____ reference.
A) absolute
B) relative
C) formula
D) unmoving

Question

Quizplus · Accepted Answer

Sally is explaining to James about the importance of cell references and how they can affect the accuracy of the spreadsheet. She advises James to use an absolute reference if he does not want the cell reference to change. This means that the reference will always refer to the same cell, even if other cells are added, deleted, or moved within the worksheet.

Sally Has Been Using Spreadsheets in Making Purchasing Decisions at Her