Computer Science, asked by queen5680, 3 months ago

differentiate between relative and absolute cell addressing in Excel​

Answers

Answered by ykverma1904
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 shambhavi290
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