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

Using AutoCalculate

When you wanted to quickly check a total in earlier versions of Excel, did you ever use a calculator or enter temporary formulas on a worksheet? If you did, you might find Excel's AutoCalculate feature very handy. AutoCalculate lets you quickly check a total or an average, count entries or numbers, and find the maximum or minimum number in a range.

Here's how AutoCalculate works. To check a total, select the range you want to sum. Excel automatically displays the answer in the AutoCalculate area (as shown in Figure 16.2). If you want to perform a different function on a range of numbers, select the range and right-click in the AutoCalculate area to display the shortcut menu. Then choose a function from the menu. For example, choose Count to count the numeric values in the range. The answer appears in the AutoCalculate area.AutoCalculate area


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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