---
title: "Percentages in Excel: practice exercises | PracticeExcel"
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://practiceexcelonline.com/practice/percentages"
locale: en
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://practiceexcelonline.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 | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.com/practice/percentages/percent-change)

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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.com/practice/percentages/profit-margin)

## **Read the guide**

- [**How to make a graph in Excel: column, line and pie charts step by step**](https://practiceexcelonline.com/learn/excel-charts)
- [**How to calculate percentages in Excel: percent of a number, change, discount and VAT**](https://practiceexcelonline.com/learn/calculate-percentage-excel)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.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://practiceexcelonline.com/practice/percentages","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/practice/percentages#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/percentages"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/percentages#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://practiceexcelonline.com/practice","position":2},{"@type":"ListItem","name":"Percentages in Excel: practice exercises","position":3}]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

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