Question

a) Write the formula to find the sum of all subjects of ABHAY.

b) Write the formula to find the average of marks of BHANU.

c) Write the formula to find total marks in science by all the students​

Answer 1

Answer:

a) =C2+D2+E2

b) =(C3+D3+E3)/3

c) =E2+E3+E4+E5+E6

Answer 2

a) Sum of all subjects of Abhay = Marks scored by Abhay in English + Marks scored by Abhay in Maths + Marks scored by Abhay in Science

b) Average of marks of Bhanu = (Marks scored by Bhanu in English + Marks scored by Bhanu in Maths + Marks scored by Bhanu in Science)/3

c) Total marks in science by all the students​ = Marks scored in Science by Abhay + Bhanu + Charu + Dhruv + Kripa

• Sum of all subjects of Abhay = Marks scored by Abhay in English + Marks scored by Abhay in Maths + Marks scored by Abhay in Science

According to the given table,

Marks scored by Abhay in English = 67

Marks scored by Abhay in Maths = 59

Marks scored by Abhay in Science = 59

Hence,

Sum of all subjects of Abhay = 67 + 59 + 59

                                                = 185

• Average of marks of Bhanu = (Marks scored by Bhanu in English + Marks scored by Bhanu in Maths + Marks scored by Bhanu in Science)/3

According to the given table,

Marks scored by Bhanu in English = 86

Marks scored by Bhanu in Maths = 90

Marks scored by Bhanu in Science = 92

Hence,

Average marks of Bhanu = (86 + 90 + 92)/3

                                          = 89.34

• Total marks in science by all the students​ = Marks scored in Science by Abhay + Bhanu + Charu + Dhruv + Kripa

                                                                              = (59 + 92 + 52 + 40 + 82)

                                                                              = 325

#SPJ3