How to Pass an Excel Test for a Job Interview

To pass an Excel test for a job interview, you need a small set of skills you can use quickly and correctly: totals, IF, COUNTIF and SUMIF, a lookup, absolute references, filters and a basic pivot table. This guide is for job seekers who have a test coming up and want to know what to expect, how to practise in a week, and how to avoid the mistakes that lose the most points.

What an Excel test for a job interview looks like#

An Excel test for a job interview is usually a short, practical task on a spreadsheet, not a theory exam. You get a dataset, such as a list of employees, orders or expenses, and a set of questions a manager might ask.

Common formats include:

• A workbook in real Excel, on the employer's computer or sent to you by email, with questions in the file.
• An online test platform that shows a spreadsheet in the browser, often with a timer and multiple-choice or "type the answer" questions.
• A live task over screen share, where an interviewer watches you work and may ask you to explain your formula.

The questions rarely name the function. Instead of "use SUMIF", you get "What is the total payroll for Sales?" Part of the test is knowing which tool fits the question. Ask the recruiter which format to expect and whether the test uses Excel or another spreadsheet app, because the answer changes how you practise.

The skills most Excel tests check#

Most tests draw from the same short list. If you can do everything in this table without looking it up, you are ready for a typical entry-level or mid-level test.

Finance, analyst and HR roles often add dates, rounding and multi-condition formulas. See the Excel skills employers expect in finance jobs and the skills that come up for admin and office roles for role-specific lists.

Worked example: a mini Excel test#

Here is a short test on a six-person roster. The ID is in column A, the name in B, the department in C and the salary in D, with data in rows 2 to 7.

1. "What is the salary of the employee in F2?"#

With E-104 in F2:

=VLOOKUP(F2,A2:D7,4,FALSE)

VLOOKUP finds the ID in the first column of A2:D7, moves to the 4th column (Salary) and returns 98000. FALSE means exact match. Leave it out and VLOOKUP uses an approximate match, which can quietly return the wrong row. The step-by-step VLOOKUP guide covers every argument, and the VLOOKUP function reference has more examples.

2. "What is the total payroll for Sales?"#

=SUMIF(C2:C7,"Sales",D2:D7)

SUMIF checks the departments in C2:C7, and adds the salaries in D2:D7 for the rows that say Sales: 72000 + 61000 + 69500 = 202500. See the SUMIF function guide for criteria like ">50000".

3. "How many people work in Sales?"#

=COUNTIF(C2:C7,"Sales")

The result is 3. If the department is typed in a cell, say H1, use =COUNTIF(C2:C7,H1) instead, so the answer changes when the cell does.

4. "Flag salaries over 70,000."#

=IF(D2>70000,"Yes","No")

In E2 this returns Yes for Rachel. Fill it down to E7 with Ctrl+D (Mac: ⌘D) to flag every row.

How to answer so the grader gives you the points#

Getting the right number is only part of it. Many tests also check how you got it.

• Point at cells, don't type values. =SUMIF(C2:C7,H1,D2:D7) updates when H1 changes. A typed 202500 does not. Graders often change an input to see if your answer follows.
• Lock ranges before you fill down. If you copy a VLOOKUP down, write the table as $A$2:$D$7 so it doesn't slide. Press F4 while editing a reference to add the $ signs (Mac: ⌘T).
• Keep the data intact. Don't delete rows, retype values or sort only one column. Work in empty cells next to the data.
• Check one answer by hand. Filter the Sales rows and glance at the total, or add three numbers in your head. It takes seconds and catches most mistakes.

If the test includes spoken questions, the Excel interview questions with practice answers shows how to explain your formulas out loud.

A one-week plan to prepare for an Excel test#

A week of short daily sessions is enough to sharpen the basics for a typical test. Spend 30 to 60 minutes a day.

On day 5, learn both lookups. XLOOKUP is easier and needs Excel 2021 or Microsoft 365, but VLOOKUP works in every version and still appears in tests. The VLOOKUP vs XLOOKUP comparison explains when each fits.

Mistakes that cost the most points#

These are the errors that most often turn a right idea into a wrong answer:

1. Forgetting FALSE in VLOOKUP. Without it, an unsorted table can return a wrong match with no error.
2. Relative ranges in a filled formula. A2:D7 becomes A3:D8 one row down and drops the top row.
3. Hardcoded numbers. =D2*0.1 breaks when the rate changes. Put the rate in a cell and use =D2*$H$1.
4. Formatting instead of rounding. Showing two decimals doesn't change the stored value. If a question says "round", use ROUND.
5. Running out of time on one question. Skip it, finish the rest, then come back.

Practise it#

The best preparation is doing a realistic test with a timer. Start with VLOOKUP in a live spreadsheet, then take the HR roster interview drill, which asks unlabelled questions about a 12-person roster, and the sales report interview drill, which covers revenue, totals by region and month, and a % of total column. Try the exercise below first: it is question 1 from the mini test.