Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Finance needs revenue per line after discounts.
In F2:F13, calculate revenue for each line: quantity × unit price × (1 − discount).
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Product | Qty | Unit price | Discount | Revenue | ||
| 2 | 50003 | Paper Cups (1000) | 1 | 36 | 0.05 | |||
| 3 | 50004 | Desk Organizer | 3 | 19 | 0.05 | |||
| 4 | 50004 | Paper Cups (1000) | 1 | 36 | 0.05 | |||
| 5 | 50005 | Ballpoint Pens (50) | 1 | 9.5 | 0.05 | |||
| 6 | 50007 | Notebook A5 (10) | 6 | 15.5 | 0.05 | |||
| 7 | 50009 | Paper Towels (24) | 3 | 25 | 0.05 | |||
| 8 | 50011 | Whiteboard Markers (12) | 1 | 13.5 | 0.05 | |||
| 9 | 50012 | Toner Cartridge Black | 3 | 59 | 0.1 | |||
| 10 | 50013 | Oat Milk 12-pack | 13 | 21.5 | 0.1 | |||
| 11 | 50013 | Toner Cartridge Black | 3 | 59 | 0.1 | |||
| 12 | 50014 | Notebook A5 (10) | 3 | 15.5 | 0.05 | |||
| 13 | 50014 | Microfiber Cloths (50) | 2 | 23.5 | 0.05 | |||
| 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