📝 Description This Excel project automatically calculates the total marks the students achieved and with the totals average marks is calculated to assign them grades accordingly
#🧠 Features Calculates Total, Average, and Grade Ranks students based on total marks Uses: SUM, AVERAGE, IF
#calculating total marks obtained by each student in each subject by summing the marks = sum (marks )
#calculate average from totals average marks = total sum of marks in all subjects / number of subjects = average (cell)
#using ifs formula to calculate the grade = IFS(F2>=80,"A",F2>=60,"B",F2>=40,"C",F2<=40,"F")
*conditional formating
mark the students with A grade by GREEN i.e top and RED for students who got F grade i.e failed