Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
AVERAGE, MAX, MIN. These work exactly like SUM: give them a range. AVERAGE is the mean, MAX the largest value, MIN the smallest.
=MAX(C2:C5) the largest value in C2:C5
Sales wants a quick summary of this week’s eight order values.
In E2, E3 and E4, calculate the average, the largest and the smallest order value from B2:B9.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Value | ||||||
| 2 | 50112 | 182.4 | Average | |||||
| 3 | 50113 | 96 | Largest | |||||
| 4 | 50114 | 412.5 | Smallest | |||||
| 5 | 50115 | 58.2 | ||||||
| 6 | 50116 | 240 | ||||||
| 7 | 50117 | 133.75 | ||||||
| 8 | 50118 | 77.9 | ||||||
| 9 | 50119 | 305.1 | ||||||
| 10 | ||||||||
| 11 | ||||||||
| 12 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe