How to Create Marksheet in MS Excel
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.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it