What a pre-employment Excel test looks like
- Usually online and timed, often 20 to 45 minutes, sent as a link after you apply or after a first interview.
- Either multiple choice or a live spreadsheet where you complete tasks yourself. The live version is harder and more common for analyst roles.
- Graded on the result and the method. A hard-typed number instead of a formula often counts as wrong.
- No AI help. Tests are taken without Copilot or ChatGPT, so you need to know the formulas yourself.
Which skills are tested, by job
| Role | Typical level | Skills that come up most |
|---|---|---|
| Administrative and office | Basic to intermediate | Formulas, SUM/AVERAGE, formatting, sorting and filtering, simple IF |
| Accounting and bookkeeping | Intermediate | Absolute references, SUMIFS, lookups, rounding, dates |
| Data and business analyst | Intermediate to advanced | XLOOKUP or INDEX/MATCH, PivotTables, nested IF, text cleaning, charts |
| Finance | Advanced | Financial functions (PMT, NPV), scenario models, lookups, error checking |
Try a typical test question
Conditional sums with two criteria are a classic intermediate task.
Total East region sales in Q1
In F2, add up the sales in column C where the region is East and the quarter is Q1.
How to prepare in five steps
- Ask the recruiter which level and format the test is. Many will tell you.
- Take a free Excel test to see your weak spots.
- Practice the skills for your role from the table above, in a real grid.
- Do at least one timed mock test, so the clock doesn't surprise you.
- On the day: read each task twice, use cell references instead of typed numbers, and skip a hard task rather than losing five minutes on it.
Know where you stand in 10 minutes
Ten realistic tasks, scored instantly, with the lessons to practice next.
Frequently asked questions
What is on a Microsoft Excel test for a job?
Most cover formulas, cell references, SUM and AVERAGE, IF logic, SUMIFS or COUNTIFS, lookups, sorting and filtering, and for analyst roles PivotTables and charts.
Can I fail an Excel test and still get the job?
Sometimes, if the rest of your application is strong, but many employers use a minimum score to filter candidates. It's worth preparing for.
Can I use Google Sheets to prepare?
Mostly, yes: the core formulas work the same. But if the test is in Excel, practice in an Excel-style grid so the layout and function names are familiar.
How hard is an intermediate Excel test?
Intermediate tests expect you to combine skills: an IF inside a lookup, or SUMIFS with two conditions, often under time pressure. A few days of focused practice usually closes the gap.