Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
CHOOSE. CHOOSE(index, value1, value2, …) returns the value in the position given by index: 1 picks the first, 2 the second. With the index in one cell, a single switch changes every formula that uses it. Lock the switch cell with $ so filling keeps pointing at it.
=CHOOSE($B$1,C2,D2,E2) price list A, B or C
Grace Whitfield wants one forecast table she can flip between the low, base and high growth plans by changing a single number in B8, instead of keeping three copies.
In C2:C5, forecast 2026 revenue: 2025 revenue in column B times (1 + the growth rate picked from E:G on the same row by the scenario number in B8: 1 = Low, 2 = Base, 3 = High). Round to 2 decimals. Write it once in C2 and fill down.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Region | Revenue 2025 | Forecast 2026 | Low | Base | High | ||
| 2 | North | 84,437.01 | 3% | 5% | 7% | |||
| 3 | South | 90,503.25 | 2% | 4% | 6% | |||
| 4 | East | 60,763.86 | 4% | 7% | 10% | |||
| 5 | West | 100,293.15 | -2% | 1% | 4% | |||
| 6 | Total | 335,997.27 | 0.00 | |||||
| 7 | ||||||||
| 8 | Scenario (1 Low, 2 Base, 3 High) | 2 | ||||||
| 9 | ||||||||
| 10 | ||||||||
| 11 |
=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