Year 8 · Chapter 7 Spreadsheets · Lesson 1. This lesson goes with level 1 of the Byte Lab Year 8 game. Play the level first, then use this page to revise.
Learning objectives. By the end of this lesson you should be able to name any cell with its cell reference; use the Name Box and the formula bar; fill a table quickly with Tab and Enter; write formulas with + - * / and brackets; explain why a formula should use cell references, not numbers; and fix common formula mistakes.