Operations analyst Excel test: skills, sample task and prep plan
Operations roles test practical logic: flag orders that meet rules, count by status, look up rates, round up quantities, and count working days between dates.
What employers usually test
Try a sample task
From lesson 22, ROUND, ROUNDUP & ROUNDDOWN. Graded instantly.
Boxes needed
In
D2, calculate how many boxes each order needs. A partial box still counts as a box. Fill down to D6.Your 14-day prep plan
About 30 minutes a day. Free lessons first; Pro lessons are marked.
| Day | Focus | Access | Time |
|---|---|---|---|
| 1 | SUM, AVERAGE, MIN, MAX & COUNT | Free | 22 min |
| 2 | Relative vs absolute references | Free | 24 min |
| 3 | The IF function | Free | 22 min |
| 4 | AND, OR & IFS | Free | 24 min |
| 5 | COUNTIF & SUMIF | Free | 23 min |
| 6 | COUNTIFS, SUMIFS & AVERAGEIFS | Free | 25 min |
| 7 | XLOOKUP | Pro | 24 min |
| 8 | Tiered lookups & IFERROR | Pro | 24 min |
| 9 | DATE, YEAR, MONTH & TEXT | Pro | 23 min |
| 10 | EDATE, EOMONTH & NETWORKDAYS | Pro | 24 min |
| 11 | ROUND, ROUNDUP & ROUNDDOWN | Pro | 22 min |
| 12 | RANK, LARGE & SMALL | Pro | 24 min |
| 13 | Timed run: the analyst interview capstone | Pro | 20 min |
| 14 | Retake the skills test and compare | Free | 10 min |
Questions
What does a typical task look like?
A table of orders or shipments, with questions like "how many late orders per region" or "flag orders over a threshold that ship to a priority customer."
Which functions matter most?
IF with AND/OR, COUNTIFS and lookups cover most operations tasks.
How long should I prepare?
Two weeks at about 30 minutes a day.