Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
The AI assistant counted Q3 online orders from Mid-Market and Enterprise customers by region and month. The grid’s grand total is a few orders short of the list.
AI assistant: “Here’s the region × month count. Each cell counts orders from the first of the month up to the month end from EOMONTH, so the months can’t overlap.”
Check the AI’s formulas in H2:J5 and fix them so each cell counts the orders in A2:A41 for the region in column G and the whole month that starts on the date in row 1, first and last day included.
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Customer | Region | Value | Region | 2025-07-01 | 2025-08-01 | 2025-09-01 | Q3 | |
| 2 | 50555 | 2025-07-03 | Copper Bakery | North | 1,724.00 | North | 4AI | 2AI | 8AI | 14 | |
| 3 | 50578 | 2025-07-11 | Harbor Bakery | East | 460.80 | South | 5AI | 4AI | 2AI | 11 | |
| 4 | 50580 | 2025-07-11 | Willow Studios | North | 1,284.30 | East | 2AI | 3AI | 2AI | 7 | |
| 5 | 50583 | 2025-07-13 | Bright Pharmacy | North | 943.90 | West | 0AI | 4AI | 1AI | 5 | |
| 6 | 50595 | 2025-07-16 | Pioneer Studios | North | 85.50 | Total | 11 | 13 | 13 | 37 | |
| 7 | 50598 | 2025-07-17 | Oak Bakery | East | 570.50 | Orders in list | 40 | ||||
| 8 | 50599 | 2025-07-18 | Orchard Clinic | South | 1,044.40 | ||||||
| 9 | 50610 | 2025-07-22 | Orchard Clinic | South | 3,239.40 | ||||||
| 10 | 50623 | 2025-07-25 | Copper Media | South | 409.45 | ||||||
| 11 | 50627 | 2025-07-28 | Copper Fitness | South | 198.00 | ||||||
| 12 | 50633 | 2025-07-29 | River Bakery | South | 81.68 | ||||||
| 13 | 50638 | 2025-07-31 | Copper Media | South | 307.80 | ||||||
| 14 | 50639 | 2025-07-31 | Cedar Studios | South | 347.20 | ||||||
| 15 | 50645 | 2025-08-04 | Copper Fitness | South | 389.28 | ||||||
| 16 | 50648 | 2025-08-05 | Harbor Realty | West | 355.50 | ||||||
| 17 | 50650 | 2025-08-05 | Orchard Clinic | South | 206.00 | ||||||
| 18 | 50655 | 2025-08-06 | Oak Academy | East | 574.40 | ||||||
| 19 | 50666 | 2025-08-08 | Atlas Bakery | South | 115.01 | ||||||
| 20 | 50668 | 2025-08-11 | Harbor Labs | East | 66.00 | ||||||
| 21 | 50670 | 2025-08-12 | Falcon Dental | East | 430.60 | ||||||
| 22 | 50676 | 2025-08-13 | Summit Motors | West | 314.78 | ||||||
| 23 | 50688 | 2025-08-16 | Harbor Consulting | North | 258.70 | ||||||
| 24 | 50691 | 2025-08-18 | Orchard Bakery | West | 223.56 | ||||||
| 25 | 50702 | 2025-08-21 | Willow Logistics | West | 256.75 | ||||||
| 26 | 50723 | 2025-08-28 | Orchard Print Co | North | 837.00 | ||||||
| 27 | 50728 | 2025-08-29 | River Bakery | South | 794.30 | ||||||
| 28 | 50733 | 2025-09-01 | Harbor Bakery | East | 59.40 | ||||||
| 29 | 50735 | 2025-09-01 | Copper Bakery | North | 468.00 | ||||||
| 30 | 50740 | 2025-09-02 | Beacon Accounting | West | 513.37 | ||||||
| 31 | 50741 | 2025-09-03 | Copper Fitness | South | 203.77 | ||||||
| 32 | 50743 | 2025-09-03 | Willow Studios | North | 1,319.70 | ||||||
| 33 | 50748 | 2025-09-04 | Oak Academy | East | 643.10 | ||||||
| 34 | 50751 | 2025-09-05 | Copper Bakery | North | 628.08 | ||||||
| 35 | 50753 | 2025-09-07 | Willow Studios | North | 135.00 | ||||||
| 36 | 50766 | 2025-09-11 | Lakeside Pharmacy | North | 678.50 | ||||||
| 37 | 50768 | 2025-09-11 | Oak Fitness | North | 859.00 | ||||||
| 38 | 50782 | 2025-09-16 | Pioneer Studios | North | 38.50 | ||||||
| 39 | 50787 | 2025-09-18 | Orchard Realty | South | 707.70 | ||||||
| 40 | 50800 | 2025-09-23 | Oak Fitness | North | 681.20 | ||||||
| 41 | 50821 | 2025-09-30 | Willow Logistics | West | 358.00 | ||||||
| 42 | |||||||||||
| 43 | |||||||||||
| 44 |
=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