What is cell referencing in ms excel

Question

Accepted Answer

Cell referencing in MS Excel is a way to refer to a specific cell or range of cells in a formula or function.

Cell referencing allows you to use the value of a cell in calculations without manually entering the value.
There are two types of cell referencing: relative referencing and absolute referencing.
Relative referencing adjusts the cell reference based on the position of the formula when copied to other cells.
Absolute referencing keeps the cell reference constant, regardless of where the formula is copied.
Mixed referencing is a combination of relative and absolute referencing.
Example: =A1+B1 uses relative referencing, while =$A$1+$B$1 uses absolute referencing.

Top HR questions asked in Drishti IAS Assistant General Manager IT