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 a range. When AI writes a formula, click the cell and read its range in the formula bar. Does it start on the first data row and end on the last one? A range that stops one row early is a very common mistake.
=SUM(C2:C4) misses C5 if the data goes down to row 5
You asked the AI assistant to total last quarter’s units. The total seems smaller than the warehouse report.
AI assistant: “Done! B8 has the total units for all products.”
Check the AI’s formula in B8 and fix it so it totals every product.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product | Units | ||||||
| 2 | Copy Paper A4 (500) | 412 | ||||||
| 3 | Toner Cartridge Black | 96 | ||||||
| 4 | Espresso Beans 1kg | 188 | ||||||
| 5 | Paper Cups (1000) | 143 | ||||||
| 6 | All-Purpose Cleaner 5L | 121 | ||||||
| 7 | Ballpoint Pens (50) | 257 | ||||||
| 8 | Total | 960AI | ||||||
| 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