1) Create a worksheet using excel having different columns depicting the Serial Number, Name of the Student, Marks obtained in various subjects i.e. English, Maths, and Science. Put in the required data for the respective columns in 20 rows. Your worksheet should contain the following:
i) Formulas that automatically calculate the grand total, average and the percentage of each student presuming that the marks in each subject are given out of 100
ii) Automatically find the highest and lowest number obtained in each subject.