Spreadsheets: collecting and analysing data
Spreadsheets turn lists of numbers into answers and charts. They are used everywhere, from club budgets to science experiments.
Cells and references
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
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
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.
| Item | A | B |
|---|---|---|
| 2 | Ava | 12 |
| 3 | Ben | 15 |
| 4 | Cal | 9 |
| 5 | Dee | 18 |
| 6 | Eli | 11 |
Using the table of quiz marks in B2:B6, what does =AVERAGE(B2:B6) give?
- Total: 12 + 15 + 9 + 18 + 11 = 65.
- Divide by 5: 65 รท 5 = 13.
Answer: 13
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.
- 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).
Try two quick questions
See if it has sunk in. Answers are marked straight away.
2 more questions
Try each one, then tap to check.
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.
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.
Facts checked against the sources below, 27 October 2026. Last updated 2 October 2026. Spotted a mistake? Tell us and we will fix it.