Home › Practice questions › AVERAGE › Question 2

Excel AVERAGE Practice Question: Using AVERAGE, find each student's average marks across the three tests and…

By Rinkesh Shah, founder of Cellgrids.

The question

Using AVERAGE, find each student's average marks across the three tests and put them in E2 and E3.

The data

	A	B	C	D	E
1	Student	Test 1	Test 2	Test 3	Average
2	Anil	70	80	90	?
3	Bina	60	75	90	?

The yellow cells are where your answer goes.

Show answer

Expected results:

E2 = 80
E3 = 75

How it works

Explanation: AVERAGE works across a row too. Select the three test scores for each student.
Syntax: =AVERAGE(B2:D2)
Anil: (70 + 80 + 90) / 3 = 80. Bina: (60 + 75 + 90) / 3 = 75.

Try it yourself in the live sheet

Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.

Try this question in the live sheet →

AVERAGE syntax

=AVERAGE(number1, [number2], ...)

Finds the mean of a set of numbers. AVERAGE is used in financial models and engineering-style calculations where precise numeric work is needed. Full AVERAGE guide.