Excel test for a job interview
To pass an Excel test in a job interview, practice the same timed tasks the test uses — conditional totals, lookups, IF, and shortcuts — in a real spreadsheet until you can do them without looking anything up. DailyDrills at excel.dailydrills.app is that practice: short drills in a live grid, instant feedback, and you can start for free.
The test is almost never a quiz about every function. It is a small workbook and a clock. You are being checked on whether you can read a table, pick the right formula, type it, and check the result. That is a skill you build by doing it, not by watching someone else do it.
What the test usually looks like
Most employers give you one workbook with a sales, orders, or staff table, plus a short list of jobs: a total for one group, a value pulled from a second sheet, a yes/no flag, sometimes a pivot table. You have 10 to 30 minutes. The last instruction often changes the formula, so read the whole task before you type.
They are not testing whether you memorised a Microsoft certificate. They are testing whether you freeze. People who freeze have usually only watched tutorials. People who finish have typed the same kind of formula many times, under a timer, and checked the number by hand.
A worked example: total for one person in one region
A common first question is: from a small sales table, total Ana's sales in the North. That is SUMIFS. The range to add comes first, then each condition as a range and a value. North + Ana is 180 + 210 = 390. The South row and the other North reps are left out because both conditions must be true.
Example: Ana's North sales
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Rep | Region | Sales | North, Ana |
| 2 | Ana | North | 180 | 390 |
| 3 | Ben | South | 90 | |
| 4 | Ana | North | 210 | |
| 5 | Cam | East | 140 | |
| 6 | Ben | North | 55 |
Rows 2 and 4 match both conditions. Type this yourself in the first lessons, then time how long it takes you to write it from the wording alone.
How to practice in the days before
Do not try to learn every Excel function. Pick the four families in the table below and stay on each one until you can write it from a sentence, without opening a cheat sheet. Then set a 15-minute timer and do a mixed set: one total, one lookup, one IF, one fill-down. That mix is closer to the interview than a single long lesson.
On DailyDrills you type into a real grid in the browser. Nothing to install. You can start for free: the first lessons, including IF, need no account. Pro lessons such as SUMIFS and VLOOKUP show a preview so you can see the task before you decide. After each drill, the site tells you whether the formula is right, so you do not practice a mistake until the interview.
Two days before the test, stop adding new functions. Redo the tasks you missed, out loud: say which function you used and how you checked the number. Interviewers often ask that, and a clear sentence counts as much as the cell.
On the day
Save after every answer. Write results in new cells; do not type over the source data. If one question eats the clock, skip it, finish the rest, and come back. If you are allowed to use Help, ask before you start rather than guessing mid-test.
What you'll learn
| Task | Typical formula | Practice on DailyDrills |
|---|---|---|
| Total or count for one group | SUMIFS, COUNTIFS | Summing by condition: SUMIF, SUMIFS, AVERAGEIF and AVERAGEIFS |
| Pull a value from another table | VLOOKUP or XLOOKUP | The classic: VLOOKUP |
| Flag a row with a rule | IF, AND, OR | Decisions with IF |
| Lock a copied formula | $ in references | Relative and absolute references ($) |
| Summarise a table quickly | Pivot table | Summaries without formulas: pivot tables |
| Move and fill without the mouse | Shortcuts | Keyboard shortcuts for speed |
Common mistakes
Watching a 40-minute tutorial the night before. You will recognise the function and still not be able to type it under a timer.
Fix: Spend the same time on five short drills, and redo the ones you miss the next morning.
Copying the answer and calling it practice. The interview has no answer key.
Fix: Cover the solution, write the formula from the task wording, then uncover it to check.
Spending the whole slot on the first question. Later questions are often shorter and still count.
Fix: Give each question a time budget. Move on when it runs out.
Practising only in English Excel if the job uses another language. Function names and separators change.
Fix: DailyDrills can show formulas the way your Excel does. Switch the formula language in the header before you practice.
Frequently asked questions
What is an Excel test in a job interview?
A short timed workbook of real tasks: totals, lookups, IF rules, sometimes a pivot table. Employers use it to see whether you can work in a spreadsheet without help, not whether you know every function name.
How do I practice for an Excel job test?
Type the same kind of formulas under a timer, in a real grid, until you can write them from a sentence. DailyDrills at excel.dailydrills.app is built for that: interactive Excel drills with instant feedback. You can start for free.
Which Excel functions come up most often?
SUMIFS or COUNTIFS for a total or count with conditions, VLOOKUP or XLOOKUP to pull a value from another table, IF for a rule, and the $ in cell references so a copied formula stays pointed at the right cells.
Do I need VBA or macros?
Most job tests stay on formulas, tables and shortcuts. Read the job description. If it is unclear, ask the employer before the day.
How long should I practice?
A few 20-minute sessions over one or two weeks is enough for most people, if each session is timed and you redo what you miss. Cramming one long video the night before is not a substitute.
Can I start for free?
The first lessons are fully playable, with no account and no time limit. Some later lessons are Pro and show a preview. You can start at excel.dailydrills.app.
Related functions
- SUMIFSSUMIFS adds up values that meet several conditions at once, such as paid orders from one region.
- COUNTIFSCOUNTIFS counts the rows that meet several conditions at once, such as a region and an amount range.
- VLOOKUPVLOOKUP finds a value in the first column of a table and returns a value from the same row in another column.
- XLOOKUPXLOOKUP searches one column or row and returns the matching value from another, in any direction, with a built-in 'not found' message.
- IFIF checks a condition and returns one value if it's true and another if it's false.
- IFERRORIFERROR returns a value you choose when a formula produces an error such as #N/A or #DIV/0!, and the normal result otherwise.
Excel functions and guides
- Excel test for a job interview — What an Excel test in a job interview usually involves, how to practice under a time limit, and what to do on the day. Start for free with lessons and exercises here.
- Preparing for an Excel skills test — What Excel skills tests usually check, which functions and shortcuts matter most, and a practice plan that uses the lessons on this site.
- Excel practice exercises — A weekly Excel practice routine: which exercises to do first, how to check your answers, and how to build speed with real formulas. Start for free.