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.

Excel practice exercises, graded in your browser

69 graded exercises in 6 tracks. Each one opens a real spreadsheet with a realistic dataset, checks your result and your formula, and tells you exactly what to fix.

69 exercises, about 7 hours of practice. Free, no sign-up, nothing to install.

  • Programs
  • Excel Basics
  • Logic & Conditional Math
  • Lookups
  • Text & Dates
  • Data Cleaning & Dynamic Arrays
  • Pivots & Charts

Follow a program

Day-by-day plans built from these exercises: a 7-day plan for your test date, or a program for your job. Free, no sign-up.

All programs →
  • Prepare for your Excel test in 7 days

    Day 1: the free timed test at your level. Days 2–6: three graded exercises a day. Day 7: retake it and compare.

    7 days · 15–30 min a day

  • Excel for Data Analysts

    For analyst work and the Level 3 project test: summary grids, cleanup, expert lookups and pivot-style reports.

    12 days · 33 exercises · 17–31 min a day · Final test: Level 3

  • Excel for Administrative Assistants

    For office and admin work: tidy exports, counts, IF rules, lookups, due dates and a tracker that rejects bad input.

    11 days · 30 exercises · 15–22 min a day · Final test: Level 1

  • Excel for Sales and Marketing

    For sales and marketing ops: totals by region and rep, commission tiers, lookups, clean customer lists and live reports.

    10 days · 27 exercises · 16–28 min a day · Final test: Level 2

  • Excel for Accounting and Bookkeeping

    For AP/AR, bookkeeping and month-end work: tax lines, due dates, overdue invoices, SUMIFS by month and lookups.

    10 days · 27 exercises · 15–31 min a day · Final test: Level 2

  • Learn Excel From Scratch

    For complete beginners: from the first SUM to lookups, IF rules and a tidy tracker, in 14 short days of graded practice.

    14 days · 39 exercises · 15–21 min a day · Final test: Level 1

Excel Basics

SUM to sort and filter: the formulas and sheet skills every job expects on day one.

15 exercises, about 67 min

SUM, AVERAGE and COUNT

All 6 in this topic
  1. 01Total revenue with SUMBeginner~3 minBeginner, ~3 min
  2. 02AVERAGE, MIN and MAX of exam scoresBeginner~4 minBeginner, ~4 min
  3. 03Count orders, names and blanks (COUNT, COUNTA, COUNTBLANK)Beginner~4 minBeginner, ~4 min
  4. 04Row totals with the fill handleBeginner~4 minBeginner, ~4 min
  5. 05Total across three regional sheetsBeginner~5 minBeginner, ~5 min
  6. 06Top 3 and bottom 3 reps with LARGE and SMALLBeginner~5 minBeginner, ~5 min

Absolute references

All 2 in this topic
  1. 07Apply one tax rate to every line ($ reference)Beginner~5 minBeginner, ~5 min
  2. 08Price grid for quantities × discounts (mixed references)Beginner~7 minBeginner, ~7 min

Percentages

All 2 in this topic
  1. 09Share of total per region, formatted as %Beginner~5 minBeginner, ~5 min
  2. 10Year-over-year % changeBeginner~4 minBeginner, ~4 min

Freeze panes

All 1 in this topic
  1. 11Freeze the header row of a long exportBeginner~3 minBeginner, ~3 min

Merge and wrap

All 2 in this topic
  1. 12Merge and center the title; wrap header textBeginner~4 minBeginner, ~4 min
  2. 13Apply currency and date formatsBeginner~4 minBeginner, ~4 min

Sort and filter

All 2 in this topic
  1. 14Sort by Region, then Sales descendingBeginner~4 minBeginner, ~4 min
  2. 15Filter one region and count visible rows with SUBTOTALBeginner~6 minBeginner, ~6 min

Logic & Conditional Math

IF, AND, OR, COUNTIF, SUMIFS: decide and total by condition.

16 exercises, about 96 min

IF function

All 7 in this topic
  1. 16Pass or Fail with IFBeginner~4 minBeginner, ~4 min
  2. 17Bonus eligibility with IF and ANDBeginner~5 minBeginner, ~5 min
  3. 18Free-shipping flag with IF and ORBeginner~6 minBeginner, ~6 min
  4. 19Flag rows with missing dataIntermediate~5 minIntermediate, ~5 min
  5. 20Margin % without #DIV/0!Intermediate~6 minIntermediate, ~6 min
  6. 21Commission tiers with nested IF, IFS or a lookupIntermediate~8 minIntermediate, ~8 min
  7. 22Region names from codes with SWITCH or IFSExpert~8 minExpert, ~8 min

COUNTIF and COUNTIFS

All 4 in this topic
  1. 23Orders per status with COUNTIFBeginner~5 minBeginner, ~5 min
  2. 24Count .edu emails with a wildcardBeginner~4 minBeginner, ~4 min
  3. 25Orders per region and month with COUNTIFSIntermediate~7 minIntermediate, ~7 min
  4. 26Orders between two datesIntermediate~6 minIntermediate, ~6 min

SUMIF and SUMIFS

All 5 in this topic
  1. 27Sales by region with SUMIFBeginner~5 minBeginner, ~5 min
  2. 28Total of orders above $500Beginner~4 minBeginner, ~4 min
  3. 29Sales by region and product with SUMIFSIntermediate~7 minIntermediate, ~7 min
  4. 30Average and largest deal per rep (AVERAGEIFS, MAXIFS)Intermediate~8 minIntermediate, ~8 min
  5. 54Weighted average price with SUMPRODUCTExpert~8 minExpert, ~8 min

Lookups

VLOOKUP, XLOOKUP, INDEX and MATCH: pull values from other tables and sheets.

11 exercises, about 77 min

VLOOKUP

All 5 in this topic
  1. 31Pull the unit price with VLOOKUP (exact match)Beginner~5 minBeginner, ~5 min
  2. 32Look up a customer tier from another sheetBeginner~5 minBeginner, ~5 min
  3. 33Shipping cost bands with approximate VLOOKUPIntermediate~7 minIntermediate, ~7 min
  4. 34Show "Not found" instead of #N/AIntermediate~7 minIntermediate, ~7 min
  5. 35Pick the month column with MATCHIntermediate~7 minIntermediate, ~7 min

XLOOKUP

All 3 in this topic
  1. 36Replace VLOOKUP with XLOOKUPIntermediate~6 minIntermediate, ~6 min
  2. 37Look left: employee ID by emailExpert~6 minExpert, ~6 min
  3. 38Two-criteria lookup (product and region)Expert~10 minExpert, ~10 min

INDEX and MATCH

All 3 in this topic
  1. 39INDEX and MATCH exact lookupIntermediate~6 minIntermediate, ~6 min
  2. 40Two-way lookup in a matrixExpert~8 minExpert, ~8 min
  3. 41Last order date per customerExpert~10 minExpert, ~10 min

Text & Dates

Split, clean and join text; count days, deadlines and working days.

9 exercises, about 59 min

Text functions

All 5 in this topic
  1. 42Full name with CONCAT or &Beginner~4 minBeginner, ~4 min
  2. 43Extract category, year and serial from SKUBeginner~6 minBeginner, ~6 min
  3. 44Split email into user and domain (FIND/LEFT/RIGHT or TEXTBEFORE/TEXTAFTER)Intermediate~7 minIntermediate, ~7 min
  4. 45Clean padded, lower-case names with TRIM and PROPERIntermediate~6 minIntermediate, ~6 min
  5. 46Combine tags per product with TEXTJOINIntermediate~5 minIntermediate, ~5 min

Date functions

All 4 in this topic
  1. 47Days to deadline and tenure in years (TODAY, DATEDIF)Beginner~6 minBeginner, ~6 min
  2. 48Invoice due dates with EOMONTH and EDATEIntermediate~6 minIntermediate, ~6 min
  3. 49Working days to resolve tickets (NETWORKDAYS)Intermediate~7 minIntermediate, ~7 min
  4. 50Turn text dates into real dates and group by monthExpert~12 minExpert, ~12 min

Data Cleaning & Dynamic Arrays

UNIQUE, FILTER, SORTBY, conditional formatting and data validation.

7 exercises, about 56 min

Remove duplicates

All 1 in this topic
  1. 51List unique customers (UNIQUE) — remove duplicatesIntermediate~8 minIntermediate, ~8 min

FILTER, SORT and UNIQUE

All 2 in this topic
  1. 52Orders over $1,000 in West with FILTERExpert~10 minExpert, ~10 min
  2. 53Products ranked by sales with SORTBYExpert~8 minExpert, ~8 min

Conditional formatting

All 2 in this topic
  1. 55Highlight overdue invoices (conditional formatting)Intermediate~8 minIntermediate, ~8 min
  2. 56Highlight the top 10 % of salesIntermediate~8 minIntermediate, ~8 min

Drop-down lists

All 2 in this topic
  1. 57Drop-down list of regions (data validation)Intermediate~7 minIntermediate, ~7 min
  2. 58Restrict quantity to whole numbers 1–100Intermediate~7 minIntermediate, ~7 min

Pivots & Charts

Pivot-style summaries with SUMIFS and GROUPBY, PivotTable screens, and picking, reading and fixing charts.

11 exercises, about 91 min

Pivot tables

All 6 in this topic
  1. 59Pivot without a pivot: revenue by category and month with SUMIFSIntermediate~10 minIntermediate, ~10 min
  2. 60A pivot-style sales report by region with GROUPBYIntermediate~6 minIntermediate, ~6 min
  3. 61Tickets per agent: GROUPBY with a filter, no total, largest firstExpert~9 minExpert, ~9 min
  4. 62Share of revenue by channel: % of Grand Total with formulasIntermediate~7 minIntermediate, ~7 min
  5. 63Read a PivotTable report and check one of its cellsBeginner~8 minBeginner, ~8 min
  6. 64Fix a PivotTable that counts instead of sumsIntermediate~12 minIntermediate, ~12 min

Charts

All 5 in this topic
  1. 65Pick the right chart for each questionBeginner~9 minBeginner, ~9 min
  2. 66Read a clustered column chart of revenue by regionBeginner~6 minBeginner, ~6 min
  3. 67Spot a misleading chart axis and measure the real differenceIntermediate~8 minIntermediate, ~8 min
  4. 68Series or categories? Read a chart both ways and flip its tableIntermediate~7 minIntermediate, ~7 min
  5. 69Revenue and margin % in one readable chartExpert~9 minExpert, ~9 min