Excel practice › Excel interview test
Excel test for job interviews: 10 practice exercises with answers
This is a free Excel practice test with answers. You solve 10 exercises in a working spreadsheet in your browser, from a basic total to INDEX/MATCH. No download and no sign-up.
It is not any employer's or test vendor's actual test. It covers the skills such tests commonly list: totals and percentages, IF, conditional sums, lookups, text and dates.
What these tests check
| Level | What you're asked to do | On this page |
|---|---|---|
| Basic | Totals, averages, the largest value in a column; a percentage of a total | Exercises 1 and 2 |
| Intermediate | IF with a limit; a total for one customer (SUMIF, COUNTIF); filling a column from a second table (VLOOKUP or XLOOKUP); cleaning up text | Exercises 3 to 6 |
| Advanced | A total with two conditions (SUMIFS); a lookup to the left (INDEX/MATCH); working days between two dates; a lookup that may find nothing (IFERROR) | Exercises 7 to 10 |
Job postings and tests differ. Ask the recruiter which version of Excel the test uses and which level it targets. The version matters: XLOOKUP exists in Excel 2021 and later and in Microsoft 365, so on an older version you need VLOOKUP or INDEX/MATCH.
This page practices formulas. It doesn't cover pivot tables, charts or keyboard shortcuts.
Basic: totals, averages and a percentage
Every exercise uses the same made-up data: the March order log of an office-supplies company, with one row per order.
Type the formula in the box and press Enter. Clicking a cell inserts its address. Each answer is checked on the data you see and again on changed data, so a typed-in number won't pass. The answer is under each exercise.
The log lists the eight orders of March. In G2, calculate how far the largest order is above the average order amount.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Category | Amount | Above average | |
| 2 | 5001 | 3/2/2026 | Acme Dental | Paper | 180 | ||
| 3 | 5002 | 3/3/2026 | Northside Law | Ink | 210 | ||
| 4 | 5003 | 3/5/2026 | Acme Dental | Furniture | 640 | ||
| 5 | 5004 | 3/9/2026 | Harbor Realty | Paper | 120 | ||
| 6 | 5005 | 3/12/2026 | Northside Law | Paper | 270 | ||
| 7 | 5006 | 3/16/2026 | Harbor Realty | Ink | 140 | ||
| 8 | 5007 | 3/20/2026 | Acme Dental | Ink | 480 | ||
| 9 | 5008 | 3/24/2026 | Lakeview Clinic | Furniture | 360 |
Show the answer
=MAX(E2:E9)-AVERAGE(E2:E9) gives 340.
MAX returns the largest amount (640) and AVERAGE the mean of the eight (300). A function's result is a number, so you can subtract one from the other. Give both the whole range, not a list of cells: a list is where a row gets left out.
Order 5007 is in row 8. In F8, calculate what share of the month's total that order is. The result is a decimal (0.35 would mean 35%); in Excel you'd then format the cell as a percentage.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Category | Amount | Share |
| 2 | 5001 | 3/2/2026 | Acme Dental | Paper | 180 | |
| 3 | 5002 | 3/3/2026 | Northside Law | Ink | 210 | |
| 4 | 5003 | 3/5/2026 | Acme Dental | Furniture | 640 | |
| 5 | 5004 | 3/9/2026 | Harbor Realty | Paper | 120 | |
| 6 | 5005 | 3/12/2026 | Northside Law | Paper | 270 | |
| 7 | 5006 | 3/16/2026 | Harbor Realty | Ink | 140 | |
| 8 | 5007 | 3/20/2026 | Acme Dental | Ink | 480 | |
| 9 | 5008 | 3/24/2026 | Lakeview Clinic | Furniture | 360 |
Show the answer
=E8/SUM(E2:E9) gives 0.2.
A share is the part divided by the whole: 480 out of 2,400. Before copying this formula down a column, write the total as SUM($E$2:$E$9). Without the $ signs the range moves down one row with each copy, and the shares below the first come out wrong.
Intermediate: IF, conditional totals, lookups and text
Same order log. Two of these exercises bring in a second table, which is where lookups come from: one table has the key, the other has the detail you need.
Orders of $300 or more ship free. Smaller orders pay $15 for shipping. In F2, calculate what to bill for order 5001: the amount, plus shipping when it applies.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Category | Amount | To bill |
| 2 | 5001 | 3/2/2026 | Acme Dental | Paper | 180 | |
| 3 | 5002 | 3/3/2026 | Northside Law | Ink | 210 | |
| 4 | 5003 | 3/5/2026 | Acme Dental | Furniture | 640 | |
| 5 | 5004 | 3/9/2026 | Harbor Realty | Paper | 120 | |
| 6 | 5005 | 3/12/2026 | Northside Law | Paper | 270 | |
| 7 | 5006 | 3/16/2026 | Harbor Realty | Ink | 140 | |
| 8 | 5007 | 3/20/2026 | Acme Dental | Ink | 480 | |
| 9 | 5008 | 3/24/2026 | Lakeview Clinic | Furniture | 360 |
Show the answer
=IF(E2>=300,E2,E2+15) gives 195.
IF returns one of two values, and either one can be a calculation. The mistake to avoid is the limit itself: "$300 or more" is >=, not >. Test your formula in your head with the exact limit before you move on.
A customer name is typed in G2. In H2, total the amount of that customer's orders.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Category | Amount | Customer | Total | |
| 2 | 5001 | 3/2/2026 | Acme Dental | Paper | 180 | Acme Dental | ||
| 3 | 5002 | 3/3/2026 | Northside Law | Ink | 210 | |||
| 4 | 5003 | 3/5/2026 | Acme Dental | Furniture | 640 | |||
| 5 | 5004 | 3/9/2026 | Harbor Realty | Paper | 120 | |||
| 6 | 5005 | 3/12/2026 | Northside Law | Paper | 270 | |||
| 7 | 5006 | 3/16/2026 | Harbor Realty | Ink | 140 | |||
| 8 | 5007 | 3/20/2026 | Acme Dental | Ink | 480 | |||
| 9 | 5008 | 3/24/2026 | Lakeview Clinic | Furniture | 360 |
The small table in F1:G5 says which sales rep handles each customer. In D2, return the rep for the order in row 2.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Order | Customer | Amount | Rep | Customer | Rep | |
| 2 | 5001 | Acme Dental | 180 | Acme Dental | Dana | ||
| 3 | 5002 | Northside Law | 210 | Harbor Realty | Priya | ||
| 4 | 5003 | Acme Dental | 640 | Lakeview Clinic | Owen | ||
| 5 | 5004 | Harbor Realty | 120 | Northside Law | Marcus | ||
| 6 | 5005 | Northside Law | 270 | ||||
| 7 | 5006 | Harbor Realty | 140 | ||||
| 8 | 5007 | Acme Dental | 480 | ||||
| 9 | 5008 | Lakeview Clinic | 360 |
Show the answer
=VLOOKUP(B2,F2:G5,2,FALSE) gives Dana.
The value to find is the customer in B2, the table is F2:G5 and the rep is its 2nd column. FALSE asks for an exact match. Before copying the formula down, lock the table as $F$2:$G$5. =XLOOKUP(B2,F2:F5,G2:G5) returns the same rep. More on VLOOKUP and XLOOKUP.
This contact list was exported from another system with stray spaces before and after the names. You can't see them, but they are there. In D2, build the name as Last, First with no extra spaces.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | First | Last | Company | Name |
| 2 | Renee | Okafor | Acme Dental | |
| 3 | Luis | Marquez | Northside Law | |
| 4 | Tanya | Brooks | Harbor Realty | |
| 5 | Wei | Chen | Lakeview Clinic | |
| 6 | Omar | Haddad | Acme Dental | |
| 7 | Grace | Lindholm | Northside Law |
Show the answer
=TRIM(B2)&", "&TRIM(A2) gives Okafor, Renee.
TRIM removes the spaces before and after a text and leaves single spaces between words. & joins the pieces, including the comma and space in quotes. Stray spaces are also a usual reason a lookup returns #N/A on a value that looks right.
Advanced: two conditions, INDEX/MATCH, dates and a lookup that fails
These four are the ones worth doing twice. Each has one detail that decides whether the result is right: an operator joined to a cell, the order of the ranges, which days get counted, what happens when nothing is found.
In H4, total the orders of the category in G2 that were placed on or after the date in H2.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Category | Amount | Category | From | |
| 2 | 5001 | 3/2/2026 | Acme Dental | Paper | 180 | Paper | 3/9/2026 | |
| 3 | 5002 | 3/3/2026 | Northside Law | Ink | 210 | |||
| 4 | 5003 | 3/5/2026 | Acme Dental | Furniture | 640 | Total | ||
| 5 | 5004 | 3/9/2026 | Harbor Realty | Paper | 120 | |||
| 6 | 5005 | 3/12/2026 | Northside Law | Paper | 270 | |||
| 7 | 5006 | 3/16/2026 | Harbor Realty | Ink | 140 | |||
| 8 | 5007 | 3/20/2026 | Acme Dental | Ink | 480 | |||
| 9 | 5008 | 3/24/2026 | Lakeview Clinic | Furniture | 360 |
Show the answer
=SUMIFS(E2:E9,D2:D9,G2,B2:B9,">="&H2) gives 390.
SUMIFS starts with the range to add up, then takes pairs of range and condition. A comparison with a cell is written as text joined to the cell: ">="&H2. With > alone, the order placed on March 9 would be left out.
In G2, return the name of the customer who placed the largest order. The customer column is to the left of the amounts, so VLOOKUP can't do it.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Category | Amount | Top customer | |
| 2 | 5001 | 3/2/2026 | Acme Dental | Paper | 180 | ||
| 3 | 5002 | 3/3/2026 | Northside Law | Ink | 210 | ||
| 4 | 5003 | 3/5/2026 | Acme Dental | Furniture | 640 | ||
| 5 | 5004 | 3/9/2026 | Harbor Realty | Paper | 120 | ||
| 6 | 5005 | 3/12/2026 | Northside Law | Paper | 270 | ||
| 7 | 5006 | 3/16/2026 | Harbor Realty | Ink | 140 | ||
| 8 | 5007 | 3/20/2026 | Acme Dental | Ink | 480 | ||
| 9 | 5008 | 3/24/2026 | Lakeview Clinic | Furniture | 360 |
Show the answer
=INDEX(C2:C9,MATCH(MAX(E2:E9),E2:E9,0)) gives Acme Dental.
MAX finds the largest amount, MATCH finds its position in E2:E9 (the 0 means exact match), and INDEX returns the customer at that position in C2:C9. The two ranges have to cover the same rows. =XLOOKUP(MAX(E2:E9),E2:E9,C2:C9) returns the same name where XLOOKUP exists. More on INDEX and MATCH.
In D2, count the working days (Monday to Friday) that order 5001 took to arrive, counting both the day it was ordered and the day it was delivered.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Order | Ordered | Delivered | Working days |
| 2 | 5001 | 3/2/2026 | 3/10/2026 | |
| 3 | 5002 | 3/3/2026 | 3/6/2026 | |
| 4 | 5003 | 3/5/2026 | 3/17/2026 | |
| 5 | 5004 | 3/9/2026 | 3/13/2026 | |
| 6 | 5005 | 3/12/2026 | 3/20/2026 | |
| 7 | 5006 | 3/16/2026 | 3/18/2026 |
Show the answer
=NETWORKDAYS(B2,C2) gives 7.
NETWORKDAYS counts Monday to Friday from the start date to the end date, both included. Plain subtraction, =C2-B2, counts calendar days and leaves out the first one: it gives 8 here. Read the question for which of the two it wants.
Next week's orders. Order 5009 comes from a customer that isn't in the rep table yet. In D2, return the rep for the customer in B2, or the text Unassigned when the customer isn't in the table.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Order | Customer | Amount | Rep | Customer | Rep | |
| 2 | 5009 | Pine Street Vet | 95 | Acme Dental | Dana | ||
| 3 | 5010 | Harbor Realty | 230 | Harbor Realty | Priya | ||
| 4 | 5011 | Acme Dental | 410 | Lakeview Clinic | Owen | ||
| 5 | 5012 | Northside Law | 150 | Northside Law | Marcus | ||
| 6 | 5013 | Lakeview Clinic | 275 | ||||
| 7 | 5014 | Acme Dental | 60 |
Show the answer
=IFERROR(VLOOKUP(B2,F2:G5,2,FALSE),"Unassigned") gives Unassigned.
IFERROR returns the lookup's result when there is one, and your text when the lookup ends in an error. IFNA is the stricter choice: it only catches #N/A, so other errors stay visible. With XLOOKUP, the fallback text can go in its 4th argument instead.
How to use the time you have
If the test is tomorrow. Do the 10 exercises on this page. For each one you couldn't solve, open the answer, read why it works, then empty the box and type the formula yourself. After that, take the free 10-question Excel test: it uses different data, and it ends with a level and the first topic you missed.
If you have a few days. Work on what you missed. Lesson 1 (cells, SUM, AVERAGE, MAX) and lesson 2 (IF, AND, OR, nested IF) are free, and so are the function pages linked from each answer. The lessons on VLOOKUP, XLOOKUP, SUMIFS and COUNTIFS, INDEX/MATCH and dates are part of Pro: $29 once for all three tracks, or $19 for the Excel track alone. No subscription, and a 14-day refund.
If the posting mentions more than formulas. Pivot tables and keyboard shortcuts are not on this page. They are lesson 9 and lesson 8, also part of Pro.
Applying for a specific kind of job? There is a version of this page for accounting interviews and one for data analyst interviews.
Questions people ask
Is this Excel test for interviews free, and are the answers included?
Yes to both. Every exercise has a Show the answer line under it, with the formula, its result and a short explanation. The page is free and there is nothing to sign up for.
Do I need Excel installed to take this practice test?
No. The spreadsheet on this page runs in your browser, on a computer or a phone. The formulas are the same ones Excel uses, so what you type here is what you would type in Excel. Two differences: the sheet here supports the common functions, not all of Excel, and it shows plain numbers (0.2 where Excel shows 20% once you format the cell).
Is this the same Excel assessment test an employer will give me?
No. This is practice material written for this site, not a copy of any employer's or test company's test. Real tests differ in level, in length and in format. Ask the recruiter three things: which version of Excel the test uses, which level it targets (basic, intermediate or advanced), and whether it is timed.
How long does this Excel interview practice test take?
It has 10 exercises and no timer, so it takes as long as you need. If your real test is timed, do the page once to learn the formulas, then come back and do it again without opening the answers.