Question

From the following information, Calculate the Total Marks, Average Marks and Grade of
every student with the help of suitable formulas & functions in Spreadsheet:
Name
Financial
Accounting Economics
Business
Maths
Cost
Management
Taxation
Aniket Biswas 88 85 91 92 89
Samiran Kabiraj 91 90 90 90 88
Surajit Das 75 85 72 72 70
Sourav Gupta 84 85 90 90 89
Ranjeet Singh 65 62 64 64 69
Sukanta Mishra 60 58 60 60 61
Rubel Sana 45 48 41 41 42
Souvik Sarkar 29 28 29 29 25
Grade the student as A,B,C according to the following rule:
(i) if total marks >=400, then the grade is "A"
(ii) if total marks >=300 but <400 then the grade is "B"
(iii) if total marks <300 then the grade is "C"

Answer 1

Answer:

A,A,B,B,C,C and C

Explanation:

Aniket Biswas--->

Total marks=(88+85+91+92+89)= 445

Grade --> A

Total marks of Samiran Kabiraj ---> (91+90+90+90+88)= 449

Grade---> A

Total marks of Surajit Das --->

(75+85+72+72+70)=374

Grade ---> B

Total marks of Sourav Gupta--->

(84+85+90+90+89)=438

Grade ----> 438

Total marks of Ranjit Singh--->

(65+62+64+64+69)=324

Grade---> B

Total marks of Sukanta Mishra---->

(60+58+60+60+61)=299

Grade--->C

Total marks of Rubel Sana ---->

(45+48+41+41+42)=217

Grade---> C

Total marks of Souvik Sarkar--->

(29+25+29+29+25)= 140

Grade --->C