Level 1 - Module 2 - Unit 2.4 - Process Numeric Data
This Workbook includes:
Module 2 - Creating and Editing
Unit 2.4 - Process numeric data using simple formula (including sum, subtraction, multiplication, division, maximum, minimum, average) using relative cell references.
Task 1 – Understanding Basic Formulas
Learners are introduced to the structure of simple formulas in spreadsheets. Using a fundraising scenario, they enter data, calculate totals, and use multiplication formulas to work out how much was made from each item sold.
Task 2 – Using the SUM Function
Learners move on to faster, more efficient methods of adding values using the SUM function. They also practice essential spreadsheet formatting such as bold text, borders, and applying currency formats.
Task 3 – Averages, Highest and Lowest
Learners extend their skills by using AVERAGE, MAX, and MIN to analyse sales data. They explore how functions help identify trends, compare results, and summarise findings with automatic calculations.
Task 4 – Practicing Relative Cell References
Learners explore how formulas change when copied down or across cells, using several short practice tables to master relative cell references. They create multiple sheets, rename tabs, and practice accurate formula copying.
Task 5 – Over to You! Creating a Budget Spreadsheet
Learners apply everything from the unit to create a complete monthly budget spreadsheet for a sports club. They calculate:
• total income
• total expenses
• remaining balance (profit or loss)
Every download also includes:
✔ Learner Glossary
✔ Skills & Knowledge Checklist
✔ Guided Tutor Answers (where applicable)
✔ Instant PDF Download