The two kinds of Excel tests
| Type | What it looks like | How to prepare |
|---|---|---|
| Multiple choice | Questions about what a formula returns or which menu does something | Know the common functions well enough to predict their result |
| Interactive (simulation) | A spreadsheet where you do the task yourself, often timed | Practice typing formulas quickly and correctly: this is the harder type |
Most job tests also come in levels. Basic tests ask for formulas, SUM and formatting. Intermediate tests add IF, absolute references, SUMIFS and lookups. Advanced tests add PivotTables, INDEX/MATCH, XLOOKUP and data cleaning.
Practice question 1: look up a price
Lookups are on almost every intermediate Excel test. Use XLOOKUP, VLOOKUP or INDEX/MATCH: any correct formula counts.
Find the price for a product code
In F2, look up the price of the product code in E2.
Practice question 2: IF with two conditions
Tests love conditions that combine: both must be true, or either one.
Who earns a bonus?
In D2, show Yes if sales in B2 are at least 10,000 and the rating in C2 is at least 4. Otherwise show No.
A 7-day plan before your Excel test
- Day 1: take the free 10-minute test to find your weak spots.
- Day 2: formulas, order of operations and absolute references ($A$1).
- Day 3: IF, AND, OR and nested IFs.
- Day 4: SUMIFS, COUNTIFS and AVERAGEIFS.
- Day 5: lookups: XLOOKUP, VLOOKUP with FALSE, INDEX/MATCH.
- Day 6: PivotTables, sorting and filtering, plus a timed mock test.
- Day 7: a second mock test in a different version, then review only what you got wrong.
Pro builds this plan around your actual test date and fills it with the lessons you need most.
Find your weak spots first
The free test tells you which days of the plan matter most for you.
Frequently asked questions
Where can I find a free Excel practice test?
The questions on this page and the 10-minute skills test are free and run in your browser. Pro adds four timed mock tests (office, analyst, finance and advanced), each in three versions.
How long should I practice before an Excel test?
If you already use Excel, 3 to 7 days of focused practice is usually enough to fix the gaps a test exposes. Starting from scratch, plan for two to three weeks.
Should I learn VLOOKUP or XLOOKUP?
Both. XLOOKUP is simpler and newer, but many tests and workplaces still use VLOOKUP. If you use VLOOKUP, always add FALSE for an exact match.
Are interactive Excel tests timed?
Usually, yes. That's why practicing in a real grid matters: knowing a formula isn't enough if typing it takes too long.