Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
The AI assistant priced October’s order lines from the cleaning and desk price list (F1:G13) and marked lines it couldn’t find as "Not on list". More than half the lines are marked, which surprised the buyer.
AI assistant: “I looked up each line’s price in C2:C11 and marked the products that aren’t on the cleaning and desk list as "Not on list".”
Check the AI’s formulas in C2:C11 and fix them so every product on the price list shows its price and only the others show "Not on list".
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product ID | Qty | List price | Product ID | List price | |||
| 2 | 402 | 6 | $12.00AI | 301 | $14.00 | |||
| 3 | 305 | 1 | $21.00AI | 302 | $17.50 | |||
| 4 | 101 | 7 | Not on listAI | 303 | $25.00 | |||
| 5 | 302 | 5 | Not on listAI | 304 | $15.00 | |||
| 6 | 404 | 1 | $13.50AI | 305 | $21.00 | |||
| 7 | 203 | 10 | Not on listAI | 306 | $23.50 | |||
| 8 | 301 | 2 | Not on listAI | 401 | $9.50 | |||
| 9 | 406 | 6 | $15.50AI | 402 | $12.00 | |||
| 10 | 303 | 3 | Not on listAI | 403 | $22.00 | |||
| 11 | 401 | 5 | Not on listAI | 404 | $13.50 | |||
| 12 | 405 | $19.00 | ||||||
| 13 | 406 | $15.50 | ||||||
| 14 | ||||||||
| 15 | ||||||||
| 16 |
=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