Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Priya Raman asked the AI assistant what share of list value East’s sales reps gave away as discount in May. The answer seems low, because the big orders were the ones with 10% off.
AI assistant: “East’s sales reps gave an average discount of about 2.8% in May. I averaged the discount column.”
Check the AI’s formula in H2 and fix it so it returns the discount given as a share of list value: the sum of quantity (C) × unit price (D) × discount (E) over rows 2 to 21, divided by the sum of quantity × unit price. No rounding.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Product | Qty | Unit price | Discount | |||
| 2 | 50379 | Toner Cartridge Black | 3 | 59.00 | 5% | Discount share | 2.75%AI | |
| 3 | 50379 | Paper Cups (1000) | 6 | 36.00 | 0% | |||
| 4 | 50379 | Trash Bags (200) | 5 | 15.00 | 0% | |||
| 5 | 50379 | Espresso Beans 1kg | 6 | 24.00 | 5% | |||
| 6 | 50405 | Sugar Sticks (1000) | 3 | 11.00 | 0% | |||
| 7 | 50405 | Recycled Paper A4 (500) | 1 | 6.20 | 5% | |||
| 8 | 50405 | Label Roll (1000) | 2 | 9.90 | 0% | |||
| 9 | 50414 | All-Purpose Cleaner 5L | 4 | 14.00 | 0% | |||
| 10 | 50430 | Toner Cartridge Color | 12 | 84.00 | 10% | |||
| 11 | 50430 | Microfiber Cloths (50) | 13 | 23.50 | 10% | |||
| 12 | 50430 | Hand Soap Refill 5L | 13 | 17.50 | 10% | |||
| 13 | 50430 | Copy Paper A4 (500) | 5 | 5.50 | 0% | |||
| 14 | 50431 | Whiteboard Markers (12) | 5 | 13.50 | 0% | |||
| 15 | 50431 | Paper Cups (1000) | 3 | 36.00 | 0% | |||
| 16 | 50431 | Espresso Beans 1kg | 5 | 24.00 | 5% | |||
| 17 | 50439 | Sticky Notes (24) | 3 | 12.00 | 0% | |||
| 18 | 50439 | Sugar Sticks (1000) | 1 | 11.00 | 0% | |||
| 19 | 50445 | Paper Cups (1000) | 3 | 36.00 | 0% | |||
| 20 | 50445 | Filter Coffee 1kg | 2 | 16.50 | 5% | |||
| 21 | 50445 | Oat Milk 12-pack | 4 | 21.50 | 0% | |||
| 22 | ||||||||
| 23 | ||||||||
| 24 |
=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