British English CC

Formatting a spreadsheet

Computing

This unit introduces pupils to how spreadsheets can be used to organise data and create their own data sets. They will discover the importance of formatting data to support calculations, while also examining how formulas can be used to produce calculated data and how graphs can present this data.

Introduction to spreadsheets

What is a rectangular box in a spreadsheet used to store data called?

to ensure that data is displayed correctly

Why is it important to format cells in a spreadsheet?

What should you do if spreadsheet software doesn't format data correctly?

Order these steps for formatting a cell in a spreadsheet.

a line of data in a table that runs from left to right

a group of data in a table that runs from top to bottom

where the doors and windows are in the room

How can you tell where things are kept in the classroom?

In a spreadsheet, what is used to organise data in a group running from the top to the bottom?

What is a line of data in a spreadsheet that runs from left to right?

This lesson will be removed by end of Summer Term 2025.

Formatting a spreadsheet

Lesson outcome

This lesson will be removed by end of Summer Term 2025.