Question

Explain different types of cell references.
VAL
..
2​

Answer 1

Answer:

RELATIVE REFERENCES;

When copied across multiple cells , They change Based on the relative position of rows and column .

For ex : if u copy the formula A1+B1 From row 1 to row 2 , The formula will become A2+B2 .

ABSOLUTE REFERENCES;

There may be times when you dont want A cell reference to change when copying or filling cells .

You can use an absolute reference To keep a row/column constant in the formula .

ᴴᴼᴾᴱ ᵀᴴᴵˢ ᴴᴱᴸᴾˢ◉‿◉➳♥