3.11: Hands-on Exercise - Formatting a Monthly Budget Report

Introduction to Spreadsheets (BSOT 112) · LibreTexts

0%

Contents

    Text

    Size
    100%
    Theme
    Typeface
    Line length
    Spacing

    Read aloud

    How

    Speed: 1×
    Light up
    Highlight

    Symbols: Mulberry Symbols, © 2018–2026 Steve Lee, CC BY-SA 4.0 (licence, the set), the site's own copies.

    From LibreTexts, under CC BY-NC-SA 4.0, as the source states it; its equations are written in TeX, which the PDF shows typeset. This page at LibreTexts.

    3.11: Hands-on Exercise - Formatting a Monthly Budget Report

    Hands-on Exercise: Formatting a Monthly Budget Report

    Create a clean, professional budget worksheet using proper font, number, and conditional formatting.

    Instructions:

    1. Open a new workbook and rename the sheet Monthly_Budget.
    2. In columns A–C, enter Category, Planned Amount, and Actual Amount.
    3. Enter at least 10 expense categories (e.g., Rent, Groceries, Utilities, Transportation, Entertainment).
    4. In column D, create a formula for Difference:
      =C2-B2
      (This shows over/under budget amounts.)
    5. Apply the following number formats:
      • Planned and Actual Amounts → Currency ($)
      • Difference → Currency ($) with red for negatives.
    6. Use conditional formatting to highlight:
      • Red fill for “Over Budget” (Difference < 0)
      • Green fill for “Under Budget” (Difference ≥ 0)
    7. Apply a Heading 1 cell style to the title row and bold borders around the data table.
    8. Center the title across columns using Merge & Center, then increase font size to 14 pt.
    9. Add a footer that includes your name and the date.
    10. 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.