Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
SEQUENCE. SEQUENCE(rows, [columns], [start], [step]) spills a list of numbers: SEQUENCE(5) is 1 to 5, and SEQUENCE(4,1,0,10) is 0, 10, 20, 30. Many functions accept the whole list and return one result per number. A4# means the whole spill that starts in A4, however long it is.
=DATE(2026,SEQUENCE(4)*3,1)
Finance's 2026 budget template needs a column of month-end dates and the number of days in each month. It should rebuild itself when the planner changes the first month in B1.
In A4, write one formula that spills the 12 month-end dates starting with the month in B1 (B1 holds the first day of that month). In B4, spill the number of days in each of those months, pointing at the A4 spill. Point at B1 rather than typing a date.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | First month | 2026-01-01 | ||||||
| 2 | ||||||||
| 3 | Month end | Days | ||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 | ||||||||
| 10 | ||||||||
| 11 | ||||||||
| 12 | ||||||||
| 13 | ||||||||
| 14 | ||||||||
| 15 | ||||||||
| 16 | ||||||||
| 17 | ||||||||
| 18 | ||||||||
| 19 | ||||||||
| 20 | ||||||||
| 21 | ||||||||
| 22 | ||||||||
| 23 |
=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