Free · no account needed
How good are your Excel formulas?
A free Excel skills test on a real spreadsheet. Up to 18 tasks that get harder as you go, and it stops as soon as it finds your level.
- Real formulas on a live sheet
- Your level, strengths and gaps
- The exact lesson to start with
- Skip anything you haven't learned
What it covers
- 1Formula basicscell references, + − × ÷, brackets, filling down and $ references
- 2Ranges and functionsSUM, AVERAGE, COUNT, MIN/MAX and ROUND
- 3Decisionscomparisons, IF, AND/OR and errors
- 4LookupsVLOOKUP, INDEX/MATCH and XLOOKUP
- 5Conditional totals and textSUMIFS, COUNTIFS, cleaning and joining text, dates
- 6Advanced formulasdynamic arrays (FILTER), two-way lookups and LET
An Excel skills assessment you do on a real sheet
Most Excel tests are multiple choice. This one is mostly hands-on: you click a cell, type a formula and press Enter, the way you would in Excel or Google Sheets at work. A few quick questions check that you know why, not just how.
The tasks follow the formulastreak course, from your first formula to lookups, conditional totals, text, FILTER and LET. Every task uses only things the course teaches, so your result maps straight onto it: you'll see exactly which lesson to start with.
Preparing for an Excel test in a job interview? It covers the skills those tests usually ask for. When you're done, the course's job test pack has timed rounds to practise with.
formulastreak is independent. This isn't an official Microsoft or Google certification exam.
Questions
How long does the Excel test take?+
Usually 5 to 15 minutes. It stops as soon as it finds your level, so most people answer 8 to 14 of the 18 tasks.
Is it like an Excel test for a job interview?+
It covers the same skills interview tests check: references and $, SUM and AVERAGE, IF, VLOOKUP and XLOOKUP, SUMIFS, text and dates, FILTER. You write real formulas on a live sheet, as you would in Excel or Google Sheets. It isn't an official Microsoft or Google exam.
Do I need Excel installed?+
No. Every task runs on a spreadsheet in your browser.
What happens with my result?+
You get a level (beginner, intermediate or advanced), your strengths and gaps, the lesson to start with, and a link you can share. With a free account you can apply it to the course, which marks the lessons you've shown you know as placed.
Is it really free?+
Yes, the test and the result are free, with no account needed. Units 1 and 2 of the course are free too; the rest is part of Pro.