BenchmarkPrep › Guides
Excel assessment test: what's on it and how to prepare
An Excel assessment test is a short, timed test that employers use to check you can actually do the spreadsheet work in the job description. Here's what they usually cover, how they're marked, and how to get ready.
Updated 6 November 2026
What is an Excel assessment test?
Many employers test Excel skills before an interview or job offer, especially for administrative, finance, data and operations roles. The test is usually sent as an online link or done on a computer at the interview. Well-known providers include Kenexa Prove It, TestGorilla and eSkill, and some employers simply hand you a spreadsheet and a list of tasks.
There are two main formats:
- Hands-on (simulation): you work in a real or simulated spreadsheet and type formulas to produce answers. This is the most common format for job tests, and it's the hardest to bluff, because the result has to be right.
- Multiple choice: you answer questions about Excel ("Which function would you use to…?"). Quicker, but less common for roles where you'll use Excel daily.
Most assessments are timed, often somewhere between 15 and 45 minutes, and many only let you move forward, not go back.
What skills are tested?
The content depends on the level of the role. Most tests are built around the same core skills:
Basic (admin, office, data entry)
- Formulas with cell references (
=C2*D2) - SUM, AVERAGE, MIN, MAX, COUNT
- Copying a formula down a column
- Number formats: currency, percentage, dates
- Sorting and filtering a list
Intermediate (most office roles)
- IF, and nested IF for tiers
- COUNTIF, SUMIF, AVERAGEIF
- SUMIFS and COUNTIFS with several conditions
- VLOOKUP or XLOOKUP
- Absolute references (
$A$1)
Advanced (analyst, finance)
- INDEX + MATCH, approximate-match lookups
- Conditions on dates (
">="&DATE(…)) - IFERROR, text functions (LEFT, MID, TRIM)
- Summary tables with mixed references
- Pivot tables and charts (in some tests)
How is it marked?
Hands-on tests usually check three things:
- The result: is the number in the cell correct?
- The method: did you use a formula, or type the answer in? Many tests check for a formula, and some change the data behind the scenes to see whether your formula still works.
- Time: some tests score speed as well, or simply stop when the clock runs out.
That's why typing a number you worked out on a calculator usually scores zero, even when the number is right.
How to prepare
- Find out the level. Look at the job description. "Advanced Excel", "financial modelling" or "data analysis" usually means lookups and SUMIFS; "proficient in Microsoft Office" usually means the basics and IF/COUNTIF.
- Practise hands-on, under a timer. Reading about functions isn't the same as typing them quickly with the clock running. Do a timed practice test and see where you slow down.
- Learn the handful of functions that do most of the work. SUM, IF, COUNTIF/SUMIF, SUMIFS/COUNTIFS and VLOOKUP/XLOOKUP cover most tasks in most tests.
- Get comfortable with $ references. Copying a formula down a column is in almost every test, and a missing
$is the most common way a "nearly right" answer turns into a wrong one. - Always use formulas. Even when you can see the answer, put it in as a formula that refers to the cells.
A typical task
Here's the kind of task you'll see. "In column E, calculate the total for each order (Quantity × Price). Then, in G2, total the orders from the North region."
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Item | Quantity | Price | Total |
| 2 | North | Paper | 12 | $4.50 | $54.00 |
| 3 | South | Toner | 3 | $68.00 | $204.00 |
| 4 | North | Pens | 25 | $1.20 | $30.00 |
Answer: in E2, =C2*D2, copied down. In G2, =SUMIF(A2:A4,"North",E2:E4), which gives $84.00. See more worked examples in our sample Excel test questions.
Frequently asked questions
How long is an Excel assessment test?
Most are between 15 and 45 minutes. Shorter tests cover the basics; longer ones usually add lookups, conditional sums and sometimes pivot tables.
What is a good score on an Excel assessment?
It depends on the employer and the role. Many set a pass mark around 70–80%, and some compare you with other candidates. Aim to get every basic and intermediate task right, quickly.
Can I use Google to look things up during the test?
Usually not. Many tests run in a locked browser or a simulated spreadsheet, and looking up functions costs time even when it's allowed. Practise until the common functions are automatic.
Is the test done in real Excel?
Sometimes. Many providers use a simulated spreadsheet in the browser that works like Excel, so practising in a similar environment helps you get used to it.
How can I practise for free?
Our free Excel skills test has 10 hands-on tasks covering the core skills plus a bonus PivotTable task, with instant marking and a model answer for each one.