Excel level test · about 4 minutes
Is your Excel good enough?
Answer 12 questions, from simple formulas to INDEX/MATCH. Find out your level, what a job test would expect from you, and exactly where to start practising.
- 12 questions, easiest first
- 3 hands-on, in a real spreadsheet
- Your level and next step, instantly
Level 1
Basics
formulas, copying formulas and SUM
Level 2
Everyday formulas
IF, COUNTIF and SUMIF
Level 3
Lookups and summaries
VLOOKUP, SUMIFS and fixing lookup errors
Level 4
Advanced
INDEX/MATCH and PivotTables
What each Excel level means
The test has four levels of questions. How many you clear in a row decides your result, from Beginner (none yet) to Advanced (all four).
- Beginner
- Not yet, but the gap is smaller than you think. Start with the basics: moving around a sheet, simple formulas and SUM. Each lesson takes about 5 minutes.
- Basic · clears Basics
- Good enough for simple data entry. Not yet for most office job tests. You know your way around formulas. Next come IF, COUNTIF and SUMIF, the formulas everyday office work runs on.
- Everyday · clears Basics, Everyday formulas
- Good enough for many admin roles. Lookups are your next step. You handle everyday formulas. Office Excel tests often add VLOOKUP and SUMIFS, so that's where to go next.
- Intermediate · clears Basics, Everyday formulas, Lookups and summaries
- Good enough for most office and admin Excel tests. You can look up and summarise data. Analyst and finance tests go further, with INDEX/MATCH and PivotTables.
- Advanced · clears Basics, Everyday formulas, Lookups and summaries, Advanced
- Yes. Your Excel is ready for analyst-level work. You cleared every tier. Keep it sharp under time pressure with case studies and timed mock tests.
Want the full picture? Try a timed mock Excel test in the format employers use, or see how common employer Excel tests work.
Questions about the level test
How do I know my Excel level?
Do real tasks rather than rate yourself. This test asks 12 questions in four levels, from basic formulas to INDEX/MATCH and PivotTables, and three of them are hands-on in a spreadsheet. Your level is the highest one you clear in a row.
What Excel level do employers expect?
It depends on the role. Admin and data-entry roles usually check basics like formulas, SUM and sorting. Office, sales and operations roles often add IF, COUNTIF, SUMIF and VLOOKUP. Analyst and finance roles go further, with SUMIFS, INDEX/MATCH and PivotTables.
How is my level worked out?
There are four levels of three questions. A level counts when you get at least two of its three questions right, starting from Level 1. A lucky answer on a hard question can't skip a level, so the result reflects what you can really do.
Is this the same as an employer's Excel test?
No. It's a quick check of where you stand. Employer tests are longer and often timed. ExcelReady has timed mock tests in the same formats, and it isn't affiliated with any test provider or with Microsoft.
Should I skip questions I'm not sure about?
Yes. Skipping counts as a wrong answer, but a guess that happens to be right makes your level look higher than it is, and then your next lesson is pitched too high.