Question

Explain the advantages of entering formula with cell address

Answer 1

Using cell references gives you more flexibility. You can more easily substitute other values for the formula more easily, rather than having to edit the formula each time. This is helpful when you have a table-full of data, and you want to apply a formula to each row, based on the data in the table.

In a complex spreadsheet, you may not want other users manipulating your formula, but you want them to be able to use it. Lock the cell with the formula, but give them access to input cells

Answer 2

Answer:

Entering the formula with cell address by this the computer give the answer very quickly