What's on the free Excel test
The test covers the skills that show up most often in Excel assessments for office, finance and analyst jobs. Each task is one realistic problem in a small spreadsheet.
| # | Skill | What you do |
|---|---|---|
| 1 | Formulas | Multiply units by price |
| 2 | Functions | Total six months of figures |
| 3 | References | Apply a fixed bonus rate with an absolute reference |
| 4 | Logic | Decide free shipping with IF |
| 5 | Conditional sums | Total the sales for one region |
| 6 | Lookups | Find a price from a product code |
| 7 | Text | Combine first and last names |
| 8 | Dates | Work out a delivery time |
| 9 | Shortcuts | Lock references the fast way |
| 10 | Lookups | Fix a lookup that returns the wrong result |
Try a sample question
This is the kind of task you'll see. Type a formula in the bar, or click the cells to insert them, then press Enter.
How many orders are over $500?
In E2, count the orders in column B that are larger than $500.
How the test is scored
- Real formulas, not multiple choice. You type the answer the way you would in Excel.
- It checks the formula, not just the number. If you type the result by hand, or a reference breaks when copied down, it's marked wrong, just like a strict employer test.
- A skill report at the end shows your score per skill and the exact lessons to practice next.
Who the test is for
- Job applicants who've been told there's an Excel test in the process
- Students and graduates who want to know where they stand before an internship
- Anyone who uses Excel daily but learned it by trial and error
Ready? It takes 10 minutes.
Free, no account needed. Your result stays in your browser.
Frequently asked questions
Is the Excel test really free?
Yes. The 10-minute skills test, the first three lessons and the speed drills are free, with no account and no card. Pro adds all lessons and the timed mock tests.
Do I need Excel installed?
No. The test runs in a spreadsheet in your browser, so it works on any computer, including a Mac or a work laptop without Excel.
Is this the same as the Excel test employers use?
No test is identical to every employer's, but this one covers the skills that come up most often: formulas, references, IF logic, SUMIFS, lookups, text and dates.
What score is good?
For most office jobs, aim for 8 out of 10 or better. The report shows which skills cost you points, and links to the lessons that fix them.