Page 2 of 24PREVNEXT

Get to know Excel 2007: Enter formulas

Worksheet with entertainment expenses

A budget in a worksheet needs an amount in cell C6.

Imagine that Excel is open and you're looking at the "Entertainment" section of a budget for household expenses. Cell C6 in the worksheet is empty; the amount spent for CDs (compact discs) in February hasn't been entered yet.

In this lesson you'll learn how to use Excel to do basic math by typing simple formulas into cells. You'll also learn how to total all the values in a column with a formula that updates its result if values change later on. In the practice session at the end of the lesson, you'll have a chance to use the formulas you've learned about. You'll need Excel 2007 to do the practice steps.

Page 2 of 24PREVNEXT