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 — Intermediate · Logical Functions · for Business Analyst

Sort:Recommended Difficulty Newest

IntermediateLogical Functions
Band orders by size with nested IF
Return one of three labels depending on where a value falls.
IF
9 min25 points
IntermediateLogical Functions
Work out fill rate without a divide error
Guard a division so cancelled lines do not fill the report with errors.
IF
8 min25 points

Excel practice exercises, numbered in recommended learning order.
#	Exercise	Functions	Difficulty	Time	Status
45	Band orders by size with nested IFHarbor Supply — October orders	IF	Intermediate	9 min	25 pts
49	Work out fill rate without a divide errorHarbor Supply — fill rate by line, some cancelled	IF	Intermediate	8 min	25 pts

Clear all filters

Excel practice exercises

Band orders by size with nested IF

Work out fill rate without a divide error

Band orders by size with nested IF

Work out fill rate without a divide error