Learners will calculate data using the operations of multiplication, subtraction, division, and addition. They will use these operations to create formulas in a spreadsheet. Learners will then begin to understand the importance of creating formulas that include a range of cells and the advantage of duplicating in order to apply formulas to multiple cells.
Learning objectives
To apply formulas to data
- I can calculate data using different operations
- I can create a formula which includes a range of cells
- I can apply a formula to multiple cells by duplicating it
Worksheet 1 18.8KB
Worksheet 2 5.1KB
Worksheet 326.9KB