Year 6
Year 6
What is a spreadsheet?
Link copied to clipboard
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
These resources were created for remote use during the pandemic and are not designed for classroom teaching.
Lesson details
Key learning points
- In this lesson, we will learn that a spreadsheet is a computer application which allows users to organise, analyse, and store data in a table. We will be introduced to the importance of data headings.
Licence
This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.
4 Questions
Q1.
What are the headings in this spreadsheet?

Cost
Fruit
Number Sold
Subtotal
Q2.
How much do apples cost?
£2.40
4
Q3.
What is the third data heading in the table?
Fruit
Sub-total
Q4.
What is the most expensive fruit on the spreadsheet?
Apples
Bananas
Kiwi