How to create marksheet in ms excel

Guide

1. On a blank sheet, enter the headers and fields you want to include in your mark sheet.

2. Input the data that you have for the table you just created.

3. Calculate the total. In our case we do this by entering in the cell "=SUM (B2,C2,D2)," click on enter to finish.

4. To calculate the percentage, type =E3/300*100 in the cell, as shown in our example.

5. Finish by dragging the bottom corner of the cell to automatically fill in the rest of the table.