Create Marksheet in Excel for your students to show their Marks in Each Subject, Pass fail status for each subject, Total marks Achieved, Total % , Pass Fail Status and Grade.
To make this Marksheet in Excel I have used the following
Conditional Formatting – To highlight subjects in which the student has failed
Sum Formula – To show the total marks
If Formula – To show the Pass Fail status and the Grades.
You can use this marksheet in excel for any number of students in your class or…