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. Practice
  2. Programs
  3. Excel test in 7 days

Level 2 plan · free

Prepare for the Intermediate Excel Test in 7 Days (Level 2)

For simulation and workbook tests: one clock, real workbooks. Day 1 is the free Level 2 test, 20 tasks in 25 minutes across two workbooks. Days 2–6 practice lookups between sheets, SUMIFS and COUNTIFS grids, list cleanup, highlight rules and PivotTable questions. Day 7: retake it against our 80% pass line.

  • 7 days
  • 15 graded exercises
  • Day 1 and Day 7: Level 2 test, 25 min
  • Days 2–6: 16–30 min a day
  • 2 exercises use functions that Excel 2019 and older lack
  • Free, no sign-up
Start Day 1: take the Level 2 test

Free, no sign-up. Progress stays in this browser.

  1. T Day 1: Test day
  2. 2 Day 2: Joins and flags: other sheets, IF with AND, INDEX/MATCH
  3. 3 Day 3: Lookups that hold up: bands, Not found, COUNTIFS
  4. 4 Day 4: Summary grids and clean lists: SUMIFS, TRIM, UNIQUE
  5. 5 Day 5: Rules and pivots: overdue flags, series, Count vs Sum
  6. 6 Day 6: SUMPRODUCT, text dates and FILTER
  7. T Day 7: Test day

T: test day

Finish line

Level 2 test · 20 tasks · 25 min · our pass line is 80%

Each attempt draws its tasks at random, with new numbers, so some tasks can come up again; Levels 2 and 3 also draw their workbooks and projects at random.

No program can promise a pass: employers set their own pass marks and rarely publish them. Our bands and pass lines are our own cutoffs.

Is this for you?

Who it’s for

  • Candidates for analyst, operations, finance and sales roles facing an intermediate Excel test
  • Learners who scored 70% or more on the Level 1 test

You’ll be able to

  • Lookups between sheets with VLOOKUP and INDEX/MATCH, price bands and Not found instead of #N/A
  • Summary grids with SUMIFS and COUNTIFS, AND rules and a SUMPRODUCT weighted total
  • Clean lists: TRIM and PROPER, distinct customers with UNIQUE, text dates turned into dates, FILTER
  • Highlight-rule formulas, chart series and a PivotTable that counts instead of sums

Not covered yet

  • Named ranges: one Level 2 question; the plan practices $ references instead
  • A specific employer's questions: test vendors keep their question banks private
  • Power Query, macros and VBA
  • Building PivotTables and charts by hand: the practice grid asks about pictured reports instead

Day by day

7 days, 15 graded exercises. Minutes are estimates for one attempt; nothing locks, so go at your own pace.

✓ done · ◐ started · ○ to do

  1. Day 1

    Baseline: take the Level 2 test

    Test day · 25 min

    Take the free Level 2 test once, without preparing. Its percentage and five sub-scores are your Day 1 baseline.

    • Take the Level 2 test · 20 tasks · 25 min

      →
    • What a simulation test looks like

      Reading, optional · 6 min

  2. Day 2

    Joins and flags: other sheets, IF with AND, INDEX/MATCH

    16 min

    Most Level 2 workbooks join two tables: pull a value from another sheet, flag rows with IF and AND, and meet INDEX and MATCH.

    • Look up a customer tier from another sheet

      Beginner · 5 min

    • Bonus eligibility with IF and AND

      Beginner · 5 min

    • INDEX and MATCH exact lookup

      Intermediate · 6 min

  3. Day 3

    Lookups that hold up: bands, Not found, COUNTIFS

    21 min

    Approximate-match bands, Not found instead of #N/A, and a COUNTIFS grid by region and month.

    • Shipping cost bands with approximate VLOOKUP

      Intermediate · 7 min

    • Show "Not found" instead of #N/A

      Intermediate · 7 min

    • Orders per region and month with COUNTIFS

      Intermediate · 7 min

  4. Day 4

    Summary grids and clean lists: SUMIFS, TRIM, UNIQUE

    21 min

    Total by two conditions with SUMIFS, then clean padded names and list each customer once, as Level 2's data tasks ask.

    • Sales by region and product with SUMIFS

      Intermediate · 7 min

    • Clean padded, lower-case names with TRIM and PROPER

      Intermediate · 6 min

    • List unique customers (UNIQUE) — remove duplicates

      Intermediate · 8 minExcel 365

  5. Day 5

    Rules and pivots: overdue flags, series, Count vs Sum

    27 min

    The formula behind an overdue highlight, chart series read both ways, and a PivotTable that counts when it should sum.

    • Highlight overdue invoices (conditional formatting)

      Intermediate · 8 min

    • Series or categories? Read a chart both ways and flip its table

      Intermediate · 7 min

    • Fix a PivotTable that counts instead of sums

      Intermediate · 12 min

  6. Day 6

    SUMPRODUCT, text dates and FILTER

    30 min

    The three heaviest steps: a weighted average with SUMPRODUCT, text turned into real dates, and a live FILTER of large orders.

    • Weighted average price with SUMPRODUCT

      Expert · 8 min

    • Turn text dates into real dates and group by month

      Expert · 12 min

    • Orders over $1,000 in West with FILTER

      Expert · 10 minExcel 365

  7. Day 7

    Retake Level 2 and compare

    Test day · 25 min

    Take the Level 2 test again. It may draw other workbook families than on Day 1, so compare the sub-scores, not single tasks.

    • Retake the Level 2 test · 20 tasks · 25 min

      →
    • How we grade the test

      Reading, optional · 5 min

Since Day 1

Your weak-spot plan

Pro · Coming soon

The plan above is the same for everyone at this level. When Pro opens, the weak-spot plan will rebuild Days 2–6 from your own sub-scores and the tasks you missed: more practice where you scored lowest, none on what you already do well. Pro is not on sale yet, and nothing on this page needs it.

See what Pro will include

Sample

Questions about this plan

What does the Level 2 test look like?

20 tasks in 25 minutes on one clock, in two workbooks drawn from four families: sales, inventory, HR and expenses. 17 tasks are hands-on and 3 are multiple choice. The report shows your percentage against our 80% pass line and five sub-scores.

Do I need Excel 365 for the Level 2 plan?

Two exercises use newer functions, UNIQUE and FILTER, which need Excel 2021 or later, or Microsoft 365. The practice grid runs them in your browser; Excel 2019 and older do not have them.

Other levels

  • Level 1 plan: Beginner

    Seven days to get ready for a basic Excel test: the free 15-question Level 1 test, 15 graded exercises (15 to 16 minutes a day) and a Day 7 retake.

  • Level 3 plan: Expert

    A 7-day plan for an advanced Excel test: the free 50-minute Level 3 project test, 15 exercises on pivots, two-key lookups and validation, then a retake.

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.