🧮 Day 60: MS Excel – Practical Test (Hinglish)
MS Excel – Practical Test (Hinglish)
👉 Aaj Excel Practical Test ka full paper + tasks + marking scheme milega.
Ye school / computer course / certificate exam ke liye perfect hai ✅
📝 Practical Test Details
⏱️ Time: 30–45 Minutes
📊 Marks: 20 / 30
💻 Software: MS Excel
📄 Question Paper (Excel Practical)
✅ Question 1: Data Entry & Formatting (5 Marks)
👉 Excel me ye data enter karo:
| Roll No | Name | Marks |
|---|---|---|
| 1 | Rahul | 80 |
| 2 | Priya | 90 |
| 3 | Amit | 70 |
| 4 | Neha | 60 |
✨ Instructions:
Header row ko Bold & Center karo
Table me Border lagao
Marks column ko Number format do
✅ Question 2: Formulas & Functions (7 Marks)
👉 New columns add karo:
| Name | Marks | Result |
|---|
🧮 Tasks:
Total Marks:
=SUM(C2:C5)
Average Marks:
=AVERAGE(C2:C5)
Highest Marks:
=MAX(C2:C5)
Lowest Marks:
=MIN(C2:C5)
Result (Pass/Fail):
=IF(C2>=50,"Pass","Fail")
✅ Question 3: Sorting & Filtering (4 Marks)
👉 Tasks:
Marks ko High to Low sort karo
Marks > 70 wale students filter karo
✅ Question 4: Chart Creation (3 Marks)
👉 Task:
Marks ka Column Chart banao
Chart Title = "Student Marks"
✅ Question 5: Print Settings (1 Mark)
👉 Tasks:
Print Area set karo
Orientation = Landscape
Fit Sheet on One Page
🏆 Bonus Question (Extra Practice)
👉 Ek new sheet me:
Ek marksheet banao
SUM, AVERAGE, MAX, MIN use karo
IF function lagao
🧠 Viva Questions (Teacher puch sakta hai)
Excel kya hai?
Formula aur Function me difference?
SUM aur AVERAGE ka use?
IF function kya hai?
Sorting aur Filtering me difference?
📝 Short Notes (Exam ke liye)
👉 Excel practical me data entry + formula + chart sabse important hai.