• anonymous
Describe the difference between a “relative” cell reference and an “absolute” cell reference in Microsoft Excel. Be specific.
MIT 6.00 Intro Computer Science (OCW)
  • Stacey Warren - Expert
Hey! We 've verified this expert answer for you, click below to unlock the details :)
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat.
  • chestercat
I got my questions answered at in under 10 minutes. Go to now for free help!
  • maitre_kaio
Do you know the topic here is the MIT Intro Computer Science course ?
  • anonymous
an absolute cell is a cell that doesn't move or change. $a$3 is a3 regardless of where you are referring from. A relative cell is say you add a1 + a2 = and answer shows in a3. Then you copy a3 to b3. The formula for b3 will read b1 + b2. It moved to be b column because it is relative. Same scenario using absolute... a1 + $a$2 = and response shows in a3. copy a3 to b3 and the formula showing in b3 is b1 + $a$2 = b3.

Looking for something else?

Not the answer you are looking for? Search for more explanations.