Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Rows. A row runs across the sheet, and everything about one item sits in the same row. To find an item, look down one column for the value you need, then read across that row to the other columns.
If C7 holds 30, the name that goes with 30 is in A7
The stock list has six items. Your manager asks which one has exactly 6 boxes left.
Find the item with 6 boxes and type its name in E2.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Boxes | ||||||
| 2 | Paper | 8 | Item with 6 boxes: | |||||
| 3 | Pens | 12 | ||||||
| 4 | Staplers | 5 | ||||||
| 5 | Tape | 6 | ||||||
| 6 | Folders | 9 | ||||||
| 7 | Glue | 3 | ||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 |
=IF(B2>=1.5,SUM(C2:C9),0)Language