Question

2. Why is it better to use cell reference in a formula?
3. How can a formula be created?​

Answer 1

Answer:

2.

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.

3.

Create a formula that refers to values in other cells

Select a cell.

Type the equal sign =. Note: Formulas in Excel always begin with the equal sign.

Select a cell or type its address in the selected cell.

Enter an operator. ...

Select the next cell, or type its address in the selected cell.

Press Enter.

hope this will help you