BenchmarkPrep › Guides

Excel test for a job interview: what to expect

If a job application asks you to take an Excel test, it's a good sign: you're through the first round. Here's what to expect for your type of role, and how to make sure your real skills come across under time pressure.

Updated 6 November 2026

Why employers give Excel tests

Almost everyone writes "proficient in Excel" on their CV, so many employers check it. A short test shows them whether you can do the day-to-day spreadsheet work without help, and it's usually given before or during the interview stage.

What happens on the day

• Online test link: the most common. You get an email with a link and a deadline, and take the test at home in a browser.
• At the interview: you're given a laptop with a spreadsheet and a list of tasks, sometimes with the interviewer watching.
• Take-home task: less common. A workbook to complete and send back within a day or two, usually for analyst roles.

Online tests are usually timed and often one-way (you can't go back to a task), so it's worth practising at a steady pace rather than perfecting one answer.

What you'll be asked, by role

Administrative, office and customer service

Calculations on a list (totals, stock values, hours × rate), SUM/AVERAGE, IF to flag rows (for example "Reorder" when stock is low), COUNTIF and SUMIF, formatting as currency, sorting, and a simple VLOOKUP. Our Admin & Office tests are built around these.

Analyst, finance and accounting

Everything above, plus nested IFs for tiers, SUMIFS and COUNTIFS with dates, summary tables using mixed references ($A2, B$1), XLOOKUP or INDEX + MATCH, approximate-match lookups for rate tables, IFERROR, cleaning messy data (TRIM, PROPER, LEFT/MID), and sometimes pivot tables.

The mistakes that cost the most marks

1. Typing answers instead of formulas. Many tests check for a formula, so a correct number typed in by hand often scores zero.
2. Forgetting $ when copying. A formula that's right in the first row and wrong in every row below is the most common near miss.
3. Running out of time on one hard task. If you're stuck for more than a couple of minutes, move on and come back if the test allows.
4. Not reading the exact cell. Tests mark specific cells. Put the answer exactly where the task asks.
5. Hard-coding values from the sheet. Use =SUMIF(A:A,G1,C:C) with G1 holding the region, not "North" typed into the formula, when the task says the value is in a cell.

A one-week plan

• Day 1: take a timed practice test to find your weak spots.
• Days 2–4: drill those functions until you can type them without thinking. Focus on IF, COUNTIF/SUMIF, SUMIFS and lookups.
• Days 5–6: take full timed tests at the level of your role.
• Day 7: rest, and do one short warm-up test before the real one.

Frequently asked questions

Do all jobs that mention Excel give a test?

No, but many do for admin, finance, data and operations roles, and especially when the job ad says 'advanced Excel'. If it's mentioned in the job ad or the interview invitation, expect one.

What if I fail the Excel test?

Some employers let you retake it after a waiting period; others move on to other candidates. It's worth practising before the real thing, since you often only get one attempt.

Can I take the test on my phone?

Usually not, or not comfortably. Use a laptop or desktop computer with a mouse if you can, because you'll be clicking cells and typing formulas.

Are VLOOKUP and XLOOKUP both accepted?

In hands-on tests, usually yes: what's checked is that the result is correct and comes from a formula. Know at least one lookup well; VLOOKUP is the most widely understood.

How do I practise for my specific level?

Start with our free core-skills test. If you do well, the Analyst & Finance tests match more demanding roles; if you struggle, the Admin & Office tests build the basics.