Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Rule columns. Conditional formatting and data validation both run a TRUE/FALSE formula on every row. Write that formula in a helper column first: you can see each row’s result, test the edge cases, then reuse it. Keep limits in cells so the rule is easy to change.
=OR(C2>$K$1,D2="") TRUE when over the limit or missing a date
Finance wants Q3 refunds that need a second look highlighted. Before setting up the highlight, you test the rule in a helper column.
In E2:E17, show TRUE when a refund needs review: its amount is over the limit in H1, or its reason is "Damaged item". Otherwise FALSE. Point at H1 rather than typing the limit.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Refund date | Order | Amount | Reason | Needs review | Review limit | $300.00 | |
| 2 | 2025-07-05 | 50526 | $231.50 | Late delivery | ||||
| 3 | 2025-07-19 | 50586 | $330.00 | Damaged item | ||||
| 4 | 2025-07-20 | 50550 | $223.80 | Late delivery | ||||
| 5 | 2025-07-26 | 50601 | $280.75 | Damaged item | ||||
| 6 | 2025-07-31 | 50620 | $270.00 | Changed mind | ||||
| 7 | 2025-08-05 | 50635 | $620.50 | Changed mind | ||||
| 8 | 2025-08-08 | 50641 | $36.80 | Damaged item | ||||
| 9 | 2025-08-10 | 50612 | $392.37 | Late delivery | ||||
| 10 | 2025-08-19 | 50677 | $74.10 | Wrong item | ||||
| 11 | 2025-08-22 | 50689 | $11.78 | Wrong item | ||||
| 12 | 2025-08-23 | 50667 | $62.00 | Changed mind | ||||
| 13 | 2025-08-24 | 50692 | $75.00 | Damaged item | ||||
| 14 | 2025-09-03 | 50690 | $264.32 | Late delivery | ||||
| 15 | 2025-09-03 | 50714 | $50.00 | Late delivery | ||||
| 16 | 2025-09-15 | 50761 | $1,011.60 | Wrong item | ||||
| 17 | 2025-09-19 | 50773 | $317.15 | Late delivery | ||||
| 18 | ||||||||
| 19 | ||||||||
| 20 |
=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