Question

What is cell reference ? Explain its advantages

Answer 1

The true advantage of cell referencesis that they allow you to update data inyour worksheet without having to rewrite formulas. ... The formula in B3 will automatically recalculate anddisplay the new value in cell 

Answer 2

A cell reference is a technique of identifying or calling a cell in spreadsheet software.

It is used for calling a cell which can be either present on the same spreadsheet or from a remote location outside of the spreadsheet.

It is generally represented by an alphabet followed by a numerical value.

The advantages of Cell Reference are as follows:

1. Cell Reference helps the user to update a particular value in the worksheet without writing the formula once again, thus saves time.

2. If makes the spreadsheet clearer and easier to understand.