Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Excel test

Intermediate Excel Test: 20 Tasks in 25 Minutes

A free simulation-style test: 20 tasks in two realistic workbooks, 17 of them in a live spreadsheet, one 25-minute clock and one attempt per task. Your percentage, the 80% pass line and five sub-scores appear the moment you finish.

Level 2: Intermediate

What to expect

  • 20 tasks in two workbooks: 17 in the live spreadsheet, 3 multiple choice.
  • One 25-minute clock for the whole test, about 75 seconds per task.
  • The task list stays visible. Tasks go in order, forward only, one attempt each.
  • Any formula that produces the right result counts. A typed-in number earns half credit.
  • Your percentage, the 80% pass line and five sub-scores appear the moment you finish.

Submit each task with Ctrl+Enter (⌘+Enter on Mac) or the button.

Desktop recommended: 17 of the 20 tasks are done in a real spreadsheet.

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.

Format facts

  • 20 tasks in two workbooks of 2–3 sheets: 17 hands-on, 3 multiple choice
  • One 25-minute clock for the whole test, average pace shown
  • Task list visible, forward only, one attempt per task
  • Percentage score with an 80% pass line and five sub-scores

Preparing for a test? The 7-day Level 2 plan →

Excel test

  • Level 1: Beginner
  • Level 3: Expert