Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Percentage change. Change % = (new − old) ÷ old. Always divide by the starting value. The result is a fraction: 0.25 means up 25%, −0.10 means down 10%. A negative result is a drop.
From 200 to 250: =(250-200)/200 gives 0.25
The West manager wants to see how revenue moved each month in the first half of 2025.
In C3:C7, calculate each month’s change compared with the month before, as a fraction (0.1 = 10%).
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Month | Revenue | Change % | |||||
| 2 | Jan | 9006.93 | ||||||
| 3 | Feb | 11781.48 | ||||||
| 4 | Mar | 12500.97 | ||||||
| 5 | Apr | 10369.8 | ||||||
| 6 | May | 12700.01 | ||||||
| 7 | Jun | 12829.33 | ||||||
| 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