What is on the test
Every attempt draws five projects from a bank of ten so that the exam weights hold: data management about a third, advanced formulas and lookups about a third, charts and tables about a quarter, workbook settings and formats the rest.
- Nested logic and conditional statistics across several criteria
- Multi-criteria lookups and dynamic arrays: filter, sort and de-duplicate with one formula
- Dates and money: working days, loan payments and payment counts
- Data management: validation and conditional-formatting rules written as formulas, duplicates, cleanup
- Custom number formats and workbook settings
- PivotTables, slicers, chart types and Goal Seek (multiple choice)
How the timer works
One 50-minute clock runs for the whole exam, about two minutes per task. Inside a project you move freely between its five tasks and can mark any of them for review; submitting a project grades it and opens the next one, and there is no way back. When the clock reaches zero, the project on screen is graded as it stands.
How we score
Each task scores 1, 0.5 or 0. Half credit goes to a right value typed in without a formula, a formula that hides the expected number or breaks when an input changes, a range that is at least half right, and a task with two parts (a value and its number format) when only one part is right. The five sub-scores are weighted like the Expert exam objectives and converted linearly to a 1–1000 scale; 700 passes.
The 1–1000 scale700 or more passes
Domain weights: data management 33%, charts and tables 28%, formulas 18%, workbook settings and formats 13%, lookups 10%.
How hands-on tasks are graded
Any formula that produces the right result passes; we compare the value with a small tolerance and ignore case and spaces in text. The task names the cell, never the function. A typed-in constant and a formula that hides the expected number inside it both earn half credit, and where it matters we change an input on a copy of your sheet to check that your formula follows. The multiple-choice questions score 1 or 0; select-all-that-apply questions need the complete set.
What you get at the end
Your score on the 1–1000 scale against the 700 mark, five sub-scores, your time per task against the typical time, the task list grouped by project with a practice link for every miss, your three next exercises and a link you can share.
Modeled on the structure of the Microsoft Office Specialist Expert exam (MO-211): projects that share a workbook, task descriptions that never name the function, a 1–1000 scale with 700 to pass. Independent practice, not affiliated with Microsoft or Certiport.
Excel is a trademark of the Microsoft group of companies. Indeed, TestGorilla, SHL, iMocha, Adaface, Criteria and other marks are the property of their owners. GridBelt is independent and is not affiliated with, endorsed by or sponsored by any of them.