Quick summary
This tutorial shows you how to create a marksheet in MS Excel step by step, from setting up headers and data fields to using SUM and percentage formulas to calculate results automatically.
Steps
- On a blank sheet, enter the headers and fields you want to include in your marksheet.
- Input the data for each student into the table you just created.
- Calculate the total marks by entering the SUM formula (e.g., =SUM(B2,C2,D2)) in the appropriate cell and pressing Enter.
- Calculate the percentage by typing a formula such as =E3/300*100 in the designated cell.
- Drag the bottom corner of the cell to autofill the formula for the rest of the table.
