Chapter 7: Performing Calculations on Data


Chapter at a Glance

image from book

image from book
Create formulas to calculate values, page 184. Name groups of data, page 180. Summarize data that meets specific conditions, page 191. Find and correct errors in calculations, page 195.

image from book

In This Chapter, You Will Learn To:

  • image from book Name groups of data.

  • image from book Create formulas to calculate values.

  • image from book Summarize data that meets specific conditions.

  • image from book Find and correct errors in calculations.

Microsoft Office Excel 2007 workbooks give you a handy place to store and organize your data, but you can also do a lot more with your data in Office Excel 2007. One important task you can perform is to calculate totals for the values in a series of related cells. You can also use Excel 2007 to find out other information about the data you select, such as the maximum or minimum value in a group of cells. By finding the maximum or minimum value in a group, you can identify your best salesperson, product categories you might need to pay more attention to, or suppliers that consistently give you the best deal. Regardless of your bookkeeping needs, Excel 2007 gives you the ability to find the information you want. And if you should make an error, you can find the cause and correct it quickly.

Many times you can’t access the information you want without referencing more than one cell, and it’s also often true that you’ll use the data in the same group of cells for more than one calculation. Excel 2007 makes it easy to reference a number of cells at once, enabling you to define your calculations quickly.

In this chapter, you’ll learn how to streamline references to groups of data on your worksheets and how to create and correct formulas that summarize Consolidated Messenger’s business operations.

See Also Do you need only a quick refresher on the topics in this chapter? See the Quick Reference entries at the beginning of this book.

Important 

Before you can use the practice sites provided for this chapter, you need to install them from the book’s companion CD to their default location. See “Using the Book’s CD” at the beginning of this book for more information. image from book



2007 Microsoft Office System Step by Step
2007 MicrosoftВ® Office System Step by Step
ISBN: 0735622787
EAN: 2147483647
Year: 2004
Pages: 231

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net