Explanation of the SUM function in Excel using a sample sales dataset.

The image you've shared is a screenshot of an Excel worksheet titled "Explanation of 'SUM' Function in Excel", which demonstrates how the SUM function works in Excel using a sales data table. Let's break down what's happening and explain the solution.

---

🔍 What is the Task?

Although no explicit question is asked in the image, based on the context (a practice sheet explaining the `SUM` function), the likely goal is to:
- Understand how to use the SUM function in Excel.
- Verify that the total amount shown (`4,234`) is correctly calculated by summing all values in the "Amount" column.

---

📊 Data Overview

Here’s the structure of the data:

| Date | Item | Quantity Sold | Rate | Amount |
|------------|----------|----------------|------|--------|
| 01-04-18 | Pen | 50 | 10 | 500 |
| 02-04-18 | Pencil | 15 | 2 | 30 |
| ... | ... | ... | ... | ... |
| 18-04-18 | Sticker | 11 | 5 | 55 |
| Total | | | | 4,234 |

> The "Amount" column is already calculated as:
> `Quantity Sold × Rate`

For example:
- Pen: 50 × 10 = 500
- Pencil: 15 × 2 = 30

---

✔ How to Use the SUM Function

To calculate the total amount for all sales, you would use the SUM function in Excel.

#### Step-by-step:
1. Click on the cell below the "Amount" column where the total is displayed (likely F22).
2. Enter the formula:
```excel
=SUM(F5:F21)
```
- This adds up all the values from F5 to F21 (the range of amounts).

3. Press Enter.

Excel will return:
👉 4,234

This matches the total shown in the image — so the calculation is correct.

---

💡 Why Is This Important?

- The SUM function is one of the most commonly used functions in Excel.
- It helps automate addition of large datasets without manual calculations.
- It reduces errors and saves time.

---

🧪 Verification (Optional)

Let’s verify the total manually:
Add up all the amounts:

```
500 + 30 + 10 + 500 + 20 + 400 + 1500 + 42 + 100 + 50 + 38 + 125 + 10 + 140 + 600 + 100 + 14 + 55
```

Break it down:
- 500 + 30 = 530
- 530 + 10 = 540
- 540 + 500 = 1040
- 1040 + 20 = 1060
- 1060 + 400 = 1460
- 1460 + 1500 = 2960
- 2960 + 42 = 3002
- 3002 + 100 = 3102
- 3102 + 50 = 3152
- 3152 + 38 = 3190
- 3190 + 125 = 3315
- 3315 + 10 = 3325
- 3325 + 140 = 3465
- 3465 + 600 = 4065
- 4065 + 100 = 4165
- 4165 + 14 = 4179
- 4179 + 55 = 4,234
✔ Matches!

---

🛠️ Tips for Using SUM Function

- Use `=SUM(F5:F21)` to add a range.
- You can also use `=SUM(F5,F6,F7,...)` but this is inefficient.
- Use AutoSum button (Σ) in the Home tab → it automatically detects the range.
- Ensure there are no blank or text cells in the range unless intended.

---

🎯 Conclusion

✔ The SUM function has been used correctly here.
✔ The total 4,234 is accurate.
✔ This sheet serves as a great practice tool for learning basic Excel formulas.

---

📥 Next Steps (as suggested by the image)

You can:
- Download the practice sheets mentioned at the bottom.
- Try creating similar tables and apply the `SUM` function yourself.
- Practice with other functions like `AVERAGE`, `COUNT`, etc.

Let me know if you want help writing formulas for filtering specific items (e.g., total sales of "Pen") or conditional sums!