← Excel Sales Reporting
Lesson 4 of 4
Audit a report
Reconcile totals with an independent calculation.
Do the work
- Compare displayed totals with the source rows.
- Calculate quantity × unit price before summing.
- A checksum catches a missing line but does not prove every business rule.
See the method
Two units at 3 dollars gives 6.
Read every demonstration step
- Two units at 3 dollars gives 6.
- One unit at 12 gives 12.
- The report total should be 18.
Practice independently
Exercise 1
Fix line item calculations
Open practice →Exercise 2Reconcile a summary total
Open practice →Take it further
Use independent counts and totals in a handoff checklist.