What you will build

Make the Personal budget table predictable by giving each column one clear field (Date, Category, Description, Amount, Status) and keeping dates, numbers, text, and statuses consistent.

Learning objectives

Open the practice workbook

HANDS-ON PRACTICE

Practice in your own copy

Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.

Make a Google Sheets copy (access required) ↗View original

Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.

The live _result workbook shows the clean five-column Personal budget dataset before the audit action.

Hands-on practice

Step 1: Review every column header and make it describe exactly one field.

Step 2: Check each column for one consistent data type; convert dates/numbers that are stored as text before building formulas or filters.

Step 3: Add one test value per column and confirm Sheets interprets it the same way as existing rows, then remove the test row.

A temporary test row is entered in the live _result workbook to verify Date, text, Amount, and Status values are interpreted consistently with the existing rows.

Checkpoint

DateCategoryDescriptionAmountStatus
2026-09-01IncomeSalary1500Posted
2026-09-02FoodGroceries85Posted
2026-09-03TransportBus pass30Planned
2026-09-05HousingRent700Planned

Checkpoint for “Design headers and data types for Personal budget”: the Date, Category, Description, Amount, Status columns and sample records must still match this table after the lesson action.

The temporary row has been removed and the live _result workbook is restored to the four-row checkpoint dataset.

Common mistakes and fixes

Correction: return to the exact range and command named in the steps, then compare the live sheet with the Date, Category, Description, Amount, Status source fields.

Independent practice

Add one row with the same schema, repeat the action, verify the new row behaves correctly, then remove it to restore the sample.

Key takeaways

  • ✓Make the Personal budget table predictable by giving each column one clear field (Date, Category, Description, Amount, Status) and keeping dates, numbers, text, and statuses consistent.
  • ✓Review every column header and make it describe exactly one field.
  • ✓Check each column for one consistent data type; convert dates/numbers that are stored as text before building formulas or filters.
  • ✓If the result differs, repeat “Review every column header and make it describe exactly one field.” and then “Check each column for one consistent data type; convert dates/numbers that are stored as text before building formulas or filters.”. Verify the working table still uses Date, Category, Description, Amount, Status before changing source values.
  • ✓Add one row with the same schema, repeat the action, verify the new row behaves correctly, then remove it to restore the sample.
QUICK CHECK

Check your understanding

Answer four questions about the practice sheet.

1. What is the correct first action in “Design headers and data types for Personal budget”?
2. Which follow-up action belongs to “Design headers and data types for Personal budget”?
3. What should you verify before “Design headers and data types for Personal budget” is complete?
4. Which correction is appropriate if “Design headers and data types for Personal budget” behaves unexpectedly?

Next lesson

Continue in recommended learning order with Add safe dropdowns to Personal budget.