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.
12 exercises — Beginner · for Student
Multiply quantity by unit price to get a line total.
Use LEN to validate that product codes are the right length.
LEN
Pull the first name out of a single full-name column.
LEFT · FIND
Add up a column of daily sales figures to get the monthly total.
SUM
Combine separate address fields into one line, skipping blanks.
TEXTJOIN
Divide actual sales by target to get an achievement percentage.
Use COUNT to find how many rows contain a numeric value.
COUNT
Calculate the mean value of a set of customer orders.
AVERAGE
Count how many rows meet a numeric condition.
COUNTIF
Identify the extremes in a column of values.
MAX · MIN
Use IF to label each rep as meeting or missing their target.
IF
Add up only the rows matching a text condition.
SUMIF
| # | Exercise | Functions | Difficulty | Time | Status |
|---|---|---|---|---|---|
| 1 | Calculate line totals with multiplicationHarbor Supply — order ORD-1046 lines | — | Beginner | 3 min | 10 pts |
| 2 | Check code length with LENHarbor Supply — product code import | LEN | Beginner | 3 min | 10 pts |
| 3 | Split a full name with LEFT and FINDHarbor Supply — CRM contact export | LEFT · FIND | Beginner | 7 min | 15 pts |
| 4 | Total a month of sales with SUMHarbor Supply — daily sales, first week of October | SUM | Beginner | 3 min | 10 pts |
| 5 | Build a mailing address with TEXTJOINHarbor Supply — customer addresses | TEXTJOIN | Beginner | 6 min | 15 pts |
| 6 | Calculate achievement against targetHarbor Supply — Q3 rep performance | — | Beginner | 3 min | 10 pts |
| 7 | Count how many orders shipped with COUNTHarbor Supply — shipment status | COUNT | Beginner | 4 min | 10 pts |
| 8 | Find the average order value with AVERAGEHarbor Supply — October orders | AVERAGE | Beginner | 3 min | 10 pts |
| 9 | Count orders above a threshold with COUNTIFHarbor Supply — October orders | COUNTIF | Beginner | 5 min | 15 pts |
| 10 | Find the largest and smallest orderHarbor Supply — October orders | MAX · MIN | Beginner | 4 min | 10 pts |
| 11 | Flag reps below target with IFHarbor Supply — Q3 rep performance with achievement | IF | Beginner | 5 min | 15 pts |
| 12 | Total sales for one region with SUMIFHarbor Supply — October orders by region | SUMIF | Beginner | 6 min | 15 pts |