Sample dataset answer key
Check your practice totals, formulas, and chart expectations.
Open resourceFinal project
Spreadsheet capstone mini-project
Use the sample sales dataset to practice the complete workflow: import, clean, analyze, visualize, and share.
Project goal
Build a simple sales reporting workbook that a teammate can review and reuse next month.
Required sheets
- Raw_Data: imported sample CSV without manual edits
- Clean_Data: formatted and validated table with a calculated total column
- Analysis: revenue summaries by region, product, and status
- Dashboard: key metrics, one trend chart, and one comparison chart
- Change_Log: final note explaining what changed and when
Completion checklist
- Dates use one consistent format
- Revenue is calculated from quantity and unit price
- Filters are enabled on clean data
- Summary totals match the answer key
- Dashboard charts use clear titles and units
- Formula cells are visually separated from input cells
- Change log includes at least one final review note
Suggested final output
Your dashboard should show total revenue, total quantity, average revenue per order, revenue by region, and revenue by status.
Resource flow
Keep moving through the guide
This page belongs to Spreadsheet workflow guide and connects to the surrounding steps below.
Parent resource
Spreadsheet workflow guide
Sibling resources
Spreadsheet capstone mini-project
Practice the full spreadsheet workflow in one final project.
Current page