Windows

Q.:- What is the cell referencing?Explain different types of cell referencing.
Ans.:- The cell addressing in a formula is known as cell referencing.A cell referencing refers to a particular cell or range of cells in our worksheet.Cell referencing are useful for excel to identify data for use in formulas to calculate results based on our data.With the help of references,we can use the data in different parts of a worksheet.

There are three types of cell referencing that are as follows:-
1.Relative reference:-It is the default reference.When we create a formula,references to a cell or range of cells are usually based on the position relative to the cell.When we copy or move a formula to other cells,the reference cell automatically changes.It contains no dollar signs. Relative reference are especially convenient whenever we need to repeat the same calculation across multiple rows or columns.
Ex.:- =sum(B5:B10)↵

2.Absolute reference:-It is used when we donot want to change the address of the cell on copying the formula to another cell.For this purpose,we add the dollar($) symbol before the column and row number.It is especially use to keep row and column constant.
Ex.:- =$A$1+$A$2↵

3.Mixed reference:-It is a combination of relative and absolute reference.In this type of reference, either row or column has to remain constant.It have dollar signs attached to either the row or the column in a reference but not both.
Ex.:- =$A1+A$2↵