Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Mixed references. A $ before the column letter locks the column; a $ before the row number locks the row. In a grid, lock the column of the labels down the side and the row of the labels across the top. Then a single formula can be copied right and down.
=$A3*B$1 a times table: A stays put across, row 1 stays put down
Sales wants a price card for the Coffee & Kitchen range that shows each product at the 5%, 10% and 15% volume discounts Brightline gives on bulk orders.
Fill C2:E7 with each product’s price after the discount at the top of its column: list price × (1 − discount). Write one formula in C2 that still works when you copy it right and down. Don’t round.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product | List price | 5% | 10% | 15% | |||
| 2 | Espresso Beans 1kg | $24.00 | ||||||
| 3 | Filter Coffee 1kg | $16.50 | ||||||
| 4 | Paper Cups (1000) | $36.00 | ||||||
| 5 | Tea Assortment (200) | $19.90 | ||||||
| 6 | Oat Milk 12-pack | $21.50 | ||||||
| 7 | Sugar Sticks (1000) | $11.00 | ||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 |
=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