🧮 Day 58: Excel Practice (Full Practical) – Hinglish

Excel Practice (Full Practical) – Hinglish

👉 Aaj hum Excel ka complete practice karenge jo exam aur real use dono ke liye useful hai ✅

📝 Practice 1: Data Entry & Formatting

📊 Step 1: Ye data Excel me enter karo:

Roll No	Name	Marks
1	Rahul	80
2	Priya	90
3	Amit	70
4	Neha	60

✨ Tasks:

Header row ko Bold & Center karo
Table me Border lagao
Marks column ko Number format do

➕ Practice 2: Basic Formulas

📊 Add new columns:

Name	Marks	Result

🧮 Formula lagao:

👉 Total Marks (SUM):

=SUM(C2:C5)

👉 Average Marks (AVERAGE):

=AVERAGE(C2:C5)

👉 Highest Marks (MAX):

=MAX(C2:C5)

👉 Lowest Marks (MIN):

=MIN(C2:C5)

🧠 Practice 3: IF Function (Pass / Fail)

📊 Add Result Column:

👉 Formula:

=IF(C2>=50,"Pass","Fail")

Copy formula downwards.

🔄 Practice 4: Sorting & Filtering

✅ Sorting:

Marks ko High to Low sort karo

✅ Filtering:

Marks > 70 wale students dikhana

📈 Practice 5: Chart Creation

📊 Task:

Marks ka Column Chart banao
Chart Title = "Student Marks"

Steps:
Insert Tab → Column Chart

🖨️ Practice 6: Print Settings

📄 Task:

Print Area set karo
Orientation = Landscape
Fit Sheet on One Page

🧪 Mini Practical Test (Exam Style)

✅ Question:

Ek marksheet banao
SUM, AVERAGE, MAX, MIN use karo
IF function lagao
Chart create karo
Sheet ko print ke liye set karo

📝 Short Notes (Exam ke liye)

👉 Excel practice se formula aur tools clear hote hain
👉 Exam me data entry + formula + chart mostly aata hai

THE LEARNING