Microsoft Office Tutorials and References
In Depth Information
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