Home › Excel tests › Excel assessment test
Excel assessment test: what to expect and how to prepare
Many employers ask candidates to take an Excel assessment test before or after the first interview. It's usually a short online test with real tasks, and it decides more than you'd think: a low score often ends the process. Here's what these tests look like, what they check at each level and how to prepare, with a practice assessment you can take right now.
In this guide
What is an Excel assessment test?
An Excel assessment test checks whether you can actually do what your CV says. Instead of asking "how good is your Excel?", the employer gives you tasks: total a column, look up a value, build a pivot table. You usually get a link by email and take the test at home, within a few days.
The tests come in two forms, and many combine them:
- Simulation tasks: you work in an Excel-like window and type real formulas. This is the most common form for office, admin and analyst roles.
- Multiple choice: questions about functions, errors and menus, such as "which function counts non-empty cells?".
Most tests take 15 to 45 minutes and have a time limit. You see 10 to 30 tasks that get harder as you go.
What employers test at each level
| Level | Typical tasks | Jobs |
|---|---|---|
| Basic | SUM, AVERAGE, MIN/MAX, simple IF, percentages, sorting and filtering, formatting | Admin, customer service, retail, office support |
| Intermediate | VLOOKUP or XLOOKUP, COUNTIFS, SUMIFS, IFERROR, text functions, dates, pivot tables | Office managers, sales and HR roles, planners |
| Advanced | INDEX MATCH, nested IF, SUMPRODUCT, FILTER and UNIQUE, data cleaning, charts and reports | Data and financial analysts, controllers, consultants |
The job ad is your best clue. "Good Excel skills" usually means intermediate; "advanced Excel" or "financial modelling" means you'll see the advanced level.
Try a short practice assessment
Six tasks in the style of an employer assessment: formulas in an Excel window plus two quick questions. No tips, a score at the end.
- Add up the invoices that are "Open", in E2
- Find the manager of the Leeds office, in F2
- Show "Reorder" in C2 if the stock is below 20, otherwise "OK"
- Work out the growth from last month to this month as a percentage, in D2
- A column has names with extra spaces, like " Jan Smit ". Which function cleans them up?
- In a pivot table, where do you put the field you want to total?
Who makes Excel assessment tests?
Employers rarely write their own test. They use a testing platform and pick an Excel test from its library. Platforms you may come across include TestGorilla, Criteria, SHL, IBM Kenexa and Alooba. The look differs, but the content is very similar: the same functions, at the same three levels.
What about the Indeed Excel assessment? Indeed used to offer its own skills tests, including Excel, that showed on your Indeed profile. Indeed stopped those assessments in 2024. If you get an Excel test through a job on Indeed today, it comes from the employer or their testing platform, and it covers the same skills as above.
How to prepare for an Excel assessment
- Find your level. Take the Excel level test to see where you stand and where the gaps are.
- Practise the core functions. Lookups and conditional sums come up in almost every test: VLOOKUP, XLOOKUP, SUMIFS, COUNTIFS and IF.
- Learn one pivot table by heart. Many tests ask for one. Practise it with our pivot table guide.
- Do a full test under time pressure. Take the basic, intermediate or advanced Excel test in one go.
- Review what you missed. Look up the functions you got wrong and redo those tasks a day later.
Tips for the day of the test
- Use a laptop or desktop with a mouse, not your phone.
- Close other tabs and silence notifications: most tests can't be paused.
- Watch the clock. If a task takes more than two minutes, move on and come back.
- Check where the answer has to go. A correct formula in the wrong cell often scores zero.
- Use cell references, not typed numbers, so your formula still works when the data changes.
Frequently asked questions
What is an Excel assessment test?
It's a short test, usually online, in which an employer checks your Excel skills with real tasks: formulas, lookups, pivot tables and a few multiple-choice questions. It often decides whether you go on to the next round.
How do I pass an Excel assessment?
Know the core functions (SUM, IF, COUNTIFS, SUMIFS, VLOOKUP or XLOOKUP), practise one pivot table and take at least one practice test under time pressure. Most failed tests come from running out of time, not from not knowing a function.
What score do I need to pass?
Every employer sets its own bar. Many use around 70% for office roles; for analyst roles the bar is often higher.
Is the Indeed Excel assessment still used?
No. Indeed stopped its skills assessments in 2024. Employers who want to test Excel now use their own test or a testing platform.
Can I use Google or Excel help during the test?
Usually not. Most tests run in a locked window and some track when you leave the page. Prepare so you don't need to look things up.