Question

Enter the following data and perform the given tasks using the formulae and finction
Name       English     Math    GK       EVS
Sheena      45               45        45        90
Teena         67               88        43        67
Aditi            54               67        52        66
Varsha        78               54        62        65
Priya            87               56       51         77
Nikita           65              69        77         88
Arya             77               34       67          90
(a) find out the minimum maximum and average marks in english math gk and evs.
(b)calculate the sum total of all students along with their percentage.
(c)Evaluate if any of the students are failling (Fail criteria=below 40%​

Answer 1

Answer:

This is not possible to answer this question without MS excel