Starter quiz
- What is the primary purpose of the paint bucket fill tool in spreadsheets?
- to apply colour to the background of selected cells ✓
- to fill cells with the same content
- to merge cells into a single cell
- to change the font colour of text in a cell
-
- Which of these icons would you use to apply a border to a cell?
- Which of the following is a common use for the background fill tool?
- 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
- to convert text into uppercase
-
Name the cell range of these cells.- 'A5:C7' ✓
Name the cell range of these cells.- 'A2:A6' ✓
- How does using the background fill tool enhance readability in a spreadsheet?
- by adding borders around cells automatically
- by creating a contrast between the background and the text ✓
- by sorting data alphabetically
- by automatically resizing the columns
-
Exit quiz
- What is the primary function of the fill handle tool in spreadsheets?
- to fill cells with colour
- to copy cell content ✓
- to merge selected cells
- to sort data in ascending order
-
- How can you activate the fill tool in most spreadsheet programs?
- Right-click a cell and select "Fill Down."
- Drag the fill handle (a small square in the corner of the selected cell). ✓
- Use the "Insert" menu and choose "Fill."
- Press Ctrl + F.
-
- What is a cell reference in a spreadsheet?
- 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 must all formulas in spreadsheet calculations start with?
- = ✓
- *
- /
- +
-
Worksheet
Loading worksheet ...
Presentation
Loading presentation ...
Video
Lesson Details
Key learning points
- Formulas are used in spreadsheets to perform arithmetic calculations.
- Cell references are used in formulas to use values stored in other parts of the spreadsheet.
- Formulas that use cell references recalculate when the values in those reference cells change.
- The fill handle tool can easily replicate formulas and data across a range of cells.
Common misconception
Pupils may believe that each time data is changed in a spreadsheet the formulas will also need to be changed.
Using cell references within a formula means that the formula will recalculate when the values in those reference cells change.
Keywords
Formula - performs calculations in a spreadsheet
Cell reference - tells you the location of a cell and is made from the column letter and row number, separated by a colon
Fill handle - a tool used in a spreadsheet to replicate cell data across a range of cells
+