Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Reading #REF!. #REF! means a formula lost a cell it pointed at, usually because a row or column was deleted. Excel writes #REF! into the formula where the address used to be. Read what the formula was meant to do and point it at the cell that holds that value now.
=B4*#REF! the second cell is gone; find what it held
You asked the AI assistant to delete the old Supplier column from the product margin sheet. It did, and now the profit and margin columns show #REF!.
AI assistant: “Done! I removed the Supplier column. The sheet is ready.”
Fix D2:D9 so each row shows profit per unit: list price (C) − unit cost (B). The margins in E will follow.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Product | Unit cost | List price | Profit per unit | Margin | |||
| 2 | Recycled Paper A4 (500) | $3.60 | $6.20 | #REF!AI | #REF! | |||
| 3 | Toner Cartridge Color | $41.00 | $84.00 | #REF!AI | #REF! | |||
| 4 | Envelope Box (250) | $6.10 | $12.50 | #REF!AI | #REF! | |||
| 5 | Filter Coffee 1kg | $7.80 | $16.50 | #REF!AI | #REF! | |||
| 6 | Tea Assortment (200) | $9.40 | $19.90 | #REF!AI | #REF! | |||
| 7 | Hand Soap Refill 5L | $8.10 | $17.50 | #REF!AI | #REF! | |||
| 8 | Trash Bags (200) | $7.20 | $15.00 | #REF!AI | #REF! | |||
| 9 | Sticky Notes (24) | $5.60 | $12.00 | #REF!AI | #REF! | |||
| 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