T19 Budget spreadsheet with formulas

Category: Data. Pass at at least 4/5.

All 40 tasks

Prompt

Build an .xlsx budget from expenses.csv: one sheet with the data, one summary sheet with totals per month and per category using formulas (not hard-coded numbers), and a grand total.

Inputs

Files attached to the chat:

• expenses.csv

Checklist

Pass at at least 4/5.

• .xlsx opens; 2 sheets
• The summary uses formulas (SUMIFS or similar)
• Totals per month match the answer key
• Totals per category match
• Grand total matches

The answer key is not published while the task set is in use.