Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
For the monthly order count, you asked the AI assistant to tag each Q1 order with the first day of its month. The counts in F2:F4 use those tags, and January suddenly shows no orders at all.
AI assistant: “Done! C2:C9 is the first day of each order’s month: the month end plus one day.”
Check the AI’s formulas in C2:C9. Fix them so each row shows the first day of the order’s own month (an order on 18 Jan 2025 gets 1 Jan 2025). The counts in F2:F4 will follow.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Order date | Month | Month | Orders | |||
| 2 | 50001 | 2025-01-01 | 2025-02-01AI | 2025-01-01 | 0 | |||
| 3 | 50013 | 2025-01-04 | 2025-02-01AI | 2025-02-01 | 4 | |||
| 4 | 50053 | 2025-01-18 | 2025-02-01AI | 2025-03-01 | 2 | |||
| 5 | 50073 | 2025-01-26 | 2025-02-01AI | |||||
| 6 | 50094 | 2025-02-01 | 2025-03-01AI | |||||
| 7 | 50138 | 2025-02-16 | 2025-03-01AI | |||||
| 8 | 50181 | 2025-03-01 | 2025-04-01AI | |||||
| 9 | 50223 | 2025-03-15 | 2025-04-01AI | |||||
| 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