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 pulled H2 revenue targets from the target grid for the managers’ requests. Marcus Hill says South’s August target is East’s number, and the West request shows an error.
AI assistant: “I used INDEX with two MATCHes: one finds the month row, the other finds the region in the header row. Filled down for all five requests.”
Check the AI’s formulas in I2:I6 and fix them so each returns the target in B2:E7 for the region in column G and the month in column H.
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Month | North | South | East | West | Region | Month | Target | |
| 2 | 2025-07-01 | 6,726 | 8,244 | 5,006 | 11,290 | South | 2025-08-01 | 5,102AI | |
| 3 | 2025-08-01 | 6,616 | 8,055 | 5,102 | 11,865 | West | 2025-10-01 | #REF!AI | |
| 4 | 2025-09-01 | 6,803 | 8,538 | 4,948 | 11,199 | North | 2025-12-01 | 8,431AI | |
| 5 | 2025-10-01 | 6,054 | 8,791 | 5,282 | 11,816 | East | 2025-07-01 | 11,290AI | |
| 6 | 2025-11-01 | 6,011 | 8,599 | 4,959 | 11,505 | South | 2025-11-01 | 4,959AI | |
| 7 | 2025-12-01 | 6,035 | 8,431 | 5,616 | 11,637 | ||||
| 8 | |||||||||
| 9 | |||||||||
| 10 |
=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