• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Performing Calculations with ... > Using the Insert Function Feature

Using the Insert Function Feature

After you become familiar with a function or a group of functions, you place a particular function in an Excel worksheet by typing the function name and the cells to be referenced by the function (the same as you have done for formulas that you create as outlined in Lesson 3). However, when you are first starting out with functions, you will find it much easier to create them using the Insert Function feature. The Insert Function feature leads you through the process of inserting a function and specifying the appropriate cell addresses in the function.

For example, suppose you want to compute the average, maximum, and minimum of a group of cells that contain the weekly commissions for your sales force. Figure 5.2 shows how these three functions would look on a worksheet (the display has been changed in Excel to show you the functions rather than their results). You could use the Insert Function feature to create any or all of these functions.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint