Excel practice · Basics

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

  1. Average your quiz scores
  2. Average your commute time
  3. Average the week's high temps
  4. Average the food truck's rating
  5. Average meeting attendance

The exercises

1. Average your quiz scores Easy

Your study group compared quiz scores. Find the group's average.

AB
1StudentScore
2Lea88
3Noah76
4Ines95
5Marco60
6Average?

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.

2. Average your commute time Easy

You tracked your commute time in minutes for five days. Find the average.

AB
1DayMinutes
2Mon22
3Tue35
4Wed18
5Thu40
6Fri25
7Average?

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.

3. Average the week's high temps Easy

Your class recorded the daily high temperature (°F) during a six-day field trip. Find the average.

AB
1DayHigh
2Mon68
3Tue72
4Wed65
5Thu70
6Fri75
7Sat70
8Average?

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.

4. Average the food truck's rating Easy

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.

AB
1TruckTaco Spot
2ReviewerStars
3R15
4R24
5R30
6R45
7R54
8Average?

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.

5. Average meeting attendance Easy

The photography club tracked attendance across four meetings this month (row 2 is just the header). Find the average number of attendees.

AB
1ClubPhotography
2MeetingAttendees
3114
429
5317
6412
7Average?

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 →

More basics practice

All Excel practice exercises · Excel test prep