Statistics › AVERAGE22 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeAVERAGE

AVERAGE: report card average

Mrs. Endah, the homeroom teacher of class 8B at a junior high school in Yogyakarta, is filling in mid-semester report cards. She needs each student's average across four subjects.

Task

Fill F2:F6 with each student's average score for Math, Science, Indonesian and English (columns B to E), using AVERAGE.

Cells to fillF2:F6

Required functionsAVERAGE

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
AVERAGE adds the numbers and divides by how many there are.
Hint 2
The range runs across the row: columns B to E on the same row, for example B2:E2 for Rina.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

F2:F6

=AVERAGE(B2:E2)

Write it in F2, then fill down to F6.

Explanation

=AVERAGE(B2:E2) works out (85 + 78 + 90 + 88) / 4 = 85.25 for Rina. It is safer than =(B2+C2+D2+E2)/4 because if a score is still missing (an empty cell), AVERAGE automatically divides by the number of scores present. Careful: a 0 is still counted, while an empty cell is ignored.

Starting worksheet: Sheet1
Row	A	B	C	D	E	F
1	Name	Math	Science	Indonesian	English	Average
2	Rina	85	78	90	88
3	Dimas	72	80	75	70
4	Ayu	90	92	88	95
5	Fajar	65	70	78	72
6	Nadia	88	84	80	91
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result