Relative references in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a relative reference in Google Sheets?

A relative reference changes when you copy a formula to another cell. It adjusts based on the new cell's position.

beginner

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

It 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 it manually. The references update automatically.

beginner

If you copy a formula with relative references across columns, what happens?

The column letters in the references change relative to the new column position.

beginner

What is the difference between relative and absolute references?

Relative references change when copied; absolute references stay fixed using $ signs (like $A$1).

What happens to a relative reference when you copy a formula down one row?

A It becomes an absolute reference

B It changes to refer to the next row

C It changes to refer to the previous row

D It stays the same

Relative references adjust based on the new cell's position, so copying down one row changes the row number in the reference.

If a formula in cell B2 is =A1 and you copy it to cell C3, what will the formula become?

A <code>=B1</code>

B <code>=A1</code>

C <code>=B2</code>

D <code>=C2</code>

Copying from B2 to C3 moves one column right and one row down, so the reference shifts from A1 to B2.

Which symbol is NOT used in a relative reference?

A $

B A

C 1

D None of the above

The $ symbol is used for absolute references, not relative references.

Why might you want to use relative references in a spreadsheet?

A To prevent formulas from calculating

B To keep references fixed when copying

C To lock cells from editing

D To make formulas update automatically when copied

Relative references let formulas adjust automatically when copied to new cells.

If you copy a formula with relative references from column A to column C, how do the references change?

A They shift two columns to the right

B They stay the same

C They shift two columns to the left

D They become absolute references

Copying from column A to C moves two columns right, so relative references update accordingly.

Explain what a relative reference is and how it behaves when copying formulas in Google Sheets.

Think about how cell addresses change when you drag a formula down or across.

Describe a real-life situation where using relative references in a spreadsheet saves time.

Imagine you have a list of prices and want to calculate totals for many rows.