Scribd
Upload
22 views2 pages

Average Function Excel

another chapter of ai

Uploaded by

bhoomikay286
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views2 pages

Average Function Excel

another chapter of ai

Uploaded by

bhoomikay286
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

3.

CALCULATE THE AVERAGE SCORE OBTAINED BY EACH


STUDENT.

The following image shows the Reg.No, Names and Scores in Four
subjects of 06 students of a class. Given that the maximum marks of
each subject are 25.

Use the AVERAGE function of Excel.

NAME OF THE
SL.NO. REG.NO STUDENT SUB 1 SUB 2 SUB 3 SUB 4
1 20231 REKHA 15 23 14 16
2 20232 SINDHU 25 24 23 21
3 20233 PALLAVI 17 19 18 20
4 20234 ANANAYA 18 13 17 21
5 20235 SHASHI 24 22 22 15
6 20236 SHOBA 22 25 24 20

SOLUTION

The steps to calculate the average are listed as follows:

Step 1: Enter the following formula in cell H4.

“=AVERAGE (D4:G4)”

So, we have supplied the cell references of row 4 to the AVERAGE


function of Excel.

Step 2: Press the “Enter” key. The output in cell D4 is 17. Hence, the
average score of the student Rekha is 17.
Step 3: Drag the formula of cell H4 till cell H9. For dragging, use
the excel fill handle appearing at the bottom-right side of cell.
EXCEL - SOLUTION

NAME OF THE
SL.NO. REG.NO STUDENT SUB 1 SUB 2 SUB 3 SUB 4 Average
1 20231 REKHA 15 23 14 16 17
2 20232 SINDHU 25 24 23 21 23.25
3 20233 PALLAVI 17 19 18 20 18.5
4 20234 ANANAYA 18 13 17 21 17.25
5 20235 SHASHI 24 22 22 15 20.75
6 20236 SHOBA 22 25 24 20 22.75

You might also like