Microsoft® Office Excel® 2007 Plain & Simple

Chapter 6. Using Formulas and Functions

In this section:

• Understanding Formulas and Cell References in Excel

• Create and Edit Formulas

• Create, Edit, and Delete Named Ranges

• Using Names in Formulas

• Summarize 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

• Create Conditional Functions

• Debugging Your Formulas

Microsoft Excel 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 your times in bicycle races, you can find the ...