Sample dataset answer key
Check your practice totals, formulas, and chart expectations.
Current pagePractice support
Sample dataset answer key
Use this page after completing the practice tasks with the sample sales CSV.
Dataset totals
- Total rows: 10 orders
- Total quantity: 190 units
- Total revenue: 650.40
- Average revenue per order: 65.04
- Lowest order revenue: 37.20
- Highest order revenue: 90.00
Revenue by region
- West: 126.00
- East: 225.30
- North: 105.30
- South: 193.80
Revenue by status
- Done: 417.30
- In Progress: 197.10
- Blocked: 36.00
Suggested formulas
If `Quantity` is in column F and `Unit Price` is in column G, calculate revenue in a new `Total` column:
=F2*G2Total revenue:
=SUM(H2:H11)Average order revenue:
=AVERAGE(H2:H11)Chart checks
- A bar chart by region should show East as the highest revenue region.
- A status summary should show Done as the largest revenue group.
- A date trend should show one order per day from 2026-05-01 to 2026-05-10.
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.
Open resource