🎯 Objective:
To learn how to enter marks of multiple students, calculate total, percentage, and rank using Microsoft Excel.
🧠 What You Will Learn:
- Entering data in rows & columns
- Using formulas:
SUM, /, RANK
- Formatting cells: bold, color, borders
- Adding % symbol
- Saving your Excel file
📊 Example Table: Student Marks for 5 Students & 6 Subjects
✅ Step 1: Open Microsoft Excel
- Start → Search "Excel" → Open → Blank Workbook
✅ Step 2: Enter the Table
| Name |
English |
Math |
Science |
SST |
Computers |
Hindi |
Total |
% |
Rank |
| Eklaveya Dora |
85 |
90 |
80 |
70 |
75 |
88 |
|
|
|
| Arjun Patel |
92 |
85 |
78 |
82 |
80 |
89 |
|
|
|
| Sia Verma |
75 |
80 |
70 |
68 |
72 |
74 |
|
|
|
| Neha Sharma |
88 |
91 |
85 |
90 |
86 |
90 |
|
|
|
| Aarav Mehta |
70 |
65 |
60 |
72 |
68 |
69 |
|
|
|
✅ Step 3: Calculate Total & Percentage
📌 Start from Row 2.