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

Chapter 2. Excel's Data Management Featu... > Using the Worksheet Functions: An Ov...

Using the Worksheet Functions: An Overview

Using worksheet functions to help manage data might seem, at the outset, a little odd. It's natural to think of functions that you enter on the worksheet to do calculations and return values, such as the average of a set of numbers, a monthly payment amount, or pi.

But there is a class of worksheet functions, valuable ones indeed, that help you find data and display it in different configurations. Some of the lookup and reference functions are presented in the following list, along with a description of how they're used. This is intended not as a comprehensive discussion of the functions, but as a brief summary of the sort of thing that's available to you right on the worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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