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 — Logical Functions · for Product Manager

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
Turn a product code into a category
Read a code's prefix and translate it into a readable category name.
IFS · LEFT
9 min30 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
64	Turn a product code into a categoryHarbor Supply — SKU category decode	IFS · LEFT	Intermediate	9 min	30 pts

Clear all filters

Excel practice exercises

Band orders by size with nested IF

Turn a product code into a category

Band orders by size with nested IF

Turn a product code into a category