Case-Based Critical Thinking Questions Case 3-1 Sally has been using spreadsheets for sometime on her job. She uses it in making purchasing decisions. Sally is getting a promotion and she has been asked to train James as her replacement. James has never used a spreadsheet. Sally tells James that his worksheet will automatically update to reflect any rows or columns that are deleted or copied. Sally tells James 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 in spreadsheets. In order to keep a cell reference from changing when a row or column is copied or deleted, James should use an absolute reference. Therefore, the best choice is A) absolute.

Case-Based Critical Thinking Questions Case 3-1 Sally Has Been Using