Excel Test for a Job Interview: What's Tested and How to Prepare
What pre-employment Excel tests cover at basic, intermediate and advanced levels, sample tasks, a 2-week prep plan and tips for test day.
By Ayoub Farid · · 3 min read
Many employers check Excel skills with a test before or during the interview: an online assessment, a file to complete in 30 minutes, or a task on a shared screen. The good news is that tests are predictable. Most check the same core skills.
What tests usually cover
Testing platforms and hiring guides list similar skills. Exact content depends on the role and level.
Basic level (admin, data entry, customer service)
- Entering and formatting data
- SUM, AVERAGE, MIN, MAX, COUNT
- Simple formulas with + − × ÷ and percentages
- Sorting and filtering
- Basic charts
Intermediate level (most office and analyst roles)
- Absolute references with $ and filling formulas down
- IF, AND, OR
- COUNTIF, SUMIF, SUMIFS
- VLOOKUP or XLOOKUP, sometimes INDEX/MATCH
- Text functions: TRIM, LEFT/RIGHT, joining text
- Pivot tables
- Conditional formatting
Advanced level (analyst, finance)
- INDEX/MATCH, nested and combined formulas
- Dynamic arrays (FILTER, UNIQUE)
- Data cleaning at scale
- Pivot tables with calculated fields, charts
- Sometimes macros or Power Query
Typical tasks
- "Calculate total and average sales per region."
- "Show each product's share of total sales." (needs
$) - "Flag orders over $500 as 'Review'." (IF)
- "How many orders came from the North region in March?" (COUNTIFS)
- "Bring each employee's department in from the second sheet." (VLOOKUP)
- "Clean this list of names." (TRIM, PROPER)
- "Build a pivot table of sales by month and product."
Try our basic Excel test questions for practice versions with answers.
The mistakes that fail people
- Missing $ when filling down: the most common one. Totals and lookup ranges must be locked. See absolute references.
- Typing numbers instead of references: right answer, wrong method.
- VLOOKUP without FALSE.
- Range one row short in SUM.
- Running out of time on one hard question.
A 2-week prep plan
| Days | Focus |
|---|---|
| 1–2 | References, SUM, AVERAGE, MIN, MAX, COUNT |
| 3–4 | Percentages, fill down, $ locks |
| 5–6 | IF, AND, OR |
| 7–8 | COUNTIF, SUMIF, SUMIFS |
| 9–10 | VLOOKUP, XLOOKUP, IFERROR |
| 11 | TRIM, text joining, sorting and filtering |
| 12 | Pivot tables |
| 13 | Timed practice test |
| 14 | Review your mistakes |
Twenty to thirty minutes a day is enough if you write formulas yourself instead of watching.
On test day
- Ask beforehand which Excel version and format the test uses.
- Read every question twice: "share of total" vs "percent change" are different.
- Do the easy questions first.
- After filling down, click the last cell and check the formula.
- Change one input to check your formula updates.
How Cellio helps
Cellio was built with job tests in mind: when you pick "Pass an Excel job test" as your goal, your plan marks the units that matter most. The live units drill the basics and the $-lock mistakes that fail most candidates, with feedback that names the error. IF, conditional sums and lookups are coming next, and timed mock job tests are planned.
Frequently asked questions
What is on a typical Excel test for a job?
Core formulas (SUM, AVERAGE, COUNT), $ references, IF, COUNTIF/SUMIF, VLOOKUP or XLOOKUP, sorting/filtering, and often pivot tables.
How long are pre-employment Excel tests?
Commonly 20 to 60 minutes, depending on the employer and level.
How can I prepare for an Excel test quickly?
Practise the core formulas daily for one to two weeks, focusing on $ references, IF, SUMIFS and lookups.
Can I use Google Sheets for an Excel test?
Usually not during the test itself, but practising formulas in Google Sheets transfers well.