To reduce the chance of messing up range specifications and minimize the likelihood that errors will creep in when columns and rows are added later
A) always use absolute cell references in all formulas
B) never hide columns in the spreadsheet
C) apply names in the spreadsheet
D) manually inspect all formulas in the spreadsheet

Question

Quizplus · Accepted Answer

Applying names to cells or ranges in a spreadsheet can significantly reduce the chance of errors when referencing these cells or ranges, especially when the spreadsheet layout changes (e.g., when columns and rows are added). Named ranges are easier to remember and maintain than cell references, especially in complex formulas.

To Reduce the Chance of Messing Up Range Specifications and Minimize