Find the best answers to your questions at Westonci.ca, where experts and enthusiasts provide accurate, reliable information. Our platform offers a seamless experience for finding reliable answers from a network of knowledgeable professionals. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A platform.

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.