Spreadsheets: collecting and analysing data

Spreadsheets turn lists of numbers into answers and charts. They are used everywhere, from club budgets to science experiments.

Practise this lesson free (6 questions)

More tools

Cells and references

A spreadsheet is a grid of cells. Columns have letters and rows have numbers.
Each cell has a cell reference: B3 is column B, row 3.
A range is a block of cells, written with a colon: A1:A5 means A1, A2, A3, A4 and A5.

Formulas and functions

A formula starts with = and calculates a value, for example =B2*C2.
Functions save time:
=SUM(B2:B6) adds up the cells, =AVERAGE(B2:B6) finds the mean, =MAX finds the biggest and =MIN the smallest.
If a number changes, every formula that uses it updates automatically.

Collecting and presenting data

Data can be collected with an online form or survey, then analysed in a spreadsheet.
Sort and filter to find patterns, and use a chart to show results clearly: a bar chart to compare groups, a line graph for changes over time, a pie chart for parts of a whole.
Check the data is accurate: a typing mistake gives wrong answers.
Quiz marks in cells B2:B6.
ItemAB
2Ava12
3Ben15
4Cal9
5Dee18
6Eli11
Worked example

Using the table of quiz marks in B2:B6, what does =AVERAGE(B2:B6) give?

  1. Total: 12 + 15 + 9 + 18 + 11 = 65.
  2. Divide by 5: 65 รท 5 = 13.

Answer: 13

Key idea

Cells are named by column and row (B3). Formulas start with =. SUM, AVERAGE, MAX and MIN work on ranges like B2:B6 and update automatically. Choose a chart that suits the data.

Key words
AND
A Boolean operator that gives True (1) only when both inputs are True.
Spreadsheet
A program that stores data in a grid of cells and calculates with formulas, such as =SUM(B2:B6).

All KS3 Computing key terms and definitions โ†’

Quick check

Try two quick questions

See if it has sunk in. Answers are marked straight away.

Extra practice

2 more questions

Try each one, then tap to check.

  1. Quiz marks in B2:B5 are 14, 8, 17, 11. What does =SUM(B2:B5) give?

    Show the answer

    Answer: 50

    SUM adds the cells: 14 + 8 + 17 + 11 = 50.

  2. Quiz marks in B2:B6 are 12, 15, 9, 18, 11. What does =MIN(B2:B6) give?

    Show the answer

    Answer: 9

    MIN gives the smallest value: 9.

Check you have got it

Answer 6 quick questions with instant marking. If you get one wrong, GCSE-ready shows you why and gives you another go. It is free, and you do not need an account.

Video for this lesson coming soon. Subscribe on YouTube

Sources and references

Facts checked against the sources below, 27 October 2026. Last updated 2 October 2026. Spotted a mistake? Tell us and we will fix it.