Microsoft Excel test for job candidates real spreadsheet work, not multiple-choice formula trivia

Hands-on tasks in a live spreadsheet: build a formula, pivot a dataset, write a VLOOKUP, format a chart. Three levels - basic, intermediate, advanced - per role.

Sales Executive

Skill test · 12 skills

Hundreds of roles
NegotiationRoleplay8.2
Objection handlingScenario7.5
Active listeningAudio9.0
Product knowledgeMCQ8.8
CRM hygieneSimulation7.2
+7 more skills in this testAI graded

Trusted by HR teams at 200+ companies

Springworks logo
Bajaj Capital logo
Somany Ceramics logo
Zoko logo
PocketPills logo
Xcelore logo
Astuto logo
The Sleep Company logo
Hudle logo
Future Generali logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Springworks logo
Bajaj Capital logo
Somany Ceramics logo
Zoko logo
PocketPills logo
Xcelore logo
Astuto logo
The Sleep Company logo
Hudle logo
Future Generali logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo
Goodfit customer logo

Why this matters

Excel competence does not show up on a resume

Every operations, finance, and analyst candidate claims Excel proficiency. Multiple-choice questions about VLOOKUP test memorization, not skill. A live spreadsheet test - "open this file, build this formula, build this pivot" - is the only way to see what a candidate can actually do.

Hands-on tasks

Real spreadsheet, real tasks

Candidates open a live spreadsheet in the browser and complete tasks: write formulas, build pivot tables, run VLOOKUPs, format charts. Their work is graded against the expected output.

  • Live in-browser spreadsheet (no install)
  • Tasks scored against expected output
  • Partial credit for partially correct work
  • Time-limited per task to keep the cohort comparable

Three levels

Basic, intermediate, advanced

Pick the level for the role. Basic covers formulas, formatting, sorting. Intermediate adds VLOOKUP, INDEX-MATCH, and pivots. Advanced adds nested formulas, array functions, and macros.

  • Basic: SUM, AVERAGE, IF, formatting, sort and filter
  • Intermediate: VLOOKUP, INDEX-MATCH, pivot tables, basic charts
  • Advanced: nested IFs, SUMIFS / COUNTIFS, array formulas, macros
  • Custom level - mix items from any level

Use cases

Ops, finance, analyst, and admin roles

Set Basic for admin and coordinator roles, Intermediate for ops and finance, Advanced for analyst roles. Use the score plus completion time as a single ranking signal.

  • Operations and supply-chain coordinators
  • Finance and accounting analysts
  • Sales-ops and revops roles
  • Admin and executive assistant hiring

3

difficulty levels

Live

in-browser spreadsheet

Hands-on

tasks, not MCQs

Auto-graded

against expected output

See Goodfit in action

Start hiring smarter today

Get a walkthrough with our team, or sign up and try it yourself. 20 free assessments either way.

Book a demo