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 filled in unit prices from the price list on the right. Some prices don't match the list.
AI assistant: “I looked up each product's list price with VLOOKUP and filled C2:C9.”
Fix C2:C9 so every unit price matches the price list exactly.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product ID | Qty | Unit price | Product ID | List price | |||
| 2 | 203 | 4 | 5.5AI | 203 | 36 | |||
| 3 | 305 | 2 | 21AI | 101 | 5.5 | |||
| 4 | 101 | 10 | 5.5AI | 305 | 21 | |||
| 5 | 201 | 3 | 5.5AI | 402 | 12 | |||
| 6 | 405 | 1 | 19AI | 201 | 24 | |||
| 7 | 104 | 2 | 5.5AI | 104 | 84 | |||
| 8 | 402 | 5 | 23.5AI | 306 | 23.5 | |||
| 9 | 306 | 3 | 21AI | 405 | 19 | |||
| 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