Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Taking a percentage off. A discount of 0.05 means 5% off, so the customer pays 1 − 0.05 = 0.95 of the price. Multiply by that share. Subtracting 0.05 from a price only takes off five cents, which looks almost right on a big order.
=H4*(1-$K$1) a fee in H4 after the rate in K1 comes off
June line revenue goes into the category report. The AI assistant says it applied each line’s discount, and the total in E12 looks only a little high.
AI assistant: “Done! E2:E11 has the revenue for each June line, after its discount.”
Check the AI’s formulas in E2:E11 and fix them. Revenue = quantity × unit price × (1 − discount). Don’t round.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product | Qty | Unit price | Discount | Revenue | |||
| 2 | Copy Paper A4 (500) | 5 | $5.50 | 0% | $27.50AI | |||
| 3 | Notebook A5 (10) | 1 | $15.50 | 0% | $15.50AI | |||
| 4 | Desk Organizer | 5 | $19.00 | 0% | $95.00AI | |||
| 5 | Envelope Box (250) | 1 | $12.50 | 0% | $12.50AI | |||
| 6 | Disinfectant Wipes (12) | 6 | $21.00 | 5% | $125.70AI | |||
| 7 | Microfiber Cloths (50) | 13 | $23.50 | 10% | $304.20AI | |||
| 8 | Stapler Heavy Duty | 3 | $22.00 | 10% | $65.70AI | |||
| 9 | Paper Cups (1000) | 2 | $36.00 | 5% | $71.90AI | |||
| 10 | Label Roll (1000) | 5 | $9.90 | 5% | $49.25AI | |||
| 11 | Paper Towels (24) | 1 | $25.00 | 5% | $24.95AI | |||
| 12 | Total | $792.20 | ||||||
| 13 | ||||||||
| 14 | ||||||||
| 15 |
=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