Opening the book…
Hands-on Exercise: Formatting a Monthly Budget Report
Create a clean, professional budget worksheet using proper font, number, and conditional formatting.
Instructions:
- Open a new workbook and rename the sheet Monthly_Budget.
- In columns A–C, enter Category, Planned Amount, and Actual Amount.
- Enter at least 10 expense categories (e.g., Rent, Groceries, Utilities, Transportation, Entertainment).
- In column D, create a formula for Difference:
=C2-B2
(This shows over/under budget amounts.) - Apply the following number formats:
- Planned and Actual Amounts → Currency ($)
- Difference → Currency ($) with red for negatives.
- Use conditional formatting to highlight:
- Red fill for “Over Budget” (Difference < 0)
- Green fill for “Under Budget” (Difference ≥ 0)
- Apply a Heading 1 cell style to the title row and bold borders around the data table.
- Center the title across columns using Merge & Center, then increase font size to 14 pt.
- Add a footer that includes your name and the date.
- Save as CH3_Formatted_Budget.xlsx.
Challenge Extension:
Apply a theme and use Page Layout → Fit All Columns on One Page to prepare a printable version of your report.
This page titled 3.11: Hands-on Exercise - Formatting a Monthly Budget Report was last modified on Sun, 14 Dec 2025 03:53:52 GMT and is shared under a CC BY-NC-SA 4.0 license and was authored, remixed, and/or curated by Gabrielle Brixey.
The book could not be loaded just now.