Formula structure and cell references in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the basic structure of a formula in Google Sheets?

A formula always starts with an equal sign =, followed by the function or expression you want to calculate, like =A1+B1.

beginner

What does a cell reference like A1 mean in a formula?

It points to the cell located at column A and row 1. The formula uses the value inside that cell for calculations.

intermediate

What is the difference between relative and absolute cell references?

Relative references (like A1) change when you copy the formula to another cell. Absolute references (like $A$1) stay fixed no matter where you copy the formula.

beginner

How do you write an absolute reference for column A and row 1?

Use dollar signs before the column letter and row number: $A$1. This locks both the column and row.

beginner

Why do formulas start with an equal sign = in Google Sheets?

The equal sign tells Google Sheets that what follows is a formula to calculate, not just text or a number.

What does the formula =B2+C2 do?

A Divides B2 by C2

B Subtracts C2 from B2

C Adds the values in cells B2 and C2

D Multiplies B2 and C2

The plus sign + adds the values in the two referenced cells.

If you copy the formula =A1+B1 from row 1 to row 2, what will the formula become?

A <code>=A3+B3</code>

B <code>=A1+B1</code>

C <code>=B1+C1</code>

D <code>=A2+B2</code>

Relative references adjust based on the new row, so row 1 changes to row 2.

Which formula locks the reference to cell A1 when copied?

A <code>=$A$1</code>

B <code>=A1</code>

C <code>=B$1</code>

D <code>=A$1</code>

Dollar signs before both column and row lock the reference completely.

What symbol must a formula start with in Google Sheets?

A =

B #

C +

D $

Formulas always start with an equal sign =.

What happens if you write a formula without the equal sign?

A Google Sheets calculates it anyway

B It is treated as text, not a formula

C It causes an error

D It becomes a comment

Without =, Google Sheets treats the input as plain text.

Explain how relative and absolute cell references work in Google Sheets formulas.

Think about what happens when you copy a formula to another cell.

Describe the basic parts of a formula in Google Sheets and why the equal sign is important.

Imagine explaining to a friend why you type = before a calculation.