Explain the difference with an example between absolute , mixed and relative references.
Share
Explain the difference with an example between absolute , mixed and relative references.
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Verified answer
Answer:
The key difference between relative and absolute cells is that relative cell references move when you copy them, but absolute references do not. Absolute references are noted by a dollar sign in front of the cell reference.