Free · No sign-up · 20 minutes
Practice the Excel test employers actually give you
Many job applications include a timed Excel test where you work in a live spreadsheet. Your answers are formulas, not multiple-choice picks. This free practice test works the same way: 10 hands-on tasks, marked instantly, with model answers for anything you miss.
Works best on a laptop or desktop.
What's covered
- Basic formulas and copying them down
- SUM, AVERAGE, ROUND
- COUNTIF, SUMIF, SUMIFS
- IF statements
- VLOOKUP / XLOOKUP and INDEX + MATCH
- Absolute references ($A$1)
How it works
- Type = to start a formula, and click cells to add them
- Enter confirms; Esc cancels
- Drag the small square at a cell's corner to copy a formula down
- Ctrl+C / Ctrl+V, Ctrl+D fill down, Ctrl+Z undo
How it's marked
Each answer must be a formula that gives the right result. Behind the scenes we also change the data and check your formula still works, which is how real tests catch typed-in answers.
Got a real test coming up? Pick the pack for your job
Employers test different skills depending on the role. Practise the test you're actually going to face, with one-time payment and no subscription.
Already bought a pack? Enter your licence key