How to find an Average in MS Excel

Finding an average is the act of adding the total marks or scores gained by the number of students in a class divided by the number of candidates. In this case, assuming the total number of students in a class is 20 and their scores are added, for example, 200, what will be the average score of the total number of students in that class?

Practical Approach:

• JOHN = 40

• ESTHER = 20

• JEANINE = 5

• RUDE = 50

• AKUA = 5

• ENDURANCE = 66

• JOE = 4

• JEAN = 10

The following are to be entered in the below cells respectively:

• B1 =40

• B2 = 20

• B3 = 5

• B4 =50

• B5 = 5

• B6 = 66

• B7 = 4

• B8 = 10

FUNCTION:

Supposing we want the answer to appear in CELL B9, follow the steps given:

1. Press the equal sign = 
2. Type Average
3. Open bracket
4. Type B1:B8
5. Close the bracket
6. Press the enter key once

NOTE:

=AVERAGE(B1:B8)

Congratulations!!!

About Author

SURF

See author's posts