Objective 4. Construct a Formula and Use the Sum Function

Excel performs calculations on numbers; that's why you use Excel. If you make changes to the numbers, Excel automatically re-calculates. This is one of the most powerful and valuable features of Excel. You can arrange data in a format of columns and rows in other application programsin a word processing program, for exampleand even perform simple calculations. Excel, however, performs complex calculations on numbers.

Recall that a cell contains either a value or a formula. A formula is an equation that directs Excel to perform mathematical calculations on values in other cells, and to place the result in the cell containing the formula. You can construct your own formulas, or you can use one of Excel's prebuilt formulas called a function.

Activity 1.9. Constructing a Formula and Using the Sum Function

In this activity, you will sum the monthly purchases for tableware at the restaurant in Dallas.

[Page 624 (continued)]

Objective 5 Format Data and Cells

GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448