What is the role of cell reference in the calculation in excel?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

In order to avoid writing of repetitive data for long calculation, cell reference plays a great role. When any formula is written, for any function, there is a need to direct Excel the specific location of that data. This location is referred to as, cell reference. So, as and when a new data or value is added to the cell, the cell will automatically calculate according to the reference given.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Microsoft Excel Interview Questions

    What is Microsoft Excel?

    Microsoft Excel is commonly known as an electronic spreadsheet application, which facilitates the users to store, organ..

    Microsoft Excel Interview Questions

    Explain the spreadsheet.

    Spreadsheets are similar to a paper ledger sheet. It has rows and columns and has their insertion named cells...

    Microsoft Excel Interview Questions

    What do you mean by ribbon?

     The topmost area on the Microsoft Excel that contains menu and other toolbar items are known as ribbon. CTRL+ F1 key..