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

Chapter 6. Working with Formulas

Many people use a worksheet to perform mathematical calculations. By using formulas, if a value in a referenced cell changes, any formula based on the cell automatically adjusts to accommodate the new value. Excel can accommodate both simple formulas, such as adding two values together, and complex formulas, such as adding two values together and multiplying the result by another number. In addition, Excel can include the values from many different worksheet cells.

In this chapter, you’ll learn how to:

  • Create simple and compound formulas

  • Edit formulas

  • Copy formulas

  • Create an absolute reference in a formula

  • View formulas in the worksheet

  • Understand common formula error messages


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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