What is on the test
Each attempt draws two workbook families from a bank of four, ten tasks each. Every family is one business workbook with two or three sheets, and its numbers are generated fresh for every attempt.
- Lookups across sheets: VLOOKUP or XLOOKUP joins, INDEX and MATCH
- Conditional totals and counts: SUMIFS and COUNTIFS summary tables
- Logic: IF with AND and OR, flags for missing or out-of-range values
- Cleanup: text to real dates, trimming and joining text, finding duplicates
- Filtering by formula and the logic behind conditional formatting
- Reading a pivot table and choosing chart rows and columns (multiple choice)
How the timer works
One 25-minute clock runs for the whole test; there is no limit per task, and the bar shows the average pace of 75 seconds per task. Each task is graded when you submit it and the next one opens; there is no way back. When the clock reaches zero, the task on screen is graded as it stands and the test ends.
How we score
A correct task scores 1 point. A right value typed in without a formula, a formula that hides the expected number or breaks when an input changes, and a range that is at least half right score 0.5; everything else 0. Your percentage is compared with an 80% pass line, and five sub-scores show where the points came from.
The pass line80% or more passes
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 percentage against the pass line, five sub-scores (Formulas & Functions, Formatting & Cell mechanics, Data management, Lookups & References, Charts & Pivots), your time per task against the typical time, the task list grouped by workbook with a practice link for every miss, your three next exercises and a link you can share.
Modeled on SHL-type and Criteria-style simulation tests: tasks inside one workbook, a visible task list, forward only, one attempt per task, one clock.
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.