Test your Excel skills
This test finds your Excel level in 20 tasks. You type real formulas into a real sheet. Nothing is multiple choice.
About 15 minutes. You need a keyboard, so do it on a computer. You will see how you did at the end, not task by task. You can stop early and still get a result.
What it measures
The tasks run in the order a beginner meets the ideas. Nothing is asked before the thing it depends on. That is why stopping halfway still gives a level. A task you skip is not marked wrong. It is just not counted.
- Reading a sheet. You can point a formula at a cell.
- Totals and counts. You can total and count a column.
- Locking a reference. You can write a formula that survives being copied.
- Decisions with IF. You can make a formula choose between two answers.
- Totals with a condition. You can summarise a list by category.
- Lookups. You can pull a value out of a table by its key.
- Working with text. You can cut a value out of a longer string.
- Dates. You can work out how long something took.
Why it is not multiple choice
A multiple-choice test measures whether you recognise a formula, not whether you can write one. Four options also give a quarter of the marks to guessing. Here you type into the sheet and the same engine that marks the lessons marks the answer. So the result can tell you something a quiz cannot. Not just that a task was wrong, but that you reached the right number without locking the reference. Or that you built it by hand instead of with the function.
What the result is, and is not
It is a reading of what you did in these 20 tasks. It is worked out in your browser and not sent anywhere. Until you see your result, this browser keeps how each task went, but not what you typed. There is no account to make and no score to look up later. It is not a certificate, and not proof of anything to an employer. This page will not pretend otherwise.