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. /
  3. Percentages

Percent of total practice: each region's share of Q3 sales

  • Beginner
  • ~5 min
  • Percentages

The Orders sheet holds the raw Q3 2026 export (150 orders); the Summary sheet already totals it by sales region — 8 regions in B2:B9. The regional VP wants each region's share of company sales for the quarterly deck. Add the grand total in B10, compute each region's share in column C with one formula you can fill down, and show the shares as percentages with one decimal.

What you need to do

  1. 1On the Summary sheet, click B10 and write a SUM over B2:B9.
  2. 2Click C2 and divide the region's sales (B2) by the total (B10). Lock the total with $ signs — F4 (Windows) / ⌘T (Mac) — so it stays B10 when you fill down.
  3. 3Fill C2 down to C9. The eight shares should add up to 1 (100%).
  4. 4Select C2:C9 and apply a percentage format with one decimal place: Ctrl+Shift+% (Windows) or Control+Shift+% (Mac) gives 0 decimals, then click "Increase Decimal" once — or use Format Cells (Ctrl+1 / ⌘1) → Percentage → 1 decimal.

Answer cells

Feedback

Type your formula in the grid, press Enter, then Check. We grade the value in each answer cell and the formula behind it.

Tasks

  1. Not checkedIn B10, add up the sales of all 8 regions (B2:B9).
  2. Not checkedIn C2:C9, compute each region's share of the total: the region's sales divided by the grand total in B10, as one formula filled down.
  3. Not checkedFormat C2:C9 as a percentage with one decimal place (for example 23.4%).

Desktop recommended for spreadsheet tasks. The sheet scrolls inside this box.

StartInsertFormulasDataView
A1fxPreparing your workbook…
A
B
C
D
E
F
G
H
I
J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Sheet1

Enter your formula in the sheet, then check.

About this exercise

A 159-row dataset on 2 sheets, 2 answer cells, about 5 minutes. Graded in your browser: the value and the formula behind it, with feedback that names the fix.

How to solve it

  • B10=SUM(B2:B9)
  • C2=B2/$B$10

A percentage of total is simply the part divided by the whole, so =B2/$B$10 gives the Northeast share as a decimal such as 0.234. The $ signs lock the divisor on the total cell while the fill handle moves B2 to B3, B4 and so on. Applying the 0.0% number format multiplies the display by 100 and adds the sign — the stored value stays 0.234, which is why the shares still add up to exactly 1.

Pitfall 1: without the $ signs the divisor slides to B11, B12 … (empty cells) and every row from C3 down shows #DIV/0!. Pitfall 2: typing the total as a number (=B2/1234567) works until an order is added; dividing by a SUM cell or by SUM($B$2:$B$9) keeps the shares live. Pitfall 3: never multiply by 100 in the formula (=B2/$B$10*100) and then apply % — you get 2340.0%; the format already does the ×100. Alternatives: =B2/SUM($B$2:$B$9) needs no total row; in Excel 365, =B2:B9/SUM(B2:B9) in C2 spills all eight shares. Presentation: for a deck, round only in the display (0.0%), not with ROUND in the formula, so the shares keep summing to 100.0%; if rounded shares must sum to exactly 100.0%, adjust the largest region (the "largest remainder" convention).

Other ways that work

  • =B2/SUM($B$2:$B$9) — no total cell needed
  • =B2/B$10 — mixed reference; locking the row is enough when you only fill down
  • =B2:B9/SUM(B2:B9) in C2 — Excel 365 only, spills all shares

Common mistakes

Filling =B2/B10 down without $ signs: C3 becomes =B3/B11, which divides by an empty cell and shows #DIV/0!. Lock the divisor as $B$10.

How we grade

Any formula that produces the right result is accepted, unless the task names a function: then another function earns half credit. We compare values with a small tolerance and ignore case and spaces in text. A correct number typed by hand instead of a formula earns half credit. Multi-cell tasks earn full credit at 100% of cells, half credit from 50%. Where it matters, we also change an input cell on a copy of your sheet and check that your formula follows.

Answers computed with Excel 365 rules and checked in our grading engine on November 15, 2026. Author: GridBelt team.

In these programs

  • Excel test in 7 days, Level 1 planDay 3
  • Excel for Administrative AssistantsDay 4
  • Learn Excel From ScratchDay 6

Related exercises

  • Year-over-year % changeBeginner, ~4 min
  • Apply one tax rate to every line ($ reference)Beginner, ~5 min
  • Total across three regional sheetsBeginner, ~5 min
  • Apply currency and date formatsBeginner, ~4 min

Function reference

Official documentation

Next exercise

Year-over-year % change