Question

how to find arithmetic sequence, geometric sequence, and fibonacci sequence on excel?

Answer 1

Fill a column with arithmetic sequence of numbers

1. Select the first cell in the range that you want to fill.
2. Type the starting value for the sequence.
3. Type a value in the next cell to establish a pattern.
4. Select the cells that contain the starting values.
5. Drag the fill handle across the range that you want to fill.

Fill a column with geometric sequence of numbers

1. Select the first cell in the range that you want to fill(say cell A1).
2. Type the starting value for the sequence.
3. Type "=A1*r" in the next cell to establish a pattern. (here r is the ratio between any to consecutive numbers in the sequence.)
4. Select the cell that contain the formula.
5. Drag the fill handle across the range that you want to fill.

Fill a column with fibanocci sequence of numbers (1,1,2,3,5,8,13,...)

1. Select the first two cells in the column that you want to fill and type "1" in both cells.(say A1 and A2)
2. Type a formula "=A1+A2" in the next cell to establish a pattern.
3. Select the cell that contain the formula.
4. Drag the fill handle across the range that you want to fill.