Spreadsheet Practice

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

SkillFunctionsPractice
Totals by region and repSUMIFSLesson 8 Free
Commission tiersapproximate matchLesson 15 Pro
Weighted pricesSUMPRODUCTLesson 35 Pro
Share and cumulative sharerunning totalsLesson 36 Pro
Top performersSORTBY, TAKELesson 29 Pro
LookupsXLOOKUPLesson 13 Pro

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.

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 .