Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
You asked the AI assistant to pull the product number out of each SKU so the pick list can be matched to the product list in E1:F9.
AI assistant: “Done! B2:B9 now shows the product number from the middle of each SKU.”
Check the AI’s formulas in B2:B9 against the product list, then fix them so each row shows the full product number from its SKU.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | SKU | Product number | Product ID | Product | ||||
| 2 | CK-202-PK | 20AI | 202 | Filter Coffee 1kg | ||||
| 3 | PP-106-BX | 10AI | 106 | Envelope Box (250) | ||||
| 4 | CL-301-CS | 30AI | 301 | All-Purpose Cleaner 5L | ||||
| 5 | DS-404-PK | 40AI | 404 | Whiteboard Markers (12) | ||||
| 6 | CK-204-BX | 20AI | 204 | Tea Assortment (200) | ||||
| 7 | PP-102-BX | 10AI | 102 | Recycled Paper A4 (500) | ||||
| 8 | CL-306-PK | 30AI | 306 | Microfiber Cloths (50) | ||||
| 9 | DS-401-BX | 40AI | 401 | Ballpoint Pens (50) | ||||
| 10 | ||||||||
| 11 | ||||||||
| 12 |
=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