Question

What do you mean by cell references ? Explain its advantage

Answer 1

Answer:

I hope it will help you

Explanation:

Cell reference is the power concept of Excel.No need to remember values to save the data values in the cell and use it in different part of the spreadsheetAdvantage of cell reference is that they allow you to update data in the worksheet without having to rewrite formulas .

Answer 2

• Cell reference is a reference to a single cell or to a group of cells of a spreadsheet of the MS EXCEL.

(Eg. Single cell reference = D3 , E7 and Group cell reference = A4 : R7 )

• Advantages of the cell reference -

- We can easily locate a particular cell in a large spreadsheet with large data arrangements.

- We can easily select a group of cells over rows or columns,by entering the group cell reference value in the formula bar for performing mathematical operations (fx).