✨ Free preview
📊
Spreadsheet functions
Predict exactly what SUM, AVERAGE, COUNTIF and IF will return when applied to a real data table.
⏱ 20 min❓ 8 questions
What you'll be able to do
- ✔I can predict the result of SUM, AVERAGE, MAX and MIN on a range
- ✔I can write and evaluate COUNTIF with a condition
- ✔I can predict what an IF formula returns for a given cell
How this works
- 1Read the short explanations first — they teach you what you need before each question.
- 2Answer each question, then tap Check. A right answer moves you on automatically; if it's wrong, you'll see a friendly explanation of why.
- 3Finish all 3 steps to see your score — sign in and subscribe to unlock the full lesson and save it.
What's inside
8 questions and 1 quick teaching card, including:
- 🔢Number answer — Work out the answer and type the number.
👪Grown-up tip: sit alongside younger learners for the first few lessons. Read the questions together and chat about the explanations — that's where the real learning sticks.
Sign in and subscribe to unlock the full lesson and save your progress.
Curriculum: AC9TDI8P02