🧮 Day 50: SUM & AVERAGE Functions (MS Excel) – Hinglish
SUM & AVERAGE Functions (MS Excel) – Hinglish
📌 Function kya hota hai?
Excel me ready-made formulas ko Function kehte hain.
👉 Example:
SUM()
AVERAGE()
➕ 1) SUM Function
✅ Use:
Numbers ka total (sum) nikalna.
📌 Syntax:
=SUM(range)
📊 Example:
| A | B |
|---|---|
| Marks | |
| 50 | |
| 60 | |
| 70 |
👉 Formula:
=SUM(B2:B4)
👉 Result = 180
✅ Multiple cells add karna:
=SUM(A1,A2,A3)
📊 2) AVERAGE Function
✅ Use:
Numbers ka average (mean) nikalna.
📌 Syntax:
=AVERAGE(range)
📊 Example:
| Marks |
|---|
| 50 |
| 60 |
| 70 |
👉 Formula:
=AVERAGE(B2:B4)
👉 Result = 60
🧠 Important Points (Exam ke liye)
✅ Function hamesha = se start hota hai
✅ Range ka format = B2:B10
✅ SUM = Total
✅ AVERAGE = Average
🧪 Practice Task (Important)
👉 Excel me ye data enter karo:
| Name | Marks |
|---|---|
| Rahul | 80 |
| Priya | 90 |
| Amit | 70 |
| Neha | 60 |
Tasks:
Total Marks = SUM
Average Marks = AVERAGE
👉 Formula:
=SUM(B2:B5)
=AVERAGE(B2:B5)
📝 Short Notes (Exam ke liye)
👉 SUM = Total nikalne ke liye
👉 AVERAGE = Average nikalne ke liye