differentiate between relative and absolute cell addressing in Excel
Answers
Answered by
3
Answer:
There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.
Answered by
12
Answer:
*relative cell address
- it is a type of cell address which doesn't contains $ sign. for example- D5, A7 etc.
*absolute cell address
- it is a type of cell address which contains $ sign in constant. for example- $D5,$A7 etc.
hope this will help you dear
mark as brainiest answer
give me thanks
Similar questions