Excel practice exercises

Real situations from working spreadsheets — sales targets, commission tiers, messy exports, aged invoices. Numbered in recommended order: start at 1 and work down, or filter to what you need.

2 exercises — Data Analysis · for Accounting

Sort:Recommended Difficulty Newest

IntermediateData Analysis
Which range does SUMIFS want first?
Recall the argument order that differs between SUMIF and SUMIFS.
SUMIF · SUMIFS
3 min20 points
AdvancedData Analysis
Fix a SUMIFS with its arguments swapped
Repair a formula written in SUMIF's argument order instead of SUMIFS'.
SUMIFS
11 min35 points

Excel practice exercises, numbered in recommended learning order.
#	Exercise	Functions	Difficulty	Time	Status
65	Which range does SUMIFS want first?Conceptual question — no dataset	SUMIF · SUMIFS	Intermediate	3 min	20 pts
79	Fix a SUMIFS with its arguments swappedHarbor Supply — regional totals, formula under repair	SUMIFS	Advanced	11 min	35 pts

Clear all filters

Excel practice exercises

Which range does SUMIFS want first?

Fix a SUMIFS with its arguments swapped

Which range does SUMIFS want first?

Fix a SUMIFS with its arguments swapped