---
title: "AVERAGE practice: 3 exercises with answers | ExcelSavvy"
description: "Practice AVERAGE in Excel across three lessons: find a mean, see how blank cells are skipped, and round it with ROUND. Checked in a live spreadsheet."
canonical_url: "https://excelsavvy.com/practice/average"
meta:
  "og:description": "Practice AVERAGE in Excel across three lessons: find a mean, see how blank cells are skipped, and round it with ROUND. Checked in a live spreadsheet."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~QVZFUkFHRSBwcmFjdGljZTogMyBleGVyY2lzZXMgd2l0aCBhbnN3ZXJz%2Cdescription_~UHJhY3RpY2UgQVZFUkFHRSBpbiBFeGNlbCBhY3Jvc3MgdGhyZWUgbGVzc29uczogZmluZCBhIG1lYW4sIHNlZSBob3cgYmxhbmsgY2VsbHMgYXJlIHNraXBwZWQsIGFuZCByb3VuZCBpdCB3aXRoIFJPVU5ELiBDaGVja2VkIGluIGEgbGl2ZSBzcHJlYWRzaGVldC4%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiU3R1ZGVudCIsIlNjb3JlIl19LHsibiI6MiwiY2VsbHMiOlsiQW5uYSIsIjcyIl19LHsibiI6MywiY2VsbHMiOlsiQmVuIiwiODUiXX0seyJuIjo0LCJjZWxscyI6WyJDYXJhIiwiOTAiXX0seyJuIjo1LCJjZWxscyI6WyJEYW4iLCI2NCJdfSx7Im4iOjcsImNlbGxzIjpbIiIsIiJdfV0sInRhcmdldCI6WzUsMV19fQ%2Cp_Ii9wcmFjdGljZS9hdmVyYWdlIg%2Cs_POf-Dx8rUp4KZXij.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "AVERAGE practice: 3 exercises with answers | ExcelSavvy"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~QVZFUkFHRSBwcmFjdGljZTogMyBleGVyY2lzZXMgd2l0aCBhbnN3ZXJz%2Cdescription_~UHJhY3RpY2UgQVZFUkFHRSBpbiBFeGNlbCBhY3Jvc3MgdGhyZWUgbGVzc29uczogZmluZCBhIG1lYW4sIHNlZSBob3cgYmxhbmsgY2VsbHMgYXJlIHNraXBwZWQsIGFuZCByb3VuZCBpdCB3aXRoIFJPVU5ELiBDaGVja2VkIGluIGEgbGl2ZSBzcHJlYWRzaGVldC4%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiU3R1ZGVudCIsIlNjb3JlIl19LHsibiI6MiwiY2VsbHMiOlsiQW5uYSIsIjcyIl19LHsibiI6MywiY2VsbHMiOlsiQmVuIiwiODUiXX0seyJuIjo0LCJjZWxscyI6WyJDYXJhIiwiOTAiXX0seyJuIjo1LCJjZWxscyI6WyJEYW4iLCI2NCJdfSx7Im4iOjcsImNlbGxzIjpbIiIsIiJdfV0sInRhcmdldCI6WzUsMV19fQ%2Cp_Ii9wcmFjdGljZS9hdmVyYWdlIg%2Cs_POf-Dx8rUp4KZXij.png"
---

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

# **AVERAGE practice exercises**

Find the mean of a range with AVERAGE, and see how it treats blank cells and text differently from zeros.

[**Start the first exercise**](https://excelsavvy.com/practice/average/average-function)

AVERAGE(ROUND(

## **How AVERAGE works**

AVERAGE finds the mean of your numbers: it adds them up and divides by how many there are. Give it a range, several ranges or single cells, the same way you would with SUM.

`**=AVERAGE(B2:B6)**` with scores of 70, 85, 90, 55 and 100 returns 80. If one of those cells is empty, Excel averages the numbers that are left instead of counting the gap as a zero. To tidy up a long result, put AVERAGE inside ROUND: `**=ROUND(AVERAGE(B2:B7),1)**` turns a daily visitor average of 124.1666… into 124.2.

AVERAGE skips blank cells and text, but a zero is a real number and pulls the result down. A day with no sales entered and a day with 0 sales give different averages, so decide which one you mean. To leave zeros out, use AVERAGEIF. One extreme value can also drag the mean away from what is typical, and MEDIAN is the better pick then. The exercises below cover a plain average, a range with a blank cell and rounding an average.

1. [**1****Find the average with AVERAGE**In B7, use AVERAGE to find the mean score in B2:B6.](https://excelsavvy.com/practice/average/average-function)
2. [**2****AVERAGE skips blank cells**Tuesday has no sales figure yet. In B7, use AVERAGE on B2:B6 to get the average of the days that do have one.](https://excelsavvy.com/practice/average/average-blank-cells)
3. [**3****Round an average with ROUND**In E1, work out the average number of visitors per day, rounded to one decimal. Put AVERAGE inside ROUND: ROUND(AVERAGE(B2:B7),1).](https://excelsavvy.com/practice/average/round-an-average)

## **Functions in this topic**

- [**AVERAGE**](https://excelsavvy.com/functions/average)
- [**ROUND**](https://excelsavvy.com/functions/round)

## **Read the guide**

- [**Free Excel course online: learn Excel from your first formula to job-ready**](https://excelsavvy.com/learn/how-to-learn-excel)
- [**How to make a graph in Excel: column, line and pie charts step by step**](https://excelsavvy.com/learn/excel-charts)

## **Questions**

<details>

<summary>

### How do I average numbers in Excel and ignore zeros?

</summary>

Use AVERAGEIF with a "not equal to zero" criterion: =AVERAGEIF(B2:B10,"&lt;&gt;0"). Only the cells that are not 0 go into the average, and empty cells are skipped as well. Without that criterion, every zero counts as a real value and lowers the result.

</details>

<details>

<summary>

### Why does AVERAGE return #DIV/0!?

</summary>

The range has no numbers in it, so Excel ends up dividing by zero. Check for empty cells, text, or numbers stored as text. If an empty result is fine for you, wrap the formula in IFERROR: =IFERROR(AVERAGE(B2:B10),"") shows a blank cell instead of the error.

</details>

<details>

<summary>

### How do I calculate a weighted average in Excel?

</summary>

Multiply each value by its weight, add the products and divide by the sum of the weights: =SUMPRODUCT(B2:B5,C2:C5)/SUM(C2:C5), with values in B and weights in C. A 10 with weight 2 and a 4 with weight 1 give (20+4)/3, which is 8. A plain AVERAGE would say 7.

</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/average#webpage","description":"Practice AVERAGE in Excel across three lessons: find a mean, see how blank cells are skipped, and round it with ROUND. Checked in a live spreadsheet.","name":"AVERAGE practice: 3 exercises with answers","url":"https://excelsavvy.com/practice/average","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/average#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/average#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/average#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/average#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/average"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/average#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":"AVERAGE practice: 3 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/average#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I average numbers in Excel and ignore zeros?","acceptedAnswer":{"@type":"Answer","text":"Use AVERAGEIF with a \"not equal to zero\" criterion: =AVERAGEIF(B2:B10,\"\u003C>0\"). Only the cells that are not 0 go into the average, and empty cells are skipped as well. Without that criterion, every zero counts as a real value and lowers the result."}},{"@id":"https://excelsavvy.com/practice/average#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Why does AVERAGE return #DIV/0!?","acceptedAnswer":{"@type":"Answer","text":"The range has no numbers in it, so Excel ends up dividing by zero. Check for empty cells, text, or numbers stored as text. If an empty result is fine for you, wrap the formula in IFERROR: =IFERROR(AVERAGE(B2:B10),\"\") shows a blank cell instead of the error."}},{"@id":"https://excelsavvy.com/practice/average#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I calculate a weighted average in Excel?","acceptedAnswer":{"@type":"Answer","text":"Multiply each value by its weight, add the products and divide by the sum of the weights: =SUMPRODUCT(B2:B5,C2:C5)/SUM(C2:C5), with values in B and weights in C. A 10 with weight 2 and a 4 with weight 1 give (20+4)/3, which is 8. A plain AVERAGE would say 7."}},{"@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.
