Microsoft Office Tutorials and References

In Depth Information

**AutoFill Options**

FIGURE 1.11
AutoFill Options

FIGURE 1.12
AutoFill Menu

applications once we understand what it can do. The following are two examples

that can illustrate the power of this element in Excel.

If you need to create an exponential list of the number 2, all you have to do is

type the first two terms in the series (2 and 4) and the Growth Trend feature in the list

will create the series as show in Figure 1.14. It will result in 2, 4, 8, 16, and so on.

Using this idea, we can create a compounded interest series. If you want a growth