Your Excel formulas cheat sheet: 22 tips for calculations and ... - Free Printable

The image shows an Excel spreadsheet with a list of plants (trees/bushes) and their inventory values across four columns (B, C, D, E). The task appears to be about using Excel's AutoSum feature and understanding how various functions work on the data.

Let’s break down what is happening in the image and solve the problem step by step:

---

🔍 Understanding the Data

- Rows 4 to 13 contain plant names and corresponding inventory numbers.
- Columns B, C, D, and E have identical inventory data for each plant.
- Row 14 contains totals for each column (likely sums).
- Row 15 contains formulas applied to the data.

---

🧩 What’s Happening in the Image?

#### ✔ AutoSum Feature
- The AutoSum button (Σ) is highlighted.
- A dropdown menu shows:
- Sum
- Average
- Count Numbers
- Max
- Min
- More Functions...
- This indicates that Excel can quickly insert common statistical formulas.

---

🔢 Formulas in Row 15 (Analysis)

Let’s look at the formulas written in row 15:

| Cell | Formula | Purpose |
|------|--------|--------|
| B15 | `=COUNT(B4:B13)` | Counts how many numeric entries are in B4:B13. Since all cells have numbers, this will return 10. |
| C15 | `=AVERAGE(C4:C13)` | Calculates the average of values in C4:C13. |
| D15 | `=MAX(D4:D13)` | Returns the highest value in D4:D13. |
| E15 | `=MIN(E4:E13)` | Returns the lowest value in E4:E13. |

> Note: The red arrows indicate that these formulas are being applied to the respective columns.

---

✔ Step-by-Step Solution & Explanation

#### 1. Count Function (`=COUNT(B4:B13)`)
- Counts only numeric values in range B4:B13.
- All 10 rows have numbers → Result: 10

#### 2. Average Function (`=AVERAGE(C4:C13)`)
- Adds up all values in C4:C13 and divides by count.
- Values: 88, 76, 90, 74, 51, 47, 65, 40, 36, 34
- Sum = 88+76+90+74+51+47+65+40+36+34 = 621
- Count = 10
- Average = 621 ÷ 10 = 62.1

#### 3. Max Function (`=MAX(D4:D13)`)
- Finds the largest number in D4:D13.
- Highest value = 90 (Strawberries)

#### 4. Min Function (`=MIN(E4:E13)`)
- Finds the smallest number in E4:E13.
- Lowest value = 34 (Gooseberries)

---

📌 Final Results

| Formula | Result |
|--------|--------|
| `=COUNT(B4:B13)` | 10 |
| `=AVERAGE(C4:C13)` | 62.1 |
| `=MAX(D4:D13)` | 90 |
| `=MIN(E4:E13)` | 34 |

---

💡 How to Use AutoSum

To apply any of these functions:
1. Select the cell where you want the result (e.g., B15).
2. Click AutoSum (Σ) → choose the desired function (e.g., Average, Max, etc.).
3. Excel automatically selects the range above or to the left — confirm or adjust as needed.

> For example, clicking Average under AutoSum in cell C15 would auto-fill `=AVERAGE(C4:C13)`.

---

✔ Conclusion

The image demonstrates how to use Excel’s AutoSum tool to quickly apply common functions like Count, Average, Max, and Min to data ranges.

You can use this method to efficiently analyze data without manually typing formulas.

✔ Final Answer:
- `=COUNT(B4:B13)` → 10
- `=AVERAGE(C4:C13)` → 62.1
- `=MAX(D4:D13)` → 90
- `=MIN(E4:E13)` → 34

These values represent the count, average, maximum, and minimum of the inventory data respectively.