Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Other signs. Formulas use calculator signs: - subtracts, * multiplies (not x) and / divides. Point at cells instead of typing numbers, so the results follow the data.
=C2*C3 multiplies C2 by C3
The stockroom wants three quick numbers about its pens.
In B6, subtract the boxes sold from the stock. In B7, multiply the stock by the price per box. In B8, divide the price per box by the pens per box.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Stock (boxes) | 12 | ||||||
| 2 | Sold (boxes) | 4 | ||||||
| 3 | Price per box | 5 | ||||||
| 4 | Pens per box | 10 | ||||||
| 5 | ||||||||
| 6 | Boxes left | |||||||
| 7 | Stock value | |||||||
| 8 | Price per pen | |||||||
| 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