Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Checking AI work. An AI can write a formula that looks right but points at the wrong cell. Click the cell and read its formula. For each address, find that cell and check it holds the thing you asked for.
=C2+C5 is C2 really the first item, and C5 the second?
You asked the AI assistant to add up the boxes of pens and paper. It says it's done.
AI assistant: “Done! B6 adds the paper and the pens.”
Click B6 and read the AI’s formula. Check that each address points at the item it should, then fix it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Boxes | ||||||
| 2 | Paper | 8 | ||||||
| 3 | Pens | 12 | ||||||
| 4 | Staplers | 5 | ||||||
| 5 | ||||||||
| 6 | Pens + Paper | 13AI | ||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 |
=IF(B2>=1.5,SUM(C2:C9),0)Language