Skip to main content
SingaporeComputer ScienceSyllabus dot point

How is a spreadsheet organised, and how do formulae let it recalculate automatically?

Describe how a spreadsheet is organised into cells, rows and columns, and write formulae using cell references and operators

A focused answer to the O-Level Computing point on spreadsheet basics. Cells, rows and columns, cell references, writing formulae with operators, and why formulae recalculate automatically when data changes.

Generated by Claude Opus 4.86 min answer

Reviewed by: AI editorial process; not yet individually human-reviewed

Have a quick question? Jump to the Q&A page

Jump to a section
  1. What this dot point is asking
  2. The answer
  3. Examples in context
  4. Try this

What this dot point is asking

SEAB wants you to describe how a spreadsheet is laid out, in cells arranged into rows and columns, and to write formulae that use cell references and operators. The central idea is that a formula refers to cells rather than to fixed numbers, so the spreadsheet recalculates automatically whenever the underlying data changes.

The answer

How a spreadsheet is organised

A spreadsheet is a grid. The vertical strips are columns, labelled with letters (A, B, C, ...). The horizontal strips are rows, numbered (1, 2, 3, ...). The box where a column and row meet is a cell. Each cell has an address called a cell reference, made of its column letter and row number, such as B2 (column B, row 2).

A cell can hold one of three things: a number (such as 4242), text (a label such as "Price"), or a formula (a calculation that starts with =).

Writing a formula

A formula always begins with an equals sign, =. After that you combine cell references and operators:

=B2*C2      multiply B2 by C2
=A1+A2+A3   add three cells
=(B2-C2)/D2 subtract, then divide

The common operators are + (add), - (subtract), * (multiply) and / (divide). Brackets control the order, just as in mathematics.

Why formulae use references, not numbers

If you typed =5*3 you would get 1515, but if the price changed you would have to edit the formula. By writing =B2*C2 instead, the formula reads whatever values are in those cells. When B2 or C2 changes, the spreadsheet recalculates the formula automatically and shows the new result. This is the whole point of a spreadsheet: live, self-updating calculations.

A cell shows a result, but stores a formula

The cell displays the calculated value (for example 1515), but what is stored is the formula (=B2*C2). Clicking the cell reveals the formula in the formula bar.

Examples in context

Example 1. A class budget. A teacher lists item costs in column B and uses =SUM(B2:B20) in a total cell. When a price is updated or a new item added, the total recalculates instantly, so the budget is always current without manual addition.

Example 2. A fitness log. An athlete records daily distances in a column and computes a weekly total with a formula. Because each total references the day cells, fixing a mis-typed distance updates the week's total automatically, keeping the log consistent.

Try this

Q1. State the cell reference for the cell in column C, row 5. [1 mark]

  • Cue. C5.

Q2. Write a formula to add the values in cells A1, A2 and A3. [2 marks]

  • Cue. =A1+A2+A3.

Q3. Explain why a formula =B2*C2 is better than typing the answer 15 directly into a cell. [2 marks]

  • Cue. The formula recalculates automatically when B2 or C2 changes, keeping the result correct without re-typing.

Exam-style practice questions

Practice questions written in the style of SEAB exam questions on this dot point, with worked answer explainers. The year tag is the paper they imitate, not the source.

Original4 marksA shop records prices in cells. Cell B2 holds the unit price 55 and cell C2 holds the quantity 33. (a) Write a formula in cell D2 to calculate the total cost. (b) Explain what happens to D2 if the value in C2 is changed to 1010, and why.
Show worked answer →

(a) The formula in D2 multiplies the unit price by the quantity:

=B2*C2

With B2 = 55 and C2 = 33, D2 shows 1515.

(b) When C2 is changed to 1010, D2 automatically recalculates to 5×10=505 \times 10 = 50. This is because the formula refers to the cells B2 and C2 rather than the fixed numbers, so the spreadsheet re-evaluates it whenever a referenced cell changes.

Markers reward the formula =B2*C2, the recalculated value 5050, and the reason that formulae use cell references so they update automatically.

Original4 marks(a) Explain the difference between entering =A1+A2=A1+A2 and entering A1+A2A1+A2 into a cell. (b) Give one advantage of using a formula with cell references rather than typing the answer directly.
Show worked answer →

(a) Entering =A1+A2 starts with an equals sign, so the spreadsheet treats it as a formula: it adds the values in cells A1 and A2 and displays the result. Entering A1+A2 with no equals sign is treated as plain text, so the cell simply shows the characters "A1+A2".

(b) Using a formula means the result updates automatically whenever A1 or A2 changes, so the data stays correct without re-typing. It also makes the calculation visible and reusable, reducing the chance of arithmetic mistakes.

Markers reward the equals sign making it a formula (versus text), and an advantage such as automatic recalculation or fewer errors.

Related dot points