Basic Functions
Beginner
MIN and MAX Functions
Find the minimum and maximum values in a dataset.
Task:
You are analyzing product prices to understand the price range. Find the minimum price in cell C8 and the maximum price in cell C9 to identify the lowest and highest priced items in your inventory.
Learning Objectives:
- Learn MIN and MAX functions
- Understand range references
- Practice finding extreme values
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | Product | Category | Price |
| 2 | Laptop | Electronics | 899 |
| 3 | Phone | Electronics | 599 |
| 4 | Desk | Furniture | 299 |
| 5 | Chair | Furniture | 149 |
| 6 | Tablet | Electronics | 399 |
| 7 | Lamp | Furniture | 79 |
| 8 | Minimum Price | ||
| 9 | Maximum Price |
What this exercise teaches (contains the answer)
MIN and MAX functions are essential for finding extreme values in datasets.