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

D2fx=SUMIFS(C2:C6,B2:B6,"North",A2:A6,"Ana")
ABCD
1RepRegionSalesNorth, Ana
2AnaNorth180390
3BenSouth90
4AnaNorth210
5CamEast140
6BenNorth55

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

TaskTypical formulaPractice on DailyDrills
Total or count for one groupSUMIFS, COUNTIFSSumming by condition: SUMIF, SUMIFS, AVERAGEIF and AVERAGEIFS
Pull a value from another tableVLOOKUP or XLOOKUPThe classic: VLOOKUP
Flag a row with a ruleIF, AND, ORDecisions with IF
Lock a copied formula$ in referencesRelative and absolute references ($)
Summarise a table quicklyPivot tableSummaries without formulas: pivot tables
Move and fill without the mouseShortcutsKeyboard 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

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.