Free Assessment · No Email Required
Fifteen real questions, scored the moment you finish, with an explanation for every single one. Most people are somewhere in the middle and are surprised by which half they lose points in. Take about four minutes, find out where the gaps actually are, and get pointed at the class that fixes them.
Fifteen multiple choice questions across five skill areas. No timer, no sign up, and nothing is saved.
=$B$2, what do the dollar signs do?=COUNTA(A1:A20) count?#N/A. What is the most likely cause?=VLOOKUP(A2,B:D,3,FALSE), what is FALSE doing?Ctrl + T. What happens?=IF(B2>100,"Over","Under") return?IFERROR used for?Most Excel self-assessments ask you how confident you feel. That tells you very little, because confidence and competence come apart badly in Excel. People who have used it daily for a decade routinely score in the middle, because they learned one path through the program and never needed a second. This test asks fifteen questions with actual right answers instead.
The fifteen questions are split evenly across five areas, three questions each. That split is deliberate. A single overall number hides the thing you most need to know, which is where the points went missing. Someone who scores 9 out of 15 with all six lookup and pivot questions wrong needs something completely different from someone who scores 9 with the losses spread evenly.
SUM and COUNTA, and what a dollar sign is doing in a reference. Absolute references are the single most common gap in people who have used Excel for years without formal training, and it quietly breaks every formula they copy.
VLOOKUP, XLOOKUP, why #N/A appears and what the final argument controls. Lookups are where most business spreadsheets either work or silently return the wrong number.
Ctrl + T, Find and Replace, and how Remove Duplicates decides what a duplicate is. This is the area where people lose the most time doing manually what takes one dialog box.
What a pivot is for, why it stops picking up new rows, and what conditional formatting does and does not change. The pivot refresh question catches almost everyone the first time.
IF statements and their boundary behavior, IFERROR, and how sheet protection actually works. The IF question turns on whether the comparison is greater than or greater than or equal to, which is a distinction that causes real reporting errors.
Three bands, and a recommendation attached to each. None of them is a verdict on how good you are at your job.
| 0 to 7 | Foundations first | The gaps are in things used every day, so the return on fixing them is immediate |
| 8 to 11 | Solid with holes | Typical of self-taught users. Check which areas lost points, then fill those |
| 12 to 15 | Advanced ready | The fundamentals are there. Time to spend on dashboards, automation and modeling |
Scoring 8 to 11 is the most common outcome by a wide margin, and it is also the least useful number on its own. That band is where the per-area breakdown matters most, because two people with the same score can need opposite things.
Worth saying plainly, because self-assessments get over-read.
Nothing here is accredited and there is no certificate. If you need a formal credential for a job application, the Microsoft Office Specialist Excel exam is the recognised one.
Power Query, Power Pivot, VBA, array formulas and financial modeling are all absent. A high score means the fundamentals are sound, not that there is nothing left to learn.
Multiple choice flatters you. Picking the right answer from four options is easier than producing it in a blank spreadsheet on a deadline, so treat a strong score as a floor rather than a ceiling.
When B2 is exactly 100, greater than 100 is false, so the formula returns the second argument. People read it quickly and answer with the first. In a real report, that off-by-one puts every borderline record in the wrong bucket.
The pivot refreshed, so it must be current. It is not, because the source was a fixed range that did not grow with the data. This is the most common cause of a stale dashboard that nobody notices for a month.
An open password protects the file, not the formulas. Every cell is locked by default and that lock only takes effect once the sheet is protected, so the actual sequence is to unlock the input cells first, then protect.
Conditional formatting changes how a cell looks. Data validation controls what can be typed into it. Confusing the two leads to rules that highlight bad data instead of preventing it.
Plenty of people know what the dollar sign looks like without knowing what it does, because they have only ever pressed F4 when a copied formula broke. Knowing why it broke is what stops it happening again.
Sometimes a high score and a slow process are the same spreadsheet.
Free 14-day trial. No credit card required.
Yes. The test is free, there is nothing to buy and no email address is required to see your score. Your result appears on the page the moment you finish the last question.
Most people finish in three to five minutes. There are fifteen multiple choice questions with no timer, so you can take as long as you want on any single question.
Five areas, three questions each: core formulas and references, lookups, tables and data cleanup, PivotTables and analysis, and logic with sheet protection. These are the skills that come up most often in day to day business use.
Yes. After you submit, every question is listed with your answer, the correct answer and a short explanation of why. That review is the most useful part of the test, because it shows you exactly which topics to work on.
No. This is a free self-assessment, not a Microsoft certification. It is designed to place you in the right course quickly. If you need a formal credential, look at the Microsoft Office Specialist Excel certification instead.
Twelve or higher out of fifteen means you have solid working knowledge and are ready for advanced material. Eight to eleven is typical for someone who uses Excel regularly but learned it piecemeal. Seven or below means the fundamentals will pay off fastest.
As many times as you like. Nothing is stored and there is no limit. Retaking after working through a course is a reasonable way to check what actually stuck.
No. Every question applies to Excel 2016 and later, including Microsoft 365 and Excel for Mac. One question mentions XLOOKUP, which is Microsoft 365 only, but knowing what it does is enough to answer it.
Your result recommends one directly. Lower scores are pointed to Excel Foundations, which builds from the basics, and higher scores to the Excel Xpert Collection, which covers advanced formulas, dashboards and automation.
No. Scoring happens in your browser and nothing is sent anywhere or stored. Refreshing the page clears the result entirely.
You are welcome to send candidates the link, though bear in mind it is public and the answers are visible in the page source to anyone who looks. It works better as a conversation starter than as a gate.
The Excel training is free because it is how most people find XecuteTheVision. The paid products are the workbook bundles and the Updoot platform, and neither is required to work through any lesson.
Every lesson in both Excel courses is free to watch, with no account and no email required. Start wherever your result pointed you.
Browse the Free Excel Courses →