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

Part 5. Working with Formulas and Functions

Part 5. Working with Formulas and Functions

In Excel, a formula calculates a value based on the values in other cells of the workbook. Excel displays the result of a formula in a cell as a numeric value.

Functions are abbreviated formulas that perform a specific operation on a group of values. Excel provides more than 250 functions that can help you with tasks ranging from determining loan payments to calculating investment returns. For example, the SUM function automatically adds entries in a range. To use it, you first type =SUM( in either lower- or uppercase letters. Then you select the range. You end the function by typing ), which tells Excel you are finished selecting the range.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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