Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Formulas. A formula starts with =. Type = and then a cell address, and the cell shows whatever is in that address. When that cell changes, the formula follows. Instead of typing the address, you can type = and click the cell.
=C5 shows whatever is in C5
Your manager wants the pen count shown next to the label in D1, and it must stay right when the count changes.
In E1, write a formula that shows what's in B3. Start with =.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Boxes | Pens in stock | |||||
| 2 | Paper | 8 | ||||||
| 3 | Pens | 12 | ||||||
| 4 | Staplers | 5 | ||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 |
=IF(B2>=1.5,SUM(C2:C9),0)Language