tells you the location of a cell and is made from the column letter and row number, separated by a colon

a tool used in a spreadsheet to replicate cell data across a range of cells

Spreadsheet calculations

Computing

Formatting data in a spreadsheet

Collecting data for a purpose

Analysing and visualising data

Sorting and searching data

Applying conditional formatting to data

By the end of this unit pupils should be able to model data within a spreadsheet. Pupils will progress from using basic formulas to using inbuilt functions. Pupils will apply sorting and searching techniques to data and explore how conditional formatting can be used to present data effectively.

Data modelling

What is the primary function of the fill handle tool in spreadsheets?

Right-click a cell and select "Fill Down."

Drag the fill handle (a small square in the corner of the selected cell).

How can you activate the fill tool in most spreadsheet programs?

a way to format cells with colours and borders

a formula that calculates the sum of a range of cells

an address or name of a cell in the spreadsheet

a feature that merges two or more cells together

What is a cell reference in a spreadsheet?

What must all formulas in spreadsheet calculations start with?

to apply colour to the background of selected cells

to change the font colour of text in a cell

What is the primary purpose of the paint bucket fill tool in spreadsheets?

Which of these icons would you use to apply a border to a cell?

to highlight important cells or rows for better visibility

to delete data from multiple cells at once

to merge multiple cells into a single one

Which of the following is a common use for the background fill tool?

by adding borders around cells automatically

by creating a contrast between the background and the text

How does using the background fill tool enhance readability in a spreadsheet?

Lesson video

File you will need for this lesson