Explain different types of cell references.
VAL
..
2
Answers
Answered by
2
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 .
ᴴᴼᴾᴱ ᵀᴴᴵˢ ᴴᴱᴸᴾˢ◉‿◉➳♥
Similar questions