Question

what is cell referencing explain its types

Answer 1

Relative vs. absolute references Depending on the task you want to perform in Excel, you can use either relative cell references, which are references to cells relative to the position of the formula, or absolute references, which are cell references that always refer to cells in a specificlocation.

Answer 2

Explanation:

Cell Referencing : It means how a cell address behaves in the formulae when it is copied from one cell to the other .

Types Of Cell Reverencing

There are three types of cell reverencing

1) Relative referencing : In relative referencing, both column part and row part are not fixed .

2) Absolute referencing : In absolute referencing, both column part and row part are fixed.

3) Mixed referencing : In mixed referencing,either column part or row part is fixed.