See what's new

Testlify
Candidate assessment
Last updated on: 18 November 202613 min read

Excel test for hiring: how to build one for your roles

How to build an Excel test for hiring: choose tasks by role, set the level, length and pass mark, and keep remote tests fair and secure.

Excel test for hiring: how to build one for your roles

An Excel test for hiring is a timed skills assessment in which candidates complete real spreadsheet tasks, such as cleaning a data set, writing a lookup or building a pivot table, so the hiring team sees their Excel ability before the interview. The useful ones copy the work of the actual role and score each task on its own.

TL;DR / Key Takeaways

  • An Excel test for hiring works best when it copies the role's real spreadsheet tasks, not a generic quiz of features nobody uses.
  • Set the level by role: basic for admin and data entry, intermediate for most analysts and ops roles, advanced for finance and FP&A.
  • Keep it to 20 to 40 minutes with 3 to 6 practical tasks. Longer tests lose good candidates without adding much signal.
  • Set the pass mark by having 3 to 5 strong current employees take the test first, then score each task separately.
  • Hands-on tasks in a spreadsheet beat multiple choice for anything above basic level, because they show how the candidate works.
  • Keep it fair: test only skills the job needs, offer extra time as an accommodation and add proctoring for remote tests.
Summarise this post with:ChatGPTGeminiClaudeGrokPerplexity

What is an Excel test for hiring?

An Excel test for hiring is a pre-employment assessment that checks whether a candidate can do the spreadsheet work a role requires. Candidates answer questions or complete tasks in a simulated or real Excel file within a time limit, and the results are scored the same way for everyone.

Most tests mix three kinds of items:

  • Knowledge questions: short multiple-choice items, for example which function returns the last matching value.
  • Practical tasks: work inside a spreadsheet, such as sorting and filtering data, writing formulas or building a chart.
  • Case tasks: a short business scenario with a data file, where the candidate has to produce an answer, a summary table or a small model.

Excel skills sit under a huge range of job titles. O*NET lists Microsoft Excel as an in-demand hot technology for general office clerks, and the same tool shows up in finance, operations, sales, HR and analyst job descriptions. That is exactly why one generic Excel test rarely fits every role.

Build your dream team — Book a product demo

Why do generic Excel tests give weak hiring signals?

Generic Excel tests give weak signals because they measure broad feature knowledge, while the job needs a specific set of tasks done fast and accurately. A financial analyst and a sales coordinator both live in spreadsheets, but they use very different parts of Excel, so the same test over-screens one and under-screens the other.

The common problems look like this:

  • Obscure features: questions on rarely used menus or functions reward trivia, not job skill.
  • No real tasks: multiple choice alone shows what a candidate recognizes, not what they can build.
  • One level for all: the same test for a data entry role and an FP&A role is too hard for one and too easy for the other.
  • Old Excel: tests that stop at VLOOKUP miss XLOOKUP, dynamic arrays and Power Query, which many teams now use daily.

The cost of a weak screen is high when roles are already hard to fill. SHRM's 2025 Talent Trends found that 69% of organizations still struggle to fill full-time roles, and 47% are updating existing roles to include new skills. A test that matches the role helps you move strong candidates forward instead of losing them to a mismatched filter.

Which Excel skills should you test at each level?

Excel skills for hiring fall into three levels: basic (data entry, formatting, simple formulas), intermediate (lookups, pivot tables, conditional logic, data cleaning) and advanced (modeling, Power Query, dynamic arrays, automation). Match the level to the daily work of the role, not to the most impressive skill on the list.

Excel test for hiring skill levels: basic, intermediate and advanced skills with example roles

A useful outside reference for the middle band is Microsoft's own certification. The Microsoft Office Specialist Excel Associate exam covers five areas: worksheets and workbooks, cells and ranges, tables, formulas and functions, and charts. Microsoft pitches it at people with about 150 hours of hands-on use, which is a fair picture of "intermediate" for most hiring teams.

Pro tip: Accept either XLOOKUP or VLOOKUP and INDEX MATCH when a task asks for a lookup. Scoring the result, not the function, stops you rejecting people who learned on a different Excel version.

How do you build an Excel test for hiring in 6 steps?

Building an Excel test for hiring takes six steps: list the role's real Excel tasks, set the level, turn tasks into test items, choose formats and time, set the pass mark with your own team, then review results and update the test. The work takes a few hours once and pays back on every candidate after that.

Six steps to build an Excel test for hiring, from role tasks to pass mark
  1. List the real tasks: Ask the hiring manager what the new hire will do in Excel in their first 90 days. "Rebuild the weekly sales report from the CRM export" is far more useful than "good Excel skills".
  2. Set the level: Map those tasks to basic, intermediate or advanced using the table above. Most roles need one level plus a few basics.
  3. Turn tasks into items: Rewrite each task as a small, scoreable exercise with a clear expected output. Use a realistic but anonymized data file, never live company data.
  4. Choose formats and time: Use practical tasks for core skills and a few knowledge questions for coverage. Aim for 20 to 40 minutes in total.
  5. Set the pass mark: Have 3 to 5 people who already do the job well take the test. Their scores show what "good" looks like for your team.
  6. Review and update: After a hiring round, check which tasks separated strong and weak hires, drop the ones that did not, and update the file when tools or processes change.

If you also tailor aptitude or reasoning tests to an industry, the same task-first logic applies. Our guide to tailored talent assessments covers that side of the process.

What Excel tasks fit each role?

The best Excel tasks for each role are the ones the person will repeat every week. Pick 3 to 6 tasks per role from its real workload, keep the data set small enough to finish in time, and score the output, not the route the candidate took to get there.

Role

Level

Example tasks to include

Suggested time

Data entry or admin

Basic

Enter and format 30 records, fix inconsistent dates, sort and filter, total a column, set up a print area

15 to 20 min

Accounts payable or procurement

Intermediate

Match invoices to purchase orders with a lookup, flag duplicates, summarize spend by supplier with a pivot table

25 to 30 min

Sales ops

Intermediate

Clean a CRM export, calculate win rate by rep with COUNTIFS, build a monthly pipeline chart

25 to 30 min

HR ops

Intermediate

Combine two employee lists, calculate tenure, build a headcount pivot by department, apply data validation

25 to 30 min

Operations or supply chain analyst

Intermediate to advanced

Reconcile stock counts, forecast next month's demand from 12 months of data, highlight exceptions

30 to 35 min

Financial analyst or FP&A

Advanced

Build a simple three-statement link, run a best and worst case scenario, explain the result in two lines

35 to 45 min

For finance roles, a ready-made financial Excel modeling test gives you a tested starting point, and a data analyst Excel test does the same for reporting and analysis roles. Add one task built from your own data to make either one specific to your team.

Which question formats work best?

The best format depends on the skill: multiple choice suits quick checks of concepts, browser simulations suit standard Excel actions, file upload tasks suit real analysis and modeling, and short case questions show reasoning. Most good Excel tests for hiring combine two or three of these formats.

Excel test for hiring question formats compared: multiple choice, simulation, file upload task and case question
  • Multiple choice: fast to take and to score. Good for checking that a candidate knows what a function does. Weak on its own, because recognizing an answer is easier than building it.
  • Simulation: the candidate performs actions in a spreadsheet inside the browser, such as applying a filter or inserting a pivot table, and each action is scored automatically. Ideal for basic and intermediate levels.
  • File upload task: the candidate downloads a workbook, completes the task in Excel and uploads the finished file. This is the closest to real work and the best choice for modeling and analysis roles.
  • Case question: a short written answer about what the numbers mean. This shows whether the candidate can explain a result to a manager, not only calculate it.
Post image
Post image

How long should the test be and what score should pass?

An Excel test for hiring should usually take 20 to 40 minutes, with 3 to 6 practical tasks and a few knowledge questions. Set the pass mark from the scores of your own strong performers rather than a fixed number, and look at task-level results before rejecting anyone near the line.

Thirty minutes is the most common length among published employer tests, and even Microsoft's associate-level Excel exam runs 50 minutes for full certification coverage. For hiring, shorter is better: you only need enough tasks to see the skills the role uses.

For the pass mark:

  • Benchmark first: if your 3 to 5 benchmark employees average 80%, a pass mark around 65% to 70% is a sensible starting point.
  • Score by task: a candidate who aces the lookup and pivot tasks but misses chart formatting may be the right hire for a reporting role.
  • Use must-pass tasks: mark one or two tasks as essential, such as a correct reconciliation for an accounts role.
  • Review the band: look at the work of candidates within 5 points of the pass mark before deciding.

How do you keep an Excel test fair and cheat-resistant?

An Excel test stays fair when every task links to a real job requirement, every candidate gets the same conditions, and people who need accommodations get them. It stays cheat-resistant when tasks use fresh data, run under a time limit and sit behind proctoring checks for remote candidates.

On fairness, the EEOC's guidance on employment tests says a test that screens out a protected group must be job-related and consistent with business necessity. The same guidance tells employers to make reasonable accommodations, such as extra time, for applicants with disabilities, and to update tests as the job changes. A task list built from the role's real work, as in step 1 above, is your best evidence.

Practical fairness checks:

  • Platform: tell candidates whether the test runs in the browser or needs Excel installed, and whether Mac shortcuts work.
  • Version: accept equivalent functions (XLOOKUP or VLOOKUP) unless the role truly needs one.
  • Instructions: give a short practice item so nervous candidates do not lose time on the interface.
  • Feedback: share a short summary of strengths and gaps with every finalist, which keeps your employer brand intact.

On integrity, remote Excel tests invite copy and paste answers and outside help. Use randomized question order, a time limit per task, copy and paste controls, webcam snapshots and tab tracking. Testlify includes 20+ anti-cheating and proctoring checks for exactly this, with AI assistance detection on top.

What mistakes should you avoid when designing an Excel test?

The biggest mistakes are making the test harder than the job, relying only on multiple choice, using live company data, skipping the benchmark and never updating the test. Each one either turns away capable candidates or lets weak ones through.

  • Too hard for the role: macros in a test for a receptionist only produce false rejections.
  • Multiple choice only: candidates who can name a function may still be unable to use it on a messy data set.
  • Live company data: use anonymized or synthetic files, both for privacy and to keep the test stable.
  • No benchmark: a pass mark picked from thin air is either too strict or too loose.
  • A test that never changes: if your team moved from VLOOKUP to XLOOKUP or to Power Query, the test should too.
Key takeaway: A good Excel test for hiring is short, built from the role's own tasks, scored task by task and checked against your best people. Difficulty for its own sake adds nothing.

How does Testlify help you tailor an Excel test?

Testlify lets hiring teams start from a ready Excel test, add their own tasks and files, and run the whole assessment with scoring, proctoring and ATS sync in one place. Teams can launch a test for a single analyst role or for hundreds of candidates in a volume hiring drive.

Post image
  • Ready Excel tests: the test library holds 3,500+ tests, including Microsoft Excel simulation tests at basic, intermediate and advanced level, plus Excel tests for data analysts, business analysts, auditors and financial modeling.
  • Your own tasks: with Microsoft Excel upload questions, you write the scenario and candidates reply with a real Excel file, which suits modeling and analysis roles. Testlify supports 25+ question types, so you can add case questions, video answers or typing tasks to the same test.
  • AI test builder: paste a job description and Testlify suggests a role-specific assessment and scoring criteria, which you then edit.
  • Control over scoring: set the time limit, weight each section, auto-score simulations and keep a manual review step for complex file tasks.
  • Integrity and reach: 20+ proctoring checks are included, and assessments run in 15+ languages.
  • Fits your stack: results sync to 100+ ATS and HRIS tools through Testlify integrations.

For harder roles, our guide to advanced Excel assessments goes deeper into modeling and automation tasks.

Ready to build your Excel test?

Pick the Excel test closest to your role in the Testlify test library, add one task from your own workflow and invite your first candidates today. Start a 7-day free trial, no credit card required.

Frequently asked questions

Get started.

Hire on proof, not resumes.

Run your first skills-based assessment free — no credit card required.

We use cookies to enhance your browsing experience, serve personalised ads or content, and analyse our traffic. By clicking "Accept All", you consent to our use of cookies.