You should use cell references in formulas instead of constant values so that:
A)you can easily include letters,numbers,and spaces.
B)it is easier to debug the errors.
C)you can change the input values without changing the formulas.
D)you can control the sequence in which Excel performs arithmetic operations.

Question

Quizplus · Accepted Answer

Using cell references in formulas allows for flexibility and ease of updating. If a constant value is used instead, any change in the input value will require manually updating the formula. This can be time-consuming and prone to error. By using cell references, the input values can be updated in the worksheet and the formulas will automatically recalculate with the new values.

You Should Use Cell References in Formulas Instead of Constant