✅ Excel Basics Part 3 – Functions (SUM, AVERAGE, MIN, MAX, COUNT) 📊📌

1️⃣ SUM() – Add total values
=SUM(A2:A6)
▶️ Example: Add student marks in cells A2 to A6.
Result: Total score of a student.

2️⃣ AVERAGE() – Find the mean
=AVERAGE(B2:B6)
▶️ Example: Average sales from Monday to Friday.
Result: Weekly average sales.

3️⃣ MIN() – Get the smallest value
=MIN(C2:C10)
▶️ Example: Find the lowest temperature from 9 days’ data.

4️⃣ MAX() – Get the highest value
=MAX(D2:D10)
▶️ Example: Find the highest score in a test.

5️⃣ COUNT() – Count numeric entries only
=COUNT(E2:E10)
▶️ Example: Count how many students submitted marks.
(Ignores blank cells or names/text.)

🎯 Practice Task:
Imagine a student marksheet:
| Name | Marks |
|----------|--------|
| Riya | 85 |
| Aman | 76 |
| Sneha | 91 |
| Rohan | 67 |
| Tara | 78 |

Use:
✅ =SUM(B2:B6) → 397
✅ =AVERAGE(B2:B6) → 79.4
✅ =MAX(B2:B6) → 91
✅ =MIN(B2:B6) → 67
✅ =COUNT(B2:B6) → 5

💬 Tap ❤️ if this helped you!