AVERAGE practice exercises
5 graded problems with realistic data, all easy.
Finds the arithmetic mean of a set of numbers, ignoring text and blanks. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the AVERAGE guide first: syntax, a worked example and the mistakes people make.
In this set
- Average your quiz scores
- Average your commute time
- Average the week's high temps
- Average the food truck's rating
- Average meeting attendance
The exercises
Your study group compared quiz scores. Find the group's average.
| A | B | |
|---|---|---|
| 1 | Student | Score |
| 2 | Lea | 88 |
| 3 | Noah | 76 |
| 4 | Ines | 95 |
| 5 | Marco | 60 |
| 6 | Average | ? |
Enter a formula in B6.
Show a hint
AVERAGE(range) does the sum-and-divide for you: =AVERAGE(B2:B5).
Averages summarize a whole dataset in one number. It's the first thing a professor or teammate will ask for.
You tracked your commute time in minutes for five days. Find the average.
| A | B | |
|---|---|---|
| 1 | Day | Minutes |
| 2 | Mon | 22 |
| 3 | Tue | 35 |
| 4 | Wed | 18 |
| 5 | Thu | 40 |
| 6 | Fri | 25 |
| 7 | Average | ? |
Enter a formula in B7.
Show a hint
=AVERAGE(B2:B6) across the five days.
Averaging a week of measurements (commute time, spend, anything recurring) is a daily-life use of this formula.
Your class recorded the daily high temperature (°F) during a six-day field trip. Find the average.
| A | B | |
|---|---|---|
| 1 | Day | High |
| 2 | Mon | 68 |
| 3 | Tue | 72 |
| 4 | Wed | 65 |
| 5 | Thu | 70 |
| 6 | Fri | 75 |
| 7 | Sat | 70 |
| 8 | Average | ? |
Enter a formula in B8.
Show a hint
One extra day in the range: =AVERAGE(B2:B7).
Averaging a series of readings over time is how AVERAGE shows up in science and reporting contexts alike.
A campus food truck collected five customer ratings out of 5 stars (row 2 just names the truck). One reviewer left a 0 after a mix-up. Find the average rating.
| A | B | |
|---|---|---|
| 1 | Truck | Taco Spot |
| 2 | Reviewer | Stars |
| 3 | R1 | 5 |
| 4 | R2 | 4 |
| 5 | R3 | 0 |
| 6 | R4 | 5 |
| 7 | R5 | 4 |
| 8 | Average | ? |
Enter a formula in B8.
Show a hint
The 0 is a real rating, not a blank. It still counts toward both the sum and the count of 5: =AVERAGE(B3:B7).
A stray 0 changes the result a lot. This is the "zero counts, blank doesn't" distinction that trips people up most with AVERAGE.
The photography club tracked attendance across four meetings this month (row 2 is just the header). Find the average number of attendees.
| A | B | |
|---|---|---|
| 1 | Club | Photography |
| 2 | Meeting | Attendees |
| 3 | 1 | 14 |
| 4 | 2 | 9 |
| 5 | 3 | 17 |
| 6 | 4 | 12 |
| 7 | Average | ? |
Enter a formula in B7.
Show a hint
=AVERAGE(B3:B6).
Average attendance is exactly the kind of one-number summary a club officer or teacher needs at a glance.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the AVERAGE exercises →