Sales analyst Excel test: skills, sample task and prep plan
Sales and revenue operations screens ask for commission tiers, quota attainment, top reps and a clean summary by region. Expect lookups with tiers, conditional totals and ranking.
What employers usually test
Take the sales analyst timed test
Five tasks in a live grid, easiest first. Graded instantly, with a lesson for every gap.
- 5 tasks in a live grid, easiest first. Graded the moment you submit
- About 10 minutes. Skip anything you don't know
- Your level and the exact lessons for your gaps, right away. No signup
- Aced it? Keep going with a bonus round of harder, interview-style tasks
Try a sample task
From lesson 15, Tiered lookups & IFERROR. Graded instantly.
Commission tiers
In
C2, look up each rep's commission rate from the tier table in E2:F5. Sales at or above a threshold earn that tier. Fill down to C7.Your 14-day prep plan
About 30 minutes a day. Free lessons first; Pro lessons are marked.
| Day | Focus | Access | Time |
|---|---|---|---|
| 1 | Relative vs absolute references | Free | 24 min |
| 2 | Percentages & growth | Free | 22 min |
| 3 | COUNTIF & SUMIF | Free | 23 min |
| 4 | COUNTIFS, SUMIFS & AVERAGEIFS | Free | 25 min |
| 5 | XLOOKUP | Pro | 24 min |
| 6 | Tiered lookups & IFERROR | Pro | 24 min |
| 7 | UNIQUE & SORT | Pro | 24 min |
| 8 | SORTBY, TAKE & SEQUENCE | Pro | 24 min |
| 9 | RANK, LARGE & SMALL | Pro | 24 min |
| 10 | SUMPRODUCT | Pro | 24 min |
| 11 | Running totals & share of total | Pro | 24 min |
| 12 | Capstone: sales report | Pro | 30 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 sales analyst test usually include?
A table of deals or orders, then questions on totals by region, commission with tiers, and who the top performers are.
Do I need to know XLOOKUP?
It helps. If the test uses an older Excel, INDEX/MATCH and VLOOKUP are covered in the lookups track.
How long should I prepare?
Two weeks at about 30 minutes a day.
Prep for other roles
Updated Checked by running: every exercise answer on this page was graded by our formula engine on .