---
title: "Excel exercises for school: math, social studies and business | PracticeExcel"
description: "Free Excel exercises for the classroom, checked as students type. For math, social studies and business classes, in a spreadsheet in the browser."
canonical_url: "https://practiceexcelonline.com/practice/schools"
meta:
  "og:description": "Free Excel exercises for the classroom, checked as students type. For math, social studies and business classes, in a spreadsheet in the browser."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgZXhlcmNpc2VzIGZvciBzY2hvb2w6IG1hdGgsIHNvY2lhbCBzdHVkaWVzIGFuZCBidXNpbmVzcw%2Cdescription_~RnJlZSBFeGNlbCBleGVyY2lzZXMgZm9yIHRoZSBjbGFzc3Jvb20sIGNoZWNrZWQgYXMgc3R1ZGVudHMgdHlwZS4gRm9yIG1hdGgsIHNvY2lhbCBzdHVkaWVzIGFuZCBidXNpbmVzcyBjbGFzc2VzLCBpbiBhIHNwcmVhZHNoZWV0IGluIHRoZSBicm93c2VyLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cp_Ii9wcmFjdGljZS9zY2hvb2xzIg%2Cs_UIWgXKX4xrj1ooOx.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Excel exercises for school: math, social studies and business | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_~RXhjZWwgZXhlcmNpc2VzIGZvciBzY2hvb2w6IG1hdGgsIHNvY2lhbCBzdHVkaWVzIGFuZCBidXNpbmVzcw%2Cdescription_~RnJlZSBFeGNlbCBleGVyY2lzZXMgZm9yIHRoZSBjbGFzc3Jvb20sIGNoZWNrZWQgYXMgc3R1ZGVudHMgdHlwZS4gRm9yIG1hdGgsIHNvY2lhbCBzdHVkaWVzIGFuZCBidXNpbmVzcyBjbGFzc2VzLCBpbiBhIHNwcmVhZHNoZWV0IGluIHRoZSBicm93c2VyLg%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cp_Ii9wcmFjdGljZS9zY2hvb2xzIg%2Cs_UIWgXKX4xrj1ooOx.png"
---

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

# **Excel exercises for school**

Students write the formulas themselves in a spreadsheet in the browser and find out right away whether they are right, and what is wrong if they aren't. Students can start without an account.

AVERAGEIF%

Here are the exercises sorted by subject. Each topic starts with a free exercise and gets harder as it goes.

## **Math**

Formulas, percentages, averages, rounding, and MIN and MAX, for spreadsheet work in middle school and high school math.

- [**First formulas**4 exercises](https://practiceexcelonline.com/practice/first-formulas)
- [**SUM**4 exercises](https://practiceexcelonline.com/practice/sum)
- [**AVERAGE**3 exercises](https://practiceexcelonline.com/practice/average)
- [**MIN, MAX and LARGE**4 exercises](https://practiceexcelonline.com/practice/minmax)
- [**ROUND, ROUNDUP and ROUNDDOWN**4 exercises](https://practiceexcelonline.com/practice/round)
- [**Percentages**7 exercises](https://practiceexcelonline.com/practice/percentages)
- [**Relative and absolute references**3 exercises](https://practiceexcelonline.com/practice/absolute-references)

## **Social studies**

Percentages, percent change, averages and counting with COUNTIF, for working with real statistics.

- [**Percentages**7 exercises](https://practiceexcelonline.com/practice/percentages)
- [**AVERAGE**3 exercises](https://practiceexcelonline.com/practice/average)
- [**COUNT, COUNTA and COUNTBLANK**3 exercises](https://practiceexcelonline.com/practice/count)
- [**COUNTIF**5 exercises](https://practiceexcelonline.com/practice/countif)
- [**IF**6 exercises](https://practiceexcelonline.com/practice/if)

## **Business and finance**

Sales tax, margins, budgets, conditional sums and lookups, the way they are used at work.

- [**Percentages**7 exercises](https://practiceexcelonline.com/practice/percentages)
- [**Budget**5 exercises](https://practiceexcelonline.com/practice/budget-in-excel)
- [**SUMIF**5 exercises](https://practiceexcelonline.com/practice/sumif)
- [**SUMIFS**4 exercises](https://practiceexcelonline.com/practice/sumifs)
- [**VLOOKUP**5 exercises](https://practiceexcelonline.com/practice/vlookup)
- [**XLOOKUP**5 exercises](https://practiceexcelonline.com/practice/xlookup)
- [**Summary tables**6 exercises](https://practiceexcelonline.com/practice/summary-tables)
- [**Loans: PMT and NPER**3 exercises](https://practiceexcelonline.com/practice/loan-payments)

## **How to use the exercises in class**

Give students the link to a topic and let them work at their own pace. Each exercise takes a few minutes, and the spreadsheet checks the answer, so you don't grade by hand. If a student gets stuck, the spreadsheet can give a hint, and afterward the student can see the solution.

The exercises run in the browser on computers and Chromebooks, and students don't need to install Excel. What they learn works afterward in Excel and in Google Sheets.

## **Use it with the whole class**

Email us if you'd like to use PracticeExcel with a whole class or a whole school, and we'll work something out.

Email [hey@practiceexcelonline.com](mailto:hey@practiceexcelonline.com)

## **Why write the formulas yourself?**

When students watch a video and copy a formula, they get a right answer today and no understanding tomorrow. When they have to write the formula and are told what is wrong, they learn why it works. That is what lets them use it next time on a new problem.

## **Try the exercises yourself first**

It takes a couple of minutes, and you don't need an account.

[**Try the first exercise**](https://practiceexcelonline.com/practice/the-grid/welcome)

```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/schools#webpage","@type":"WebPage","description":"Free Excel exercises for the classroom, checked as students type. For math, social studies and business classes, in a spreadsheet in the browser.","name":"Excel exercises for school: math, social studies and business","url":"https://practiceexcelonline.com/practice/schools","breadcrumb":{"@id":"https://practiceexcelonline.com/practice/schools#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/schools"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/schools#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":"Excel exercises for school: math, social studies and business","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.