Microsoft® Excel® 2010 Plain & Simple

Chapter 6. Using Formulas and Functions

In this section:

• Understanding Formulas and Cell References in Excel

• “Creating and Editing Formulas”

• “Creating, Editing, and Deleting Named Ranges”

• Using Names in Formulas

• “Summarizing the Values in Groups of Cells”

• Creating Formulas That Reference Cells in Other Workbooks

• Summing with Subtotals and Grand Totals

• Exploring the Excel Function Library

• “Creating Conditional Functions”

• Debugging Your Formulas

Microsoft Excel 2010 workbooks allow you to do much more than simply store and organize your data. One important task you can perform in Excel is to summarize the values in related cells. Whether those cells represent the sales for a day at your store, the returns from your personal investments, or ...