Open Microsoft Excel and create a new worksheet
Enter student details in the top rows such as school name, class, section, and exam name
Create column headings for Roll No, Student Name, Subject names, Total Marks, Obtained Marks, and Percentage
Enter the marks for each student under the respective subject columns
Add a Total column to calculate the sum of marks
Use the SUM formula to calculate total marks
Add a Percentage column to calculate the percentage using the total marks
Use the formula `=Total Marks/Maximum Marks*100`
Add a Grade column if needed
Use the IF formula to assign grades based on marks or percentage
Add a Result column to show Pass or Fail status
Use the IF formula to determine pass or fail
Format the marksheet with borders, bold headings, and center alignment
Adjust column widths for better readability
Apply number formatting to percentage and marks columns
Freeze the top row if needed for easy scrolling
Save the file with a proper name
Print or export the marksheet as needed