Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 1/7

AVERAGE

Exercise 1 of 3

In F2, work out the average score of the class.

About this lesson

AVERAGE returns the mean of a range: the total divided by how many numbers there are.

In this lesson

  1. In F2, work out the average score of the class.
  2. In F2, work out the average of the first four students only.
  3. B1 is 10, B2 is empty and B3 is 20. What does =AVERAGE(B1:B3) give?

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in F2 and press Enter to check.