# 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.

Source: https://spreadsheetpractice.com/excel-test/sales-analyst · Updated October 29, 2026

## What employers usually test

| Skill | Functions | Practice |
|---|---|---|
| Totals by region and rep | SUMIFS | [Lesson 8: COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs) (free) |
| Commission tiers | approximate match | [Lesson 15: Tiered lookups & IFERROR](https://spreadsheetpractice.com/learn/tiered-lookups-iferror) (Pro) |
| Weighted prices | SUMPRODUCT | [Lesson 35: SUMPRODUCT](https://spreadsheetpractice.com/learn/sumproduct) (Pro) |
| Share and cumulative share | running totals | [Lesson 36: Running totals & share of total](https://spreadsheetpractice.com/learn/running-totals-share-of-total) (Pro) |
| Top performers | SORTBY, TAKE | [Lesson 29: SORTBY, TAKE & SEQUENCE](https://spreadsheetpractice.com/learn/sortby-take-sequence) (Pro) |
| Lookups | XLOOKUP | [Lesson 13: XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) (Pro) |

## A sample task

**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.

From [Tiered lookups & IFERROR](https://spreadsheetpractice.com/learn/tiered-lookups-iferror). Solve it, graded instantly, at [the sales analyst test page](https://spreadsheetpractice.com/excel-test/sales-analyst).

## A 14-day prep plan

About 30 minutes a day.

| Day | Focus | Access |
|---|---|---|
| 1 | [Relative vs absolute references](https://spreadsheetpractice.com/learn/relative-absolute-references) | Free |
| 2 | [Percentages & growth](https://spreadsheetpractice.com/learn/percentages-and-growth) | Free |
| 3 | [COUNTIF & SUMIF](https://spreadsheetpractice.com/learn/countif-sumif) | Free |
| 4 | [COUNTIFS, SUMIFS & AVERAGEIFS](https://spreadsheetpractice.com/learn/countifs-sumifs-averageifs) | Free |
| 5 | [XLOOKUP](https://spreadsheetpractice.com/learn/xlookup) | Pro |
| 6 | [Tiered lookups & IFERROR](https://spreadsheetpractice.com/learn/tiered-lookups-iferror) | Pro |
| 7 | [UNIQUE & SORT](https://spreadsheetpractice.com/learn/unique-sort) | Pro |
| 8 | [SORTBY, TAKE & SEQUENCE](https://spreadsheetpractice.com/learn/sortby-take-sequence) | Pro |
| 9 | [RANK, LARGE & SMALL](https://spreadsheetpractice.com/learn/rank-large-small) | Pro |
| 10 | [SUMPRODUCT](https://spreadsheetpractice.com/learn/sumproduct) | Pro |
| 11 | [Running totals & share of total](https://spreadsheetpractice.com/learn/running-totals-share-of-total) | Pro |
| 12 | [Capstone: sales report](https://spreadsheetpractice.com/learn/capstone-sales-report) | Pro |
| 13 | [Timed run: the analyst interview capstone](https://spreadsheetpractice.com/learn/capstone-analyst-interview) | Pro |
| 14 | [Retake the skills test and compare](https://spreadsheetpractice.com/excel-skills-test) | Free |

## 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

- [Financial analyst](https://spreadsheetpractice.com/excel-test/financial-analyst)
- [Accountant](https://spreadsheetpractice.com/excel-test/accountant)
- [Administrative assistant](https://spreadsheetpractice.com/excel-test/administrative-assistant)
- [Data analyst](https://spreadsheetpractice.com/excel-test/data-analyst)
- [Operations analyst](https://spreadsheetpractice.com/excel-test/operations-analyst)
- [Marketing analyst](https://spreadsheetpractice.com/excel-test/marketing-analyst)
- [HR analyst](https://spreadsheetpractice.com/excel-test/hr-analyst)
- [Project manager](https://spreadsheetpractice.com/excel-test/project-manager)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
