Microsoft® Office Excel® 2003 Step by Step

Chapter 3. Performing Calculations on Data

Chapter 3 at a Glance

In this chapter you will learn to:

✓ Name groups of cells.

✓ Create formulas to calculate values.

✓ Find and correct errors in calculations.

Microsoft Excel workbooks give you a handy place to store and organize your data, but you can also do a lot more with your data in Excel. One important task you can perform in Excel is to calculate totals for the values in a series of related cells. You can also use Excel to find out other information about the data you select, such as the maximum or minimum value in a group of cells. Finding the maximum or minimum value in a group can let you identify ...