Sheet Snack

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.

Lesson 1 of 3 · SUMIF

Total the sales for one region

ABCD
1RegionSalesEast total
2East120?
3West80
4East200
5North150
6West60
7East90

Type the formula for D2 that adds up the Sales of every East row.

Lesson 2 of 3 · VLOOKUP or XLOOKUP

Look up a price by product ID

ABCDE
1IDProductPriceFind IDPrice
2P101Stapler4.50P104?
3P102Notebook2.25
4P103Desk lamp18.90
5P104Mouse12.00
6P105Tape1.80

Type the formula for E2 that returns the price of the ID typed in D2.

Lesson 3 of 3 · IF

Mark who passed

ABC
1NameScoreResult
2Maria68?

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:

$19 one time, lifetime access

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.