What is the difference between relative and absolute cell references?

What is the difference between relative and absolute cell references?

• A. Relative references always stay the same; absolute change when copied.
• B. Relative references reference the entire column; absolute references reference a single cell.
• C. Relative references require $; absolute references do not.
• D. Relative references change when copied; absolute references use $ (e.g., $A$1) and do not change.

Answer: (C)

When you copy a formula, the type of cell reference determines how it behaves. Relative references are not fixed; they adjust based on where you paste the formula. For example, if a formula refers to A1 and you copy it one row down, the reference becomes A2. If you copy it across a column, it becomes B1, and so on. Absolute references are fixed; you lock them with dollar signs like $A$1, which keeps that exact cell when you copy the formula anywhere else. So the key difference is that relative references change when copied, while absolute references use $ to stay the same. Mixed references exist (such as $A1 or A$1) where either the column or the row is fixed, but the general distinction centers on whether the reference moves with the formula or stays put.

When you copy a formula, the type of cell reference determines how it behaves. Relative references are not fixed; they adjust based on where you paste the formula. For example, if a formula refers to A1 and you copy it one row down, the reference becomes A2. If you copy it across a column, it becomes B1, and so on. Absolute references are fixed; you lock them with dollar signs like $A$1, which keeps that exact cell when you copy the formula anywhere else. So the key difference is that relative references change when copied, while absolute references use $ to stay the same. Mixed references exist (such as $A1 or A$1) where either the column or the row is fixed, but the general distinction centers on whether the reference moves with the formula or stays put.