How to create marksheet in ms excel
- George Apostolov
How to create marksheet in ms excel: step-by-step guide
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*100in 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.
Quick answer: To create a marksheet in Excel, enter headers and fields on a blank sheet, input your data, calculate the total using the sum formula, compute the percentage with a division and multiplication formula, and drag the cell corner to automatically fill the rest of the table.
About this Excel tutorial
Build an Excel marksheet fast by entering data, calculating totals with formulas, finding percentages, and auto-filling the remaining rows. This guide shows how to create marksheet in ms excel in 5 steps, starting with "On a blank sheet, enter the headers and fields you want to include in your mark sheet" and finishing with "Finish by dragging the bottom corner of the cell to automatically fill in the rest of t...". The interactive demo above is a click-through copy of the real Excel interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to create marksheet in ms excel?
5 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Excel data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Excel. Related guides: How to Create QR Code in Microsoft Excel, How to create salary sheet in ms excel and How to Create Shared Excel File in Microsoft Teams. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
