Relative references (A1) in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a relative reference in Excel?

A relative reference in Excel is a cell reference that changes when you copy or move a formula to another cell. It adjusts based on the formula's new location.

beginner

How does the formula =A1+B1 behave when copied from row 1 to row 2?

When copied from row 1 to row 2, the formula changes to =A2+B2 because the references adjust relative to the new row.

beginner

Why are relative references useful in spreadsheets?

They let you write one formula and reuse it in many cells without changing the formula manually. Excel adjusts the references automatically.

beginner

What happens if you copy a formula with relative references across columns?

The column letters in the cell references change relative to the new column position. For example, copying =A1 one column to the right becomes =B1.

intermediate

Explain the difference between relative and absolute references in Excel.

Relative references change when copied to another cell, while absolute references stay fixed. Absolute references use dollar signs like $A$1 to lock the cell.

If you have the formula =B2+C2 in cell D2 and copy it to cell D3, what will the formula be?

A =B3+C3

B =B2+C2

C =C2+D2

D =B4+C4

Relative references adjust based on the new row, so B2 and C2 become B3 and C3 when copied down one row.

What symbol is used to make a cell reference absolute, not relative?

A #

B &

C $

D *

The dollar sign ($) locks the column, row, or both to make the reference absolute.

When copying a formula with relative references across columns, what changes?

A Row numbers change

B Both row and column stay the same

C Formula becomes static

D Column letters change

Copying across columns changes the column letters in the references relative to the new position.

Which of these is a relative reference?

A A$1

B A1

C $A1

D $A$1

A1 without dollar signs is a relative reference that changes when copied.

Why might you prefer relative references when creating formulas?

A They automatically adjust to new locations

B They never change when copied

C They make formulas harder to read

D They lock the cell reference

Relative references adjust automatically, saving time and effort when copying formulas.

Describe what happens to relative cell references when you copy a formula to a new cell.

Think about how Excel changes cell addresses when you move formulas.

Explain the difference between relative and absolute references and when you might use each.

Consider dollar signs and how formulas behave when copied.