Task 1 of 4
In B8 and C8, calculate the totals for the budget and the actual.
Lesson theory
The final project brings everything together: sums, IF, percentages, absolute references, and formats.
The task is to see where the family went over budget and what share of spending each category takes.
- Variance = actual − budget (a positive variance is overspending);
- A category's share = the category's actual / total actual. Anchor the total with $.
Practice is part of Pro
The live spreadsheet, task checking and .xlsx files in all 170 lessons. Your progress is saved in this browser; sync across devices is coming soon.