IF and charts

5 min · 10 quiz questions

Year 8 · Chapter 7 Spreadsheets · Lesson 3. This lesson goes with level 3 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 write an IF formula with a comparison; predict what an IF shows; fix common IF mistakes; choose between a column, line and pie chart; and check that a chart has a title, labelled axes and an honest scale.

In this lesson

  • Making decisions with IF
  • Comparison signs
  • Text needs quotes
  • Common IF mistakes
  • Choosing a chart
  • A good chart
  • Shortcuts to know
  • Real mission: run a class survey
  • Revision checklist