Question

Explain the advantage of entering formula with cell address , plz answer fast

Answer 1

Explanation:

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.

How to Use Absolute Cell References

To explain how absolute cell references work, we will use another example. Take a look at the spreadsheet below:



The above spreadsheet was designed to calculate commissions due to each salesperson. The formula to calculate the commission due to each salesperson is: Sales x Commission rate. Let’s enter the formula into the first cell to calculate the commission due for Jack.

Answer 2

Answer:

• 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.

          ФФФФФФФФФФHOPE THIS HELP UФФФФФФФФФФ