Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Weekend orders wait until Monday, so ops tags them to warn customers. You asked the AI assistant to label each order Weekend or Weekday.
AI assistant: “Done! Column C has the day of the week and column D labels anything above 5 as Weekend.”
Check the AI’s formulas in C2:D9. Fix them so column D shows Weekend for orders on a Saturday or Sunday and Weekday for every other day.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Order date | Day of week | Tag | ||||
| 2 | 50072 | 2025-01-25 | 7AI | WeekendAI | ||||
| 3 | 50137 | 2025-02-15 | 7AI | WeekendAI | ||||
| 4 | 50159 | 2025-02-23 | 1AI | WeekdayAI | ||||
| 5 | 50201 | 2025-03-09 | 1AI | WeekdayAI | ||||
| 6 | 50557 | 2025-07-04 | 6AI | WeekendAI | ||||
| 7 | 50654 | 2025-08-06 | 4AI | WeekdayAI | ||||
| 8 | 50751 | 2025-09-05 | 6AI | WeekendAI | ||||
| 9 | 50945 | 2025-11-11 | 3AI | WeekdayAI | ||||
| 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