Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Checking a filled-down formula. After a formula is filled down, click the last cell and read it. Ranges without $ move one row each time, so later rows check the wrong rows. A quick test: do the parts add up to the whole?
=COUNTIF(A2:A9,D2) in E2 becomes =COUNTIF(A3:A10,D3) in E3
The AI assistant built a revenue-by-region table for April orders. The four region totals add up to less than the total of all orders in F6.
AI assistant: “Done! I wrote a SUMIF in F2 and filled it down, so F2:F5 has April revenue for each region.”
Check the AI’s formulas in F2:F5 and fix them so every region’s total is right.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Value | Region | Revenue | |||
| 2 | 50279 | North | 247.61 | North | 373.86AI | |||
| 3 | 50281 | East | 585 | South | 682.5AI | |||
| 4 | 50282 | South | 132.05 | East | 244.05AI | |||
| 5 | 50283 | North | 126.25 | West | 838.85AI | |||
| 6 | 50284 | South | 49.5 | All orders | 2724.26 | |||
| 7 | 50285 | South | 188.5 | |||||
| 8 | 50287 | West | 280.25 | |||||
| 9 | 50288 | West | 558.6 | |||||
| 10 | 50289 | South | 312.45 | |||||
| 11 | 50290 | East | 244.05 | |||||
| 12 | ||||||||
| 13 | ||||||||
| 14 |
=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