School Marksheet With Grade in MS Excel

 School Marksheet With Grade in MS Excel

A school marksheet with grades in Microsoft Excel can be created using a combination of formulas and conditional formatting. Here's how to do it:

1. Create a table with columns for "Student Name," "Subject," "Marks," and "Grade."
2. Enter a formula in the "Grade" column to calculate the grades based on the marks. For example, you can use the following formula: =IF(C2>=90,"A",IF(C2>=80,"B",IF(C2>=70,"C",IF(C2>=60,"D","F"))))
3. Copy the formula down the "Grade" column for all students.
4. Go to the "Home" tab in the ribbon and click on "Conditional Formatting."
5. Select "Highlight Cell Rules" and then "Less Than."
6. In the "Value1" field, enter the lower boundary for each grade, for example: 60, 70, 80, 90.
7. Choose a color for each boundary and click "OK."

Now, the grades will be automatically calculated based on the marks and highlighted with different colors in the "Grade" column. You can also add conditional formatting to highlight the highest and lowest marks, average marks, etc.