Placing cell references to input values rather than constants in formulas makes a worksheet ____.
A) more flexible
B) easier to update
C) both a.and b.
D) neither a.nor b.

Question

Quizplus · Accepted Answer

By using cell references instead of constants in formulas, we make the worksheet more flexible because the formula will automatically update if the input value changes. It also makes the worksheet easier to update because we only need to change the input value in the referenced cell rather than editing each formula that includes the constant value. Therefore, both options A and B are correct.

Placing Cell References to Input Values Rather Than Constants in Formulas