🧮 Day 49: Basic Formulas (+, −, ×, ÷) in MS Excel – Hinglish
Basic Formulas (+, −, ×, ÷) in MS Excel – Hinglish
📌 Formula kya hota hai?
Excel me calculation karne ke liye jo expression use hota hai usse Formula kehte hain.
👉 Formula hamesha = (equal sign) se start hota hai.
Example:
=A1+B1
➕ 1) Addition Formula (+)
✅ Use:
Numbers ko add (jodna) karna.
📌 Example:
| A | B | C |
|---|---|---|
| 10 | 20 | =A1+B1 |
👉 Result = 30
➖ 2) Subtraction Formula (−)
✅ Use:
Numbers ko minus (ghatana) karna.
📌 Example:
| A | B | C |
|---|---|---|
| 50 | 20 | =A1-B1 |
👉 Result = 30
✖️ 3) Multiplication Formula (*)
✅ Use:
Numbers ko multiply (guna) karna.
📌 Example:
| A | B | C |
|---|---|---|
| 5 | 6 | =A1*B1 |
👉 Result = 30
➗ 4) Division Formula (/)
✅ Use:
Numbers ko divide (bhaag) karna.
📌 Example:
| A | B | C |
|---|---|---|
| 60 | 2 | =A1/B1 |
👉 Result = 30
🧠 Important Rules (Exam ke liye)
✅ Formula always starts with =
✅ Use cell references (A1, B1) instead of typing numbers
✅ Excel automatically calculates result
🧪 Practice Task (Important)
👉 Excel me ye data enter karo:
| A | B | C |
|---|---|---|
| 10 | 5 | =A1+B1 |
| 20 | 4 | =A2-B2 |
| 6 | 3 | =A3*B3 |
| 40 | 8 | =A4/B4 |
Tasks:
Formulas lagao
Results check karo
📝 Short Notes (Exam ke liye)
👉 Addition = +
👉 Subtraction = −
👉 Multiplication = *
👉 Division = /