One benefit of using range names in formulas is
A) it directly or indirectly refers to the cell containing the formula.
B) it contains both an absolute and a relative cell reference.
C) it identifies the present value of the loan.
D) if you copy the formula, you do not have to make the cell reference absolute.

Question

Quizplus · Accepted Answer

Using range names in formulas makes the formulas easier to understand and maintain because the names can be more descriptive of the data they represent. When you copy formulas with named ranges, you don't need to adjust the references, as the named range always refers to the same cells, effectively acting like an absolute reference.

One Benefit of Using Range Names in Formulas Is