Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
SUM and ranges. SUM adds a range of cells. A range is written first:last with a colon, so B2:B7 means "B2 down to B7". Much shorter than adding cells one by one.
=SUM(C2:C5) adds C2, C3, C4 and C5
The warehouse wants the total units sold last quarter across six products.
In B8, total the units in B2:B7 with one function.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product | Units | ||||||
| 2 | Copy Paper A4 (500) | 412 | ||||||
| 3 | Toner Cartridge Black | 96 | ||||||
| 4 | Espresso Beans 1kg | 188 | ||||||
| 5 | Paper Cups (1000) | 143 | ||||||
| 6 | All-Purpose Cleaner 5L | 121 | ||||||
| 7 | Ballpoint Pens (50) | 257 | ||||||
| 8 | Total | |||||||
| 9 | ||||||||
| 10 | ||||||||
| 11 |
=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