0–6 points
Start at the beginning — and that is a normal place to be
You are getting work done in Excel by treating it as a grid you type into. That works, and it caps out quickly. Introduction to Excel covers structure and references, which is what everything above this level is built on.
If most of your low answers were about lookups and pivot tables specifically, and the rest felt easy, Excel Intermediate 1 may be a better fit.
Introduction to Excel
7–13 points
Excel Intermediate 1
You are comfortable entering and formatting data, and you are still doing the summarising by hand. Intermediate 1 is where tables, sorting, filtering and proper referencing turn that into something the workbook does for you.
Introduction to Excel if the referencing question was a guess; Intermediate 2 if you are already confident with tables and filters.
Excel Intermediate 1
14–19 points
Excel Intermediate 2
You have the basics solidly and you are hitting the ceiling on conditional logic and lookups. Intermediate 2 covers those plus pivot tables, which from your answers is the piece that would change the most work.
Advanced Functions instead if lookups are already routine and it is the multi-condition formulas that trip you up.
Excel Intermediate 2
20–25 points
Excel Advanced Functions, or Advanced Data Management
You can build most of what you need and the remaining problems are about formulas that survive contact with changing data. Advanced Functions covers the lookup family and conditional aggregation properly.
Advanced Data Management instead if your answer to the monthly-report question was the painful one — that is a Power Query problem, not a formula problem.
Excel Advanced Functions
26–30 points
One of the Expert courses — pick by what you are building
You are past the point where a general course helps. The Expert courses are specialised: Expert Functions for dynamic arrays and models other people depend on, Expert Dashboard for reporting, Expert Macros and Forms for automation.
Expert Dashboard if you were asked for a dashboard; Expert Macros and Forms if the fifteen-clicks question was the one that stung.
Excel Expert Functions