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

Lesson 4. Performing Simple Calculations > Using the Status Bar Auto Calculate ...

Using the Status Bar Auto Calculate Feature

Using a feature that Excel calls Auto Calculate, you can view the sum of a column of cells simply by selecting the cells and looking at the status bar. The values in the selected cells are added. You also can right-click the Auto Calculate area of the status bar and choose different formulas, such as average, minimum, maximum, and count.

This feature is useful if you want to quickly check the total for a group of cells or compute the average. It also allows you to "try out" an Excel function (discussed in Lesson 5) before actually entering it into a cell. You also can view the average, minimum, maximum, and count of a range of cells. To display something other than the sum, highlight the group of cells on which you want the operation performed, right-click the status bar, and select the option you want from the shortcut menu that appears (see Figure 4.3).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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