Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Order of operations. Excel multiplies and divides before it adds and subtracts, reading left to right. So =10-4/2 gives 8, not 3. Brackets go first: =(10-4)/2 gives 3. When a formula mixes + or − with × or ÷, ask which part must happen first and bracket it.
=(B2+C2)/2 averages two cells; without brackets only C2 is halved
The buying team wants the margin on eight best sellers. The AI assistant filled in the margin column, and some products now show margins in the hundreds of percent.
AI assistant: “I added the margin for each product in D2:D9: list price minus cost, divided by list price.”
Check the AI’s formulas in D2:D9 and fix them. Margin = (list price − unit cost) ÷ list price, as a fraction (0.4 = 40%). Don’t round.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product | Unit cost | List price | Margin | ||||
| 2 | Copy Paper A4 (500) | $3.10 | $5.50 | 493.6%AI | ||||
| 3 | Toner Cartridge Black | $28.00 | $59.00 | 5852.5%AI | ||||
| 4 | Label Roll (1000) | $4.20 | $9.90 | 947.6%AI | ||||
| 5 | Espresso Beans 1kg | $11.50 | $24.00 | 2352.1%AI | ||||
| 6 | Paper Cups (1000) | $18.00 | $36.00 | 3550.0%AI | ||||
| 7 | All-Purpose Cleaner 5L | $6.70 | $14.00 | 1352.1%AI | ||||
| 8 | Paper Towels (24) | $12.40 | $25.00 | 2450.4%AI | ||||
| 9 | Ballpoint Pens (50) | $4.40 | $9.50 | 903.7%AI | ||||
| 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