SHSubjectHub

Formulas and Functions: SUM, AVERAGE, MIN & MAX (Excel)

KS3Lesson packSubscription
Also online

This worksheet marks itself

Set it as homework or classwork and every answer is marked as pupils go, with feedback on what they got wrong. The scores go straight into your mark book, so you can see who needs help before the next lesson.

  • 12 questions
  • 32 marks
  • about 35 minutes
  • marked instantly

Question types: short answer, calculation, multiple choice, true or false, fill the gap.

Try it with a class, freeHow it works

Try one from this worksheet

Which formula would you type into a cell to add up every number in the range B2:B5?

Pick an answer: it's marked straight away, just as your pupils would see it.

About this resource

Data Detective (Excel track), Lesson 2 — what a formula is, cell references and operators, and the SUM, AVERAGE, MIN and MAX functions, using a school tuck shop as the real-world context. I do / we do / you do for the formula and for the function family, two hinge polls on the classic mix-ups, an…

23 slides.

Lesson outline

  1. Hook — Which Snack Made the Most Money?
  2. Open the Real File
  3. Do Now — Retrieval
  4. Keywords for This Lesson
  5. Building a Formula — Cell References and Operators
  6. I Do — Water's Takings
  7. Hinge Check — Spot the Working Formula
  8. We Do — Crisps' Takings Together
  9. Excel Task — Finish the Takings Column
  10. Functions — Ready-Made Formulas
  11. I Do — Total Takings with SUM
  12. We Do — Average Takings Together
Unit bundleData Detective (Excel)
Part of: Data Detective (Excel): the whole unitEvery resource in the unit in one zip.

More from Data Detective (Excel)