Here's how to do it:
- On a blank sheet, enter the headers and fields you want to include in your mark sheet.
- Input the data that you have for the table you just created.
- Calculate the total. In our case we do this by entering in the cell "=SUM (B2,C2,D2)," click on enter to finish.
- To calculate the percentage, type =E3/300*100 in the cell, as shown in our example.
- Finish by dragging the bottom corner of the cell to automatically fill in the rest of the table.
