Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Locking a cell with $. When you fill down, every reference moves. To keep pointing at one cell (like a total), lock it with $: $B$6 stays $B$6 in every row.
=A2/$A$10 A2 moves down, $A$10 stays put
For the board slide, you need each region’s share of January revenue.
In C2:C5, divide each region’s revenue by the total in B6. Write it once in C2 and fill down.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Region | Jan | Share | |||||
| 2 | North | 7330.02 | ||||||
| 3 | South | 7903.87 | ||||||
| 4 | East | 4945.97 | ||||||
| 5 | West | 9006.93 | ||||||
| 6 | Total | 29186.79 | ||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 |
=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