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

devquora
devquora

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

    Can you provide an overview of Microsoft Excel?

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

    Microsoft Excel Interview Questions

    Can you explain the concept of 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 ribbon in MS Excel is a user interface at the top, replacing traditional menus. It organizes commands into tabs like Home, Insert, and Formulas for easy access to various functions, enhancing user..