The tutor tells about using the Fill button to extend a number pattern.

If you want a really quick way to extend a series of numbers, here’s how in Excel (2007):

1. In adjacent cells, enter the known numbers of the pattern. Then, select them, and extend the selection across the cells you want to follow the trend.
2. Click the Fill button. On the Home pane, it’s in the Editing suite, top right. It’s a downward arrow.
3. A menu will appear. Select Series…
4. You need to select Linear or Growth. If you think the number will change by a constant value each time, select Linear. If you think the number will change by a constant percentage each time, select Growth. (See the next step for perspective.)
5. Age, for example, increases by a constant value. On the other hand, a compound interest investment or a population will tend to increase by a constant percentage. (Some physical processes, like the heat felt when approaching a fire, don’t follow either pattern.)
6. Having chosen either Linear or Growth, now check Trend, then OK.
7. Hopefully you’ll see your trend extend across the selected cells.

HTH:)

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.