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

Using Worksheet Functions

Worksheet functions are built-in Excel formulas that perform calculations. An example of a simple function is the SUM formula which, as you might know, adds together the values in two or more cells. The result of the function =SUM(3, 2) is, of course, 5. In this case, the numbers 3 and 2 are called the function’s arguments, and the number 5 is called the function’s result. In technical terms, a function returns a result. The result a formula returns is displayed in the cell that contains the formula.

Very few meaningful data analysis tasks can be accomplished without calculations. Understanding how spreadsheet functions work is important; functions not only yield important business facts, but they also allow you to increase the range of data analysis tasks that you can perform. For example, by using spreadsheet functions you can


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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