Lesson: Percentage in Microsoft Excel

1. Introduction

Percentage shows a student’s marks in relation to the maximum marks.

In a Student Report, after calculating the Total Marks, percentage is calculated to understand the student’s overall performance in percentage form.

For example, if a student obtains 235 marks out of 300, the percentage is:

Percentage = (Obtained Marks ÷ Maximum Marks) × 100

= (235 ÷ 300) × 100
= 78.33%

The Student Report practical in the provided notes includes calculating percentage after working with the student’s marks.

2. Why Percentage is Used

Percentage makes it easier to understand a student’s performance when the maximum marks are known.

For example:

Instead of looking only at total marks, percentage gives a common scale for comparing performance when the maximum marks are the same.

3. Percentage Formula

The basic mathematical formula is:

┌─────────────────────────────────────────┐
│                                         │
│ Percentage = (Obtained Marks ÷          │
│              Maximum Marks) × 100       │
│                                         │
└─────────────────────────────────────────┘

Example

Obtained Marks = 235
Maximum Marks  = 300

Therefore:

= (235 ÷ 300) × 100
= 78.33%

4. Percentage Formula in Excel

Suppose:

• F2 contains Total Marks.
• Maximum Marks are 300.
• G2 is the Percentage column.

Then the Excel formula is:

=(F2/300)*100

Formula Breakdown

        F2
        ↓
Total Marks ÷ Maximum Marks × 100
        ↓
     Percentage

For example:

=(235/300)*100

Result:

78.33

If the result is formatted appropriately as a percentage, it can be displayed as:

78.33%

5. Student Report Example

Suppose the report contains:

For Rahul:

Total

=SUM(B2:D2)

Result:

235

Percentage

=(E2/300)*100

Result:

78.33%

6. Percentage Calculation Flow

┌─────────────────────┐
│   Subject Marks     │
└──────────┬──────────┘
           ↓
┌─────────────────────┐
│    Total Marks      │
└──────────┬──────────┘
           ↓
┌─────────────────────┐
│ ÷ Maximum Marks     │
└──────────┬──────────┘
           ↓
┌─────────────────────┐
│       × 100         │
└──────────┬──────────┘
           ↓
┌─────────────────────┐
│     Percentage      │
└─────────────────────┘

7. Copying the Percentage Formula

Excel’s relative references make it possible to copy the percentage formula to other students.

For the first student:

=(E2/300)*100

When copied to the next row:

=(E3/300)*100

Next row:

=(E4/300)*100

Excel automatically adjusts the cell reference according to the row.

8. Percentage and Student Performance

Percentage can then be used as a basis for other parts of the Student Report, such as Grade and Result, according to the criteria used by the institution.

Overall Flow

Total Marks
     ↓
Percentage
     ↓
Grade
     ↓
Result

The provided Student Report practical covers percentage along with grade and result calculations.

9. Important Points

• Percentage is calculated from obtained marks and maximum marks.
• Total Marks should be calculated correctly before calculating percentage.
• The maximum marks must be correct.
• The formula can be copied to other student rows.
• Percentage can be formatted so that the result is easy to read.
• Percentage may be used for determining Grade and Result according to the defined criteria.

10. Quick Formula Chart

┌────────────────────────────────────┐
│        PERCENTAGE FORMULA           │
├────────────────────────────────────┤
│                                    │
│ = (Obtained Marks / Maximum Marks) │
│   × 100                            │
│                                    │
├────────────────────────────────────┤
│ Excel Example:                     │
│ =(F2/300)*100                      │
└────────────────────────────────────┘

Easy Way to Remember

Percentage = Obtained ÷ Maximum × 100

Marks Obtained
      ÷
Maximum Marks
      ×
     100
      ↓
  Percentage

⭐ One-Line Definition

Percentage is the value that represents a student’s obtained marks as a proportion of the maximum marks, expressed out of 100.