Level 1 - Module 2 - Unit 2.6 - Formatting Numeric Data
This Workbook includes:
Module 2 - Creating and Editing
Unit 2.6 Format numeric data (including font sizes, font styles, alignment, cell formatting, merging cells, splitting cells, row height, column width).
Task 1 – Formatting Oliver’s Monthly Outgoings
Learners enter Oliver’s expenses and apply key formatting skills, including bold headings, currency formatting, alignment, and column adjustments. This introduces clear and professional presentation of financial data.
Task 2 – Adding Income Data
Learners add Oliver’s income to the same spreadsheet, matching font styles, applying colour-coded headings, centre-aligning amounts, and using borders. They learn the importance of consistency when presenting financial information.
Task 3 – Creating a Monthly Summary with Formulas
Learners build a “Monthly Summary” section and use SUM formulas to calculate total outgoings, total income, and money remaining. They merge headings, format totals, and begin to understand how spreadsheets support budgeting.
Task 4 – Managing Unexpected Changes
Learners add “Extra Costs” and “Bonus Income” to simulate real-life financial changes. They update formulas, adjust layouts, apply borders, and practise merging and unmerging cells. This develops flexibility and problem-solving within spreadsheets.
Task 5 – Over to You! Creating a Personal Budget
Learners design their own simple budget spreadsheet, using headings, formatting, numeric data, and formulas. A structured checklist supports independent working and ensures success criteria are met.
Spreadsheets Included:
This resource includes a learner spreadsheet for all tasks and tutor-completed spreadsheets for Tasks 1–4 (with correct figures only).
Spreadsheets Included:
This resource includes learner spreadsheets for all tasks and tutor-completed spreadsheets for Tasks 1–4 (with correct figures only).
The unit ends with a 10-question recap quiz to reinforce learning.
Every download also includes:
✔ Learner Glossary
✔ Skills & Knowledge Checklist
✔ Guided Tutor Answers (where applicable)
✔ Instant PDF Download