Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Running totals. A running total sums from a fixed first row down to the current row. Lock only the start: in SUM($B$2:B2), the $B$2 stays put while B2 grows to B3, B4 and so on as you fill, so the range gets one row longer each time. The last row equals the grand total.
=SUM($C$2:C2) cumulative sign-ups by week
Finance tracks Brightline’s 2025 revenue against the plan as a year-to-date line, so each month shows everything earned from January up to that month.
In C2:C13, show the running total of the monthly revenue in B2:B13: each row is the sum from January down to that row’s month. Write it once in C2 and fill down. No rounding.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Month | Revenue | Year to date | |||||
| 2 | 2025-01-01 | 29,186.84 | ||||||
| 3 | 2025-02-01 | 31,806.26 | ||||||
| 4 | 2025-03-01 | 29,910.62 | ||||||
| 5 | 2025-04-01 | 33,620.37 | ||||||
| 6 | 2025-05-01 | 31,798.09 | ||||||
| 7 | 2025-06-01 | 32,953.06 | ||||||
| 8 | 2025-07-01 | 30,974.02 | ||||||
| 9 | 2025-08-01 | 22,410.45 | ||||||
| 10 | 2025-09-01 | 25,167.64 | ||||||
| 11 | 2025-10-01 | 24,101.78 | ||||||
| 12 | 2025-11-01 | 19,019.15 | ||||||
| 13 | 2025-12-01 | 25,048.99 | ||||||
| 14 | Year | 335,997.27 | ||||||
| 15 | ||||||||
| 16 | ||||||||
| 17 |
=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