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 calculated quarter-over-quarter growth for the board slide. West's drop looks too dramatic.
AI assistant: “Growth % from Q2 to Q3 is in column D.”
Check D2:D5 and fix the growth formula so it measures Q3 versus Q2.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Region | Q2 revenue | Q3 revenue | Growth % | ||||
| 2 | East | 16681.08 | 13433.66 | -0.2417AI | ||||
| 3 | North | 17710.38 | 25145.99 | 0.2957AI | ||||
| 4 | South | 28080.81 | 24607.92 | -0.1411AI | ||||
| 5 | West | 35899.13 | 15364.38 | -1.3365AI | ||||
| 6 | ||||||||
| 7 | ||||||||
| 8 |
=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