Cells and formulas

7 min · 10 quiz questions

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.

In this lesson

  • What is a spreadsheet?
  • Cells, rows and columns
  • Moving and typing with the keyboard
  • Formulas
  • Use cell references, not numbers
  • Common mistakes
  • Shortcuts to know
  • Real mission: build a pocket money tracker
  • Revision checklist