Page 17 of 24PREVNEXT

Get to know Excel 2007: Enter formulas

Using the AVERAGE function

To find the average of a range, click in cell D7, and then:
Callout 1 On the Home tab, in the Editing group, click the arrow on the Sum button, and then click Average in the list.
Callout 2 Press ENTER to display the result in cell D7.

You can use the AVERAGE function to find the mean average cost of all entertainment for January and February.

Excel will enter the formula for you. Click in cell D7. On the Home tab, in the Editing group, click the arrow on the Sum button, and click Average in the list. The formula =AVERAGE(B7:C7) appears in the formula bar Formula bar near the top of the worksheet.

You could also type the formula directly into the cell.

Note     The Sum button is also located on the Formulas tab, in the Function Library group.

Page 17 of 24PREVNEXT