What is on the test
Tasks are drawn from a bank of 60 items so that every attempt covers the same six areas in the same proportions, with new numbers in every spreadsheet.
- Formatting and cell mechanics: number formats, percentages, freeze panes, merge versus center across selection, wrap text, the fill handle (25%)
- SUM, AVERAGE, MIN, MAX, COUNT, COUNTA and COUNTBLANK on real data (20%)
- IF, COUNTIF, COUNTIFS and SUMIF (20%)
- Absolute references with $ and references to other sheets (15%)
- Joining and trimming text: &, LEFT, RIGHT, PROPER, LEN (10%)
- Sort, filter and chart basics (10%)
How the timer works
Each task has its own 90-second countdown. When it reaches zero, whatever is in the answer cell is graded and the next task opens. There is no pause button and no way back, the way most screening tests work, so read the task once and start typing. The elapsed time for the whole test is shown too.
How we score
A correct cell or answer scores 1 point. A right value typed in without a formula, or a formula that hides the expected number, misses a reference the task needs or breaks when an input changes, scores 0.5; everything else 0. Your percentage lands in one of five bands:
- Expert93% and above
- Highly proficient80–92%
- Proficient65–79%
- Familiar50–64%
- Needs practicebelow 50%
These are our cutoffs — test vendors never publish theirs.
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 band and percentage, five sub-scores (Formulas & Functions, Formatting & Cell mechanics, Data management, Lookups & References, Charts & Pivots), your time per task against the typical time, a task-by-task list with a practice link for every miss, your three next exercises and a link you can share. The free result badge is a badge, not a certificate.
Modeled on the discontinued Indeed Excel assessment and on TestGorilla-style screening tests: one task per screen, a timer on every task, no going back.
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.