Question

Create a table in spreadsheet of 5 students having marks in subjects- English, Maths & Science.

Calculate Total and Average marks of individual students using formula and maximum marks scoree by a student in a particular subject. Also display the maximum and minimum marks scored by students in each subject. The calculations must appear in appropriate cells. ​

Answer 1

Answer:

Explanation:

Define an array to store marks of 30 students in 3 subjects.