Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Operations highlights late Greenway Logistics deliveries from August before a carrier review. A delivery is late when the days from order to delivery are more than the promised days. The AI assistant wrote the rule column.
AI assistant: “E2:E15 is TRUE for every late delivery. You can use the same formula for the highlight.”
Check the AI’s rule in E2:E15 and fix it so it shows TRUE only for late deliveries, and FALSE otherwise.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Order date | Delivered | Promised days | Late? | |||
| 2 | 50642 | 2025-08-01 | 2025-08-05 | 5 | FALSEAI | |||
| 3 | 50645 | 2025-08-04 | 2025-08-06 | 3 | FALSEAI | |||
| 4 | 50647 | 2025-08-04 | 2025-08-10 | 3 | TRUEAI | |||
| 5 | 50650 | 2025-08-05 | 2025-08-07 | 3 | FALSEAI | |||
| 6 | 50651 | 2025-08-05 | 2025-08-07 | 3 | FALSEAI | |||
| 7 | 50653 | 2025-08-06 | 2025-08-09 | 3 | TRUEAI | |||
| 8 | 50655 | 2025-08-06 | 2025-08-10 | 3 | TRUEAI | |||
| 9 | 50659 | 2025-08-07 | 2025-08-09 | 3 | FALSEAI | |||
| 10 | 50662 | 2025-08-08 | 2025-08-11 | 5 | FALSEAI | |||
| 11 | 50665 | 2025-08-08 | 2025-08-11 | 5 | FALSEAI | |||
| 12 | 50668 | 2025-08-11 | 2025-08-14 | 3 | TRUEAI | |||
| 13 | 50670 | 2025-08-12 | 2025-08-19 | 3 | TRUEAI | |||
| 14 | 50685 | 2025-08-15 | 2025-08-20 | 5 | TRUEAI | |||
| 15 | 50709 | 2025-08-23 | 2025-08-28 | 5 | TRUEAI | |||
| 16 | ||||||||
| 17 | ||||||||
| 18 |
=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