A community for students.

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing


  • 4 years ago

Describe the difference between a “relative” cell reference and an “absolute” cell reference in Microsoft Excel. Be specific.

  • This Question is Closed
  1. maitre_kaio
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    Do you know the topic here is the MIT Intro Computer Science course ?

  2. anonymous
    • 4 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    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.

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

    • Attachments:

Ask your own question

Sign Up
Find more explanations on OpenStudy
Privacy Policy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...


  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.