Starter quiz
- Match the term with its definition.
- data⇔facts and figures in their raw form ✓
- row⇔a line of data that runs from left to right ✓
- column⇔a group of data that runs from top to bottom ✓
- cell⇔a rectangular box used to store data ✓
- What is a way to identify a cell?
- 'cell reference' ✓
- Which of these is a cell reference?
- 5 x 5
- BB
- B5 ✓
- 5B
-
- How is data organised in a spreadsheet?
- in circles and triangles
- in rows and columns ✓
- in paragraphs
- in sentences
-
- Why is it important to organise data?
- to make it look pretty
- to keep it secret
- to delete it quickly
- to make it easier to understand ✓
-
- Why is data formatting used in a spreadsheet?
- It delete data automatically
- It make the data look colourful
- It clarify what the data entered represents ✓
- to randomly shuffle the data
-
Exit quiz
- Match the term with its definition.
- calculation⇔working out an answer using numbers ✓
- operation⇔how a calculation is performed ✓
- formula⇔something that performs calculations in a spreadsheet ✓
- Order the steps for creating a formula.
- 1⇔Type the equals sign (=).
- 2⇔Enter the first cell reference.
- 3⇔Add the mathematical operation.
- 4⇔Enter the second cell reference.
- 5⇔Press enter.
- Which operator is used for division in a spreadsheet formula?
- x
- ÷
- / ✓
- *
-
- Write the formula you would use to add a value in cell A1 to a value in cell B1.
- '=A1+B1' ✓
- What happens when you replicate a formula in a spreadsheet?
- The original formula is deleted.
- The formula changes to text.
- The formula is copied and the cell references are adjusted. ✓
- All data is removed.
-
- Order the steps to replicate a formula.
- 1⇔Select the cell with the formula.
- 2⇔Find the small black cross in the bottom right corner of the cell.
- 3⇔Drag the cross to the new location.
- 4⇔Release the mouse button.
- 5⇔Check the new cell references.
Worksheet
Loading worksheet ...
Presentation
Loading presentation ...
Lesson Details
Key learning points
- Formulas in a spreadsheet are used to perform common mathematical operations using data from cells.
- Only cells that have a numerical data format can be used as part of a formula.
- Spreadsheet formulas can use cell references as a part of a calculation.
- Spreadsheet formulas can be duplicated to other cells and change their cell references accordingly.
Common misconception
Spreadsheet forumlas need to use values that are typed directly into the formula.
A formula in a spreadsheet should use cell references where possible. Whilst a forumla can use a typed value, cell references saves having to retype values and also benefits from updating the results of the calculation if data changes.
Keywords
Calculation - working out an answer using numbers and mathematical operations
Operation - a mathematical action like adding, subtracting, multiplying, or dividing numbers
Formula - performs calculations in a spreadsheet
Replicate - to make a copy or repeat something in the same way
+