a part of an overall total based on some of the values

Event planning using a spreadsheet

British English CC

Computing

Collecting data

Formatting a spreadsheet

Spreadsheet formulas

Using formulas in a spreadsheet

Presenting data using charts

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

something that identifies a specific cell

by providing useful tools and allowing changes

How do spreadsheets make planning an event easier?

What is the smallest unit of data storage in a spreadsheet where you can enter information?

to copy the formula to multiple cells, with cell references adjusting as needed

What does it mean to replicate a formula in a spreadsheet?

to eliminate the need for financial records

Order these steps for using a spreadsheet when budgeting.

Put these steps for dealing with data in the correct order.

What symbol is used to start a formula in a spreadsheet?

What do you call a group of cells used in a formula?

Write the formula to subtract cell A5 from B8.

What does the SUM function do in a spreadsheet?

What does the term 'replicate' mean in the context of spreadsheets?

Starter Quiz

Put these steps for dealing with data in the correct order.