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 3 plan · free

Prepare for an Advanced Excel Test in 7 Days (Level 3)

For project exams: five workbooks, one 50-minute clock, a 1–1000 score. Day 1 is the free Level 3 test, 25 tasks. Days 2–6 practice the rule formulas behind highlights and input checks, pivot-style summaries, two-key lookups, cleanup and a combo chart. Day 7: retake it against our 700 pass mark.

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

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

  1. T Day 1: Test day
  2. 2 Day 2: Formats and rule formulas: highlights, input checks
  3. 3 Day 3: Ordered rules, working days, clean names
  4. 4 Day 4: Pivot-style tables and duplicates
  5. 5 Day 5: PivotTable fields and two-key lookups
  6. 6 Day 6: Ranked reports, text dates and a combo chart
  7. T Day 7: Test day

T: test day

Finish line

Level 3 test · 25 tasks · 50 min · 700 of 1000 to pass, a linear estimate

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

  • Analysts and candidates facing an advanced, MOS-style project exam or a long workbook test
  • Learners who passed Level 2 or do well on its summaries and lookups

You’ll be able to

  • The TRUE/FALSE formulas behind conditional formatting and data validation rules
  • Pivot-style summaries with SUMIFS and GROUPBY, % of grand total and PivotTable settings
  • Two-key and two-way lookups, ordered rules, working days and text dates
  • A revenue and margin combo chart read on two axes

Not covered yet

  • Custom number-format codes (K and M suffixes, [h]:mm, signed changes): Day 2 covers Format Cells, but no exercise teaches the codes yet
  • PMT, NPER, Goal Seek and Scenario Manager: about 2 of 25 tasks in a typical attempt, no exercise yet
  • 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 3 test

    Test day · 50 min

    Take the free Level 3 test once, without preparing. Its 1–1000 score and five sub-scores are your Day 1 baseline.

    • Take the Level 3 test · 25 tasks · 50 min

      →
    • What a project exam looks like

      Reading, optional · 6 min

  2. Day 2

    Formats and rule formulas: highlights, input checks

    19 min

    Format Cells first, then the TRUE/FALSE formulas behind a highlight rule and an input rule, the most frequent Level 3 task type.

    • Apply currency and date formats

      Beginner · 4 min

    • Highlight overdue invoices (conditional formatting)

      Intermediate · 8 min

    • Restrict quantity to whole numbers 1–100

      Intermediate · 7 min

  3. Day 3

    Ordered rules, working days, clean names

    21 min

    Tiers that must be tested in the right order, working days between dates, and names cleaned with TRIM and PROPER.

    • Commission tiers with nested IF, IFS or a lookup

      Intermediate · 8 min

    • Working days to resolve tickets (NETWORKDAYS)

      Intermediate · 7 min

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

      Intermediate · 6 min

  4. Day 4

    Pivot-style tables and duplicates

    25 min

    Rebuild a PivotTable with SUMIFS by category and month, show shares of the grand total, and list duplicates once with UNIQUE.

    • Pivot without a pivot: revenue by category and month with SUMIFS

      Intermediate · 10 min

    • Share of revenue by channel: % of Grand Total with formulas

      Intermediate · 7 min

    • List unique customers (UNIQUE) — remove duplicates

      Intermediate · 8 minExcel 365

  5. Day 5

    PivotTable fields and two-key lookups

    30 min

    Fix a PivotTable that counts instead of sums, then look up on two keys and across two axes.

    • Fix a PivotTable that counts instead of sums

      Intermediate · 12 min

    • Two-criteria lookup (product and region)

      Expert · 10 min

    • Two-way lookup in a matrix

      Expert · 8 min

  6. Day 6

    Ranked reports, text dates and a combo chart

    30 min

    A GROUPBY report sorted largest first, text dates in three shapes, and revenue with margin % on one chart.

    • Tickets per agent: GROUPBY with a filter, no total, largest first

      Expert · 9 minExcel 365

    • Turn text dates into real dates and group by month

      Expert · 12 min

    • Revenue and margin % in one readable chart

      Expert · 9 min

  7. Day 7

    Retake Level 3 and compare

    Test day · 50 min

    Take the Level 3 test again. It draws 5 of its 10 projects at random, so compare the sub-scores, not single tasks.

    • Retake the Level 3 test · 25 tasks · 50 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 3 test look like?

Five projects drawn at random from ten, 25 tasks in 50 minutes on one clock. You can move freely inside a project and mark tasks for review. The score is a linear 1–1000 estimate; our pass mark is 700.

Does the Level 3 plan cover everything the test can ask?

No. Loan functions (PMT, NPER), Goal Seek, Scenario Manager and custom number-format codes have no exercise yet; together they are about 5 of the 25 tasks in a typical attempt. The rest of what Level 3 draws has an exercise in this plan or among its practice links.

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 2 plan: Intermediate

    A 7-day plan for an intermediate Excel test: the free 25-minute Level 2 test, 15 exercises on SUMIFS, lookups and data cleanup, and a Day 7 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.