Got an Excel test for a job?
Many employers give applicants a short Excel test: look up a price, total sales for one region, flag who passed. Practice those exact tasks here. Type the formula like you would in Excel, and it is checked at once.
3 free lessons below. No sign-up needed.
Total the sales for one region
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Region | Sales | East total | |
| 2 | East | 120 | ? | |
| 3 | West | 80 | ||
| 4 | East | 200 | ||
| 5 | North | 150 | ||
| 6 | West | 60 | ||
| 7 | East | 90 |
Type the formula for D2 that adds up the Sales of every East row.
Look up a price by product ID
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | ID | Product | Price | Find ID | Price |
| 2 | P101 | Stapler | 4.50 | P104 | ? |
| 3 | P102 | Notebook | 2.25 | ||
| 4 | P103 | Desk lamp | 18.90 | ||
| 5 | P104 | Mouse | 12.00 | ||
| 6 | P105 | Tape | 1.80 |
Type the formula for E2 that returns the price of the ID typed in D2.
Mark who passed
| A | B | C | |
|---|---|---|---|
| 1 | Name | Score | Result |
| 2 | Maria | 68 | ? |
The pass mark is 70. Type the formula for C2 that shows Pass when the score is 70 or more, and Fail otherwise.
The full practice pack
Built for the Excel tests employers give before an interview:
- 60 practice tasks in the same style as above, checked as you type
- VLOOKUP and XLOOKUP, SUMIFS and COUNTIFS, IF and nested IF, absolute references, sorting and filtering, pivot tables, text and date formulas
- A timed mock test with your score at the end
- Every answer explained in plain words
It is not open yet. We are building it now. Leave your email and we will send you the link the day it opens, at the $19 early price. You pay nothing today.
Free cheat sheets
14 formulas that clean any messy list and 25 Excel shortcuts, free PDFs.