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 asked the AI assistant for the three biggest refunds of the first half of 2025, to review them one by one. The amounts it returned seem very small for a review list.
AI assistant: “Done. H2:H4 shows the top three refunds by amount, ranked by the numbers in G2:G4.”
Check the AI’s formulas in H2:H4 and fix them so they show the 1st, 2nd and 3rd largest refund in D2:D29, using the rank in G2:G4.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Refund | Order | Date | Amount | Reason | Rank | Refund amount | |
| 2 | 1 | 50009 | 2025-01-12 | 165.25 | Late delivery | 1 | 10.45AI | |
| 3 | 2 | 50025 | 2025-01-12 | 10.45 | Changed mind | 2 | 26.40AI | |
| 4 | 3 | 50017 | 2025-01-13 | 236.82 | Damaged item | 3 | 27.10AI | |
| 5 | 4 | 50037 | 2025-01-17 | 366.60 | Changed mind | |||
| 6 | 5 | 50013 | 2025-01-19 | 410.85 | Damaged item | |||
| 7 | 6 | 50035 | 2025-01-23 | 1,214.60 | Changed mind | |||
| 8 | 7 | 50018 | 2025-01-24 | 52.25 | Late delivery | |||
| 9 | 8 | 50054 | 2025-01-30 | 420.00 | Changed mind | |||
| 10 | 9 | 50106 | 2025-02-11 | 136.78 | Late delivery | |||
| 11 | 10 | 50107 | 2025-02-18 | 582.10 | Wrong item | |||
| 12 | 11 | 50128 | 2025-02-23 | 124.40 | Changed mind | |||
| 13 | 12 | 50214 | 2025-03-19 | 42.00 | Damaged item | |||
| 14 | 13 | 50232 | 2025-03-30 | 326.00 | ||||
| 15 | 14 | 50251 | 2025-04-02 | 221.50 | Damaged item | |||
| 16 | 15 | 50259 | 2025-04-02 | 430.70 | Changed mind | |||
| 17 | 16 | 50254 | 2025-04-10 | 288.25 | Changed mind | |||
| 18 | 17 | 50272 | 2025-04-16 | 84.00 | Changed mind | |||
| 19 | 18 | 50316 | 2025-04-24 | 27.10 | Damaged item | |||
| 20 | 19 | 50315 | 2025-04-28 | 522.67 | Late delivery | |||
| 21 | 20 | 50310 | 2025-04-30 | 187.80 | Late delivery | |||
| 22 | 21 | 50364 | 2025-05-08 | 216.72 | Damaged item | |||
| 23 | 22 | 50350 | 2025-05-11 | 211.80 | Damaged item | |||
| 24 | 23 | 50360 | 2025-05-13 | 242.00 | Damaged item | |||
| 25 | 24 | 50393 | 2025-05-28 | 91.00 | Late delivery | |||
| 26 | 25 | 50433 | 2025-05-30 | 184.40 | Late delivery | |||
| 27 | 26 | 50462 | 2025-06-14 | 26.40 | Damaged item | |||
| 28 | 27 | 50508 | 2025-06-29 | 271.80 | Damaged item | |||
| 29 | 28 | 50517 | 2025-06-29 | 343.70 | Wrong item | |||
| 30 | ||||||||
| 31 | ||||||||
| 32 |
=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