Excel Test for Hiring: Skill Levels, Sample Tasks and How to Score Them
Umid Rahimov7 min read
"Advanced Excel" may be the most over-claimed skill on CVs. For some candidates it means pivot tables and lookups across sheets. For others it means they once changed a column width. When a role depends on spreadsheets (finance, sales operations, reporting, procurement, HR analytics), a short Excel test saves you from finding out in the first month.
Why not just ask in the interview?
Because talking about Excel and using Excel are different skills. A candidate can explain VLOOKUP fluently and still need 20 minutes to build one. A test shows how accurately and how quickly someone works with real data. It also takes the guesswork out of comparing candidates who all describe themselves as "advanced".
Three practical skill levels
| Level | What the person can do | Typical roles |
|---|---|---|
| Core | Enter and format data, sort and filter, basic formulas (SUM, AVERAGE, COUNT), simple charts, absolute vs. relative references | Administrative, customer support, junior sales |
| Intermediate | IF / nested logic, XLOOKUP / VLOOKUP / INDEX-MATCH, pivot tables, conditional formatting, data validation, text and date functions | Sales operations, HR, procurement, junior analysts |
| Advanced | Dynamic arrays, complex lookups across tables, scenario and sensitivity analysis, Power Query, clean model structure, error checking | Financial analysts, FP&A, BI and reporting roles |
Test at the level the job actually needs. An advanced test for an administrative role will reject good candidates for no reason.
Sample tasks by role
Sales operations (intermediate)
Given a table of 300 deals, build a pivot table of revenue by region and month. Then flag deals over 30 days without an update.
Finance / accounting (intermediate–advanced)
Reconcile two lists of invoices with different formats. Find the five that don't match and explain why.
HR (core–intermediate)
Calculate tenure in months from hire dates. Count employees per department and highlight contracts ending in the next 60 days.
Reporting analyst (advanced)
Combine three monthly exports with inconsistent column names into one clean dataset. Then build a summary that updates automatically when a new month is added.
Question formats that work
- Multiple-choice with real screenshots or small tables: "Which formula returns…", "What will cell D5 show…". Fast to score and good for early screening.
- Practical file tasks: the candidate downloads a workbook, completes it and uploads it, or answers questions about the results. Closer to the real job, and best for the shortlist.
- Short written explanation: "How would you check this report for errors?" This shows working habits, not just formula knowledge.
A common setup is a 10–15 minute multiple-choice Excel test in the first round, then a practical task for the top candidates.
Scoring: accuracy first, speed second
- Accuracy matters most. One wrong lookup in a finance report costs more than five extra minutes.
- Speed separates equally accurate candidates, so a time limit is useful.
- Look at the method, not only the final number. A correct result built on hard-coded values is a warning sign for maintainable work.
Excel or Google Sheets?
Test the tool your team actually uses. The core concepts transfer, but shortcuts, some functions and collaboration features differ. TheyTest's library includes an Excel / Google Sheets core skills test, so candidates aren't penalised for knowing one rather than the other.
Preventing cheating on an Excel test
Formula questions are easy to search online, so:
- Draw questions randomly from a pool, so each candidate sees a different set.
- Set a time limit per question or test.
- Turn on full-screen mode and tab-switch monitoring.
- Review the session recording when a score looks too good to be true.
Build your own Excel test in minutes
If your team works with a specific template, such as a sales report, a budget model or a payroll sheet, write 5–10 custom questions based on it and add them to the library test. In TheyTest you can bulk-upload questions from an Excel template, which seems only fair for an Excel test.
FAQ
How long should an Excel test be?
10–15 minutes for a first-round multiple-choice test, and 30–45 minutes for a practical task with shortlisted candidates.
What Excel level should I test for an office administrator?
Core level: data entry, formatting, sorting and filtering, basic formulas and simple charts. Intermediate topics such as pivot tables are a bonus, not a requirement.
Can I use my own spreadsheet as a test?
Yes. Write questions about your own file and add them as a custom test, or combine them with a library test for general skills.
