Spreadsheets

6 min · 10 quiz questions

Year 7 · Office skills · Lesson 17. This lesson goes with level 18 of the Byte Lab game. Play the level first, then use this page to revise. In Year 8 you will go further with formulas, functions and charts.

Learning objectives. By the end of this lesson you should be able to name cells and enter data quickly; lay out a clear table; use AutoFill to continue a pattern; add up a column with AutoSum; and sort and filter a table to find answers.

In this lesson

  • What is a spreadsheet?
  • Entering data
  • AutoFill and the fill handle
  • Adding up with AutoSum
  • Sort and filter
  • Shortcuts to know
  • Real mission: my reading log
  • Revision checklist