---
title: "Percentages in Excel: practice exercises | ExcelSavvy"
description: "Practice percentage formulas in a live spreadsheet. Percent change, markup, discount, VAT both ways and profit margin, checked as you type."
canonical_url: "https://excelsavvy.com/practice/percentages"
meta:
  "og:description": "Practice percentage formulas in a live spreadsheet. Percent change, markup, discount, VAT both ways and profit margin, checked as you type."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~UGVyY2VudGFnZXMgaW4gRXhjZWw6IHByYWN0aWNlIGV4ZXJjaXNlcw%2Cdescription_~UHJhY3RpY2UgcGVyY2VudGFnZSBmb3JtdWxhcyBpbiBhIGxpdmUgc3ByZWFkc2hlZXQuIFBlcmNlbnQgY2hhbmdlLCBtYXJrdXAsIGRpc2NvdW50LCBWQVQgYm90aCB3YXlzIGFuZCBwcm9maXQgbWFyZ2luLCBjaGVja2VkIGFzIHlvdSB0eXBlLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRCJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJQcm9kdWN0IiwiMjAyMyIsIjIwMjQiLCJDaGFuZ2UiXX0seyJuIjoyLCJjZWxscyI6WyJDb2ZmZWUiLCIxMjAwIiwiMTUwMCIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIlRlYSIsIjgwMCIsIjcyMCIsIiJdfSx7Im4iOjQsImNlbGxzIjpbIkNvY29hIiwiNDUwIiwiNTQwIiwiIl19XSwidGFyZ2V0IjpbMSwzXX19%2Cp_Ii9wcmFjdGljZS9wZXJjZW50YWdlcyI%2Cs_-WHD04IpJhFiGvp9.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Percentages in Excel: practice exercises | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~UGVyY2VudGFnZXMgaW4gRXhjZWw6IHByYWN0aWNlIGV4ZXJjaXNlcw%2Cdescription_~UHJhY3RpY2UgcGVyY2VudGFnZSBmb3JtdWxhcyBpbiBhIGxpdmUgc3ByZWFkc2hlZXQuIFBlcmNlbnQgY2hhbmdlLCBtYXJrdXAsIGRpc2NvdW50LCBWQVQgYm90aCB3YXlzIGFuZCBwcm9maXQgbWFyZ2luLCBjaGVja2VkIGFzIHlvdSB0eXBlLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJDIiwiRCJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJQcm9kdWN0IiwiMjAyMyIsIjIwMjQiLCJDaGFuZ2UiXX0seyJuIjoyLCJjZWxscyI6WyJDb2ZmZWUiLCIxMjAwIiwiMTUwMCIsIiJdfSx7Im4iOjMsImNlbGxzIjpbIlRlYSIsIjgwMCIsIjcyMCIsIiJdfSx7Im4iOjQsImNlbGxzIjpbIkNvY29hIiwiNDUwIiwiNTQwIiwiIl19XSwidGFyZ2V0IjpbMSwzXX19%2Cp_Ii9wcmFjdGljZS9wZXJjZW50YWdlcyI%2Cs_-WHD04IpJhFiGvp9.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **Percentages practice exercises**

The percentage math that comes up in every office job and Excel test: change from last year, a markup, a discount, VAT added and taken out, and a profit margin.

[**Start the first exercise**](https://excelsavvy.com/practice/percentages/percent-change)

## **How percentage formulas work in Excel**

In Excel a percentage is just a decimal: 25% is 0.25. Format the cell as Percent to show it that way. Most percentage formulas are one of a few patterns. Change is (new - old) / old. A markup is cost \* (1 + markup). A discount is price \* (1 - discount). VAT is added by multiplying by 1 plus the rate.

`**=(C2-B2)/B2**` with sales of 400 last year and 500 this year returns 0.25, which shows as 25% once the cell is formatted as Percent. `**=B2*(1-C2)**` takes a 15% discount off a price of 80 and returns 68.

The common mistake is taking VAT out the wrong way. A price with 25% VAT is the net price times 1.25, so you remove VAT by dividing: `**=B2/(1+$F$1)**` turns 125 into 100. Subtracting 25% from 125 gives 93.75, which is wrong. Also keep markup and margin apart: markup is profit divided by cost, margin is profit divided by price. The exercises below cover percent change, markup, discount, VAT added and removed, the VAT amount and profit margin.

1. [**1****Percent change from last year**In D2, work out the change in coffee sales from 2023 to 2024 as a decimal: the difference divided by the 2023 figure, (C2-B2)/B2.](https://excelsavvy.com/practice/percentages/percent-change)
2. [**2****Add a markup to a cost price****Premium**In D2, work out the selling price of the mug: the cost in B2 plus the markup in C2, which is a percentage of the cost. Use B2\*(1+C2).](https://excelsavvy.com/practice/percentages/add-percentage-markup)
3. [**3****Sale price after a discount****Premium**In D2, work out the sale price of the jacket: the price in B2 less the discount in C2, B2\*(1-C2).](https://excelsavvy.com/practice/percentages/price-after-discount)
4. [**4****Find the price before VAT****Premium**The prices in column B include 25% VAT. In C2, work out the printer's price before VAT: divide by 1 plus the rate in F1, B2/(1+$F$1).](https://excelsavvy.com/practice/percentages/price-before-vat)
5. [**5****Add VAT to a price****Premium**The prices in column B are before VAT. In C2, work out the printer's price with 25% VAT: multiply by 1 plus the rate in F1, B2\*(1+$F$1).](https://excelsavvy.com/practice/percentages/add-vat)
6. [**6****Find the VAT in a price that includes it****Premium**The prices in column B include 25% VAT. In C2, work out how much of the printer's price is VAT: the price minus the price before VAT, B2-B2/(1+$F$1).](https://excelsavvy.com/practice/percentages/vat-in-price)
7. [**7****Profit margin from price and cost****Premium**In D2, work out the profit margin of the mug: the profit, B2-C2, as a share of the price in B2. Use (B2-C2)/B2.](https://excelsavvy.com/practice/percentages/profit-margin)

## **Read the guide**

- [**How to make a graph in Excel: column, line and pie charts step by step**](https://excelsavvy.com/learn/excel-charts)
- [**How to calculate percentages in Excel: percent of a number, change, discount and VAT**](https://excelsavvy.com/learn/calculate-percentage-excel)
- [**Excel finance data: free practice file with tasks and answers**](https://excelsavvy.com/learn/excel-finance-practice-data)

## **Questions**

<details>

<summary>

### How do I calculate a percentage of a number in Excel?

</summary>

Multiply the number by the percentage: =B2\*15% or =B2\*0.15 gives 15% of the value in B2. If the percentage sits in its own cell, say C2, use =B2\*C2. To get a percentage on top of the number, as with a price increase, multiply by one plus the percentage instead.

</details>

<details>

<summary>

### How do I calculate each row's percent of the total?

</summary>

Divide each value by the total and lock the total with dollar signs: =B2/SUM($B$2:$B$10), then fill down and format the column as Percent. The locked range stays put while B2 moves. If you don't lock it, the range slips down and the percentages turn wrong.

</details>

<details>

<summary>

### Why does Excel show 0.25 instead of 25%?

</summary>

The cell is formatted as a number, not as a percentage. Select it and click the % button on the Home tab, or press Ctrl+Shift+%. The value stays 0.25, and only the display changes. Typing 25 into a cell that is already formatted as Percent gives you 25%.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/percentages#webpage","description":"Practice percentage formulas in a live spreadsheet. Percent change, markup, discount, VAT both ways and profit margin, checked as you type.","name":"Percentages in Excel: practice exercises","url":"https://excelsavvy.com/practice/percentages","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/percentages#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/percentages#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/percentages#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/percentages#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/percentages"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/percentages#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"Percentages in Excel: practice exercises","position":3}]},{"@id":"https://excelsavvy.com/practice/percentages#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I calculate a percentage of a number in Excel?","acceptedAnswer":{"@type":"Answer","text":"Multiply the number by the percentage: =B2*15% or =B2*0.15 gives 15% of the value in B2. If the percentage sits in its own cell, say C2, use =B2*C2. To get a percentage on top of the number, as with a price increase, multiply by one plus the percentage instead."}},{"@id":"https://excelsavvy.com/practice/percentages#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"How do I calculate each row's percent of the total?","acceptedAnswer":{"@type":"Answer","text":"Divide each value by the total and lock the total with dollar signs: =B2/SUM($B$2:$B$10), then fill down and format the column as Percent. The locked range stays put while B2 moves. If you don't lock it, the range slips down and the percentages turn wrong."}},{"@id":"https://excelsavvy.com/practice/percentages#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"Why does Excel show 0.25 instead of 25%?","acceptedAnswer":{"@type":"Answer","text":"The cell is formatted as a number, not as a percentage. Select it and click the % button on the Home tab, or press Ctrl+Shift+%. The value stays 0.25, and only the display changes. Typing 25 into a cell that is already formatted as Percent gives you 25%."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
