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

Prepare for a Beginner Excel Test in 7 Days (Level 1)

For screening tests: short tasks against a clock. Day 1 is the free Level 1 test, 15 tasks with a 90-second limit each. Days 2–6 practice totals and counts, $ references, IF and SUMIF, number formats and the right chart, three exercises a day. Day 7: retake it and compare.

  • 7 days
  • 15 graded exercises
  • Day 1 and Day 7: Level 1 test, 12 min
  • Days 2–6: 15–16 min a day
  • Free, no sign-up
Start Day 1: take the Level 1 test

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

  1. T Day 1: Test day
  2. 2 Day 2: Averages, totals across sheets, text pieces
  3. 3 Day 3: Lock a cell: a tax rate, shares, counts per status
  4. 4 Day 4: Count and total: COUNT, SUMIF, SUBTOTAL on a filter
  5. 5 Day 5: Number formats, a frozen header, the right chart
  6. 6 Day 6: IF, merged titles, a chart's rows and columns
  7. T Day 7: Test day

T: test day

Finish line

Level 1 test · 15 tasks · about 12 min · a band from Needs practice to Expert

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 office, admin and entry-level roles facing a basic Excel screening
  • Anyone unsure of their level: the Level 1 test takes about 12 minutes

You’ll be able to

  • Totals, averages and counts, including COUNTIF and SUMIF by condition
  • $ references that copy correctly, and shares of a total formatted as %
  • IF decisions, number formats, frozen headers, merged titles and the right chart type

Not covered yet

  • VLOOKUP: Level 1 does not ask for it; the Level 2 plan starts with it
  • 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 1 test

    Test day · 12 min

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

    • Take the Level 1 test · 15 tasks · 12 min

      →
    • What a screening test looks like

      Reading, optional · 5 min

  2. Day 2

    Averages, totals across sheets, text pieces

    15 min

    Warm up on the formulas Level 1 asks most: AVERAGE, MIN and MAX, a total across three sheets, and cutting a code into parts.

    • AVERAGE, MIN and MAX of exam scores

      Beginner · 4 min

    • Total across three regional sheets

      Beginner · 5 min

    • Extract category, year and serial from SKU

      Beginner · 6 min

  3. Day 3

    Lock a cell: a tax rate, shares, counts per status

    15 min

    The $ sign keeps a reference fixed when you copy a formula; you need it for shares of a total and for COUNTIF ranges.

    • Apply one tax rate to every line ($ reference)

      Beginner · 5 min

    • Share of total per region, formatted as %

      Beginner · 5 min

    • Orders per status with COUNTIF

      Beginner · 5 min

  4. Day 4

    Count and total: COUNT, SUMIF, SUBTOTAL on a filter

    15 min

    Count numbers, names and blanks, total by region with SUMIF, and count only the rows a filter shows.

    • Count orders, names and blanks (COUNT, COUNTA, COUNTBLANK)

      Beginner · 4 min

    • Sales by region with SUMIF

      Beginner · 5 min

    • Filter one region and count visible rows with SUBTOTAL

      Beginner · 6 min

  5. Day 5

    Number formats, a frozen header, the right chart

    16 min

    Level 1 asks about formats and screens as often as about formulas: currency and dates, a frozen header row, and which chart fits a question.

    • Apply currency and date formats

      Beginner · 4 min

    • Freeze the header row of a long export

      Beginner · 3 min

    • Pick the right chart for each question

      Beginner · 9 min

  6. Day 6

    IF, merged titles, a chart's rows and columns

    15 min

    A first decision with IF, a merged and centered title, then the Switch Row/Column question, the one intermediate step of this plan.

    • Pass or Fail with IF

      Beginner · 4 min

    • Merge and center the title; wrap header text

      Beginner · 4 min

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

      Intermediate · 7 min

  7. Day 7

    Retake Level 1 and compare

    Test day · 12 min

    Take the Level 1 test again. Each attempt draws new tasks, so compare the sub-scores, not single answers.

    • Retake the Level 1 test · 15 tasks · 12 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 1 test look like?

15 short tasks, 8 in a live grid and 7 multiple choice, each with a 90-second clock and no going back. It takes about 12 minutes and gives a band from Needs practice to Expert, plus five sub-scores.

When should I switch to the Level 2 plan?

When your Day 1 or Day 7 score is 70% or more. Level 2 adds lookups between sheets, list cleanup and totals by two conditions, which most intermediate hiring tests ask for.

Other levels

  • 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.

  • 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.