SaltfishTry for free

How to Create Marksheet in MS Excel

·1 min read
In this article

Creating a marksheet in MS Excel is an efficient way to organize student grades and automatically calculate totals and percentages. This tutorial will guide you through building a functional grade sheet that can handle multiple subjects and student records.

By following these steps, you'll learn how to set up proper headers, input student data, use SUM formulas for totals, calculate percentages, and apply formulas to entire columns quickly using Excel's auto-fill feature.

Here's how to create marksheet in MS Excel

  1. Set up your marksheet by creating column headers for student names, subjects, totals, and percentages on a new worksheet.
  2. Fill in the student data and subject scores in the rows beneath your header columns.
  3. Create a total column by entering the SUM formula (=SUM(B2,C2,D2)) in the appropriate cell and pressing Enter.
  4. Add percentage calculations by typing the formula =E3/300*100 in the percentage column cell.
  5. Copy the formulas to remaining rows by selecting the formula cell and dragging the fill handle down to auto-populate the entire table.

Your turn to show how it works.

Build a walkthrough of your product with Saltfish, then share it with your customers.

Create a guide with Saltfish

Frequently Asked Questions

Yes, you can change the 300 in the formula =E3/300*100 to match your actual total possible marks. For example, if your total possible marks is 500, use =E3/500*100 instead.