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. Pivots & Charts

Pivot Table Practice: Read, Filter and Rebuild a Pivot With Formulas

Build the summaries a PivotTable gives you with SUMIFS and GROUPBY, then answer questions about real PivotTable screens. The browser grid has no PivotTable button, so the pivot screens are pictures; every number you build is graded in the grid.

6 exercises, about 52 min

  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