Lesson: Examination Fee in Microsoft Excel

1. Introduction

Examination Fee is one of the fee components used in the Course Fee calculation.

In an Excel fee sheet, the Examination Fee can be entered separately along with Course Fee, Admission Fee and Prospectus Fee. After entering all the fee components, Excel can be used to calculate the total fee.

Your provided Advanced Excel notes include Examination Fee as part of the course-fee calculation practical.

2. What is Examination Fee?

Examination Fee is a separate fee amount included in the fee structure for examination-related charges.

In Excel, it can be maintained as a separate item so that the complete fee structure is clearly organized.

Simple Definition

Examination Fee is a separate fee component entered in the fee sheet and included in the total fee calculation.

3. Example of Examination Fee

Suppose the fee structure is:

Here:

Course Fee        = ₹20,000
Admission Fee     = ₹1,000
Prospectus Fee    = ₹200
Examination Fee   = ₹800

The Examination Fee is entered separately and then included in the total.

4. Entering Examination Fee in Excel

Suppose the fee details are entered into Excel as:

Therefore, the Examination Fee is stored in:

B5

So:

Cell Reference of Examination Fee = B5

5. Calculating Total Fee

The Examination Fee can be added with the other fee components using the SUM function.

Formula

=SUM(B2:B5)

This means:

B2 → Course Fee
B3 → Admission Fee
B4 → Prospectus Fee
B5 → Examination Fee

Calculation

₹20,000
+ ₹1,000
+ ₹200
+ ₹800
──────────
₹22,000

The provided notes demonstrate course-fee calculations using these fee components and SUM.

6. Direct Addition Formula

The same total can also be calculated by adding the cells individually.

=B2+B3+B4+B5

Here, the Examination Fee is included through cell B5.

7. Examination Fee — Practical Flow

Enter Course Fee
       ↓
Enter Admission Fee
       ↓
Enter Prospectus Fee
       ↓
Enter Examination Fee
       ↓
Calculate Total
       ↓
=SUM(B2:B5)
       ↓
Total Fee

8. Why Keep Examination Fee Separate?

Keeping Examination Fee as a separate entry makes the fee structure easier to understand.

Instead of showing only:

Total Fee = ₹22,000

we can show:

Course Fee          ₹20,000
Admission Fee        ₹1,000
Prospectus Fee         ₹200
Examination Fee        ₹800
                    ───────
Total Fee            ₹22,000

This clearly shows how the total amount has been calculated.

9. Examination Fee with Other Charges

A course fee sheet can be organized as:

┌─────────────────────────────┐
│       COURSE FEE SHEET      │
├─────────────────────────────┤
│ Course Fee                  │
│ Admission Fee               │
│ Prospectus Fee              │
│ Examination Fee             │
│ Tax                         │
│ Discount                    │
├─────────────────────────────┤
│ Final Payable Amount        │
└─────────────────────────────┘

The exact charges depend on the fee structure being prepared.

10. Important Formulas

Total Fee

=SUM(B2:B5)

Direct Addition

=B2+B3+B4+B5

Examination Fee Cell Reference

=B5

11. Quick Revision Table

⭐ Easy Memory Trick

COURSE FEE
     +
ADMISSION FEE
     +
PROSPECTUS FEE
     +
EXAMINATION FEE
     ↓
TOTAL FEE

One-Line Definition

Examination Fee is a separate fee component entered in an Excel fee sheet and included when calculating the total course fee.