Question

How is relative cell referencing different from absolute cell referencing?​

Answer 1

What is Cell referencing ?

$\implies$The behavior of a formula while coping from one cell to another cell is known as cell referencing.

or The way in which cell addresses the formula is known as cell referencing.

Difference between relative and absolute cell referencing.

✒Relative Referencing :- It is a type of referencing where columns and row number will change according to the formula in cell.

✏example - A1,B1 etc.

✒Absolute Referencing :- It is a type of referencing where column and row will not change while copomg formula from one cell to anotheror according to formula in cell.

✏example - dollar A dollar1 ,dollar B dollar1.