Free November promotion: everything is free until 30 November 2026 — every subject, unlimited practice.
Subjects / TY Digital Literacy / Digital tools and skills

Spreadsheets basics

Enter data, use cell references and simple formulas such as SUM and AVERAGE, and make charts.

In review Transition Year Common
15practice questions

Fill the gaps: 1 · Multiple choice: 6 · Numeric answer: 5 · Put in order: 1 · Short answer: 1 · Written answer (self/teacher assessed): 1

Each question has up to three hints, a worked explanation, and is tracked in your progress and review plan.

Practise this topic

Try a question

Numeric answer
Cells A1 to A4 contain 26, 22, 7 and 16. What value does =SUM(A1:A4) display?
Whole numbers, decimals (2.5) or fractions (3/4).
Hint 1

SUM adds all the cells in the range.

Create a free account to save your progress.