Question

what is the advantage of using cell references in formula

Answer 1

Modifying values with cell references. The true advantage of cell references is that they allow you to update data in your worksheet without having to rewrite formulas. ... The formula in B3 will automatically recalculate and display the new value in cell B3.

Answer 2

The best advantage of cell references is that they allow one to update data in their worksheet without having to rewrite formulas.

Explanation:

A Cell reference is the powerful concept of Excel.

One need not remember values to save the data values in the cell and use it in a different part of the spreadsheet.

Advantage of cell references is that they allow one to update data in the worksheet without having to rewrite formulas.

When one creates a formula one doesn't enter numbers into the formula – one enter cell references.

It creates a great time advantage when one needs to duplicate that formula in other cells.