Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Filling down. Write the formula once, select it and the cells below, then press Ctrl/⌘+D. The references move with the row: a formula pointing at row 2 in D2 points at row 3 in D3.
=B2*2 in E2 becomes =B3*2 in E3 when filled down
Now every region needs its January + February total.
Fill D2:D5 with each region’s January + February revenue. Write one formula in D2, then copy it down.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Region | Jan | Feb | Jan + Feb | ||||
| 2 | North | 7330.02 | 7571.92 | |||||
| 3 | South | 7903.87 | 8866.97 | |||||
| 4 | East | 4945.97 | 3585.86 | |||||
| 5 | West | 9006.93 | 11781.48 | |||||
| 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