Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Adding cells. Put + between two cell addresses to add them. Because the formula points at the cells, the total updates by itself when either number changes. Typed numbers would go stale.
=C2+C4 adds C2 and C4
The stockroom wants to know how many boxes of pens and paper there are together.
In B6, add the pens and the paper with a formula. Use the two cells, not whole rows or columns.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Boxes | ||||||
| 2 | Paper | 8 | ||||||
| 3 | Pens | 12 | ||||||
| 4 | Staplers | 5 | ||||||
| 5 | ||||||||
| 6 | Pens + Paper | |||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 |
=IF(B2>=1.5,SUM(C2:C9),0)Language