Explore a wide range of topics and get answers from experts on IDNLearn.com. Discover prompt and accurate responses from our experts, ensuring you get the information you need quickly.

what is the difference between relative and absolute reference in ms excel?


Sagot :

Answer:

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.