Page 17 of 24PREVNEXT

Get to know Excel: Enter formulas

Using the AVERAGE function

Callout 1 Click in cell D7, click the arrow on the AutoSum button, and then click Average in the list.
Callout 2 Press ENTER to display the result in cell D7.

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

Excel would enter the formula for you if you clicked in cell D7, clicked the arrow on the AutoSum button, and clicked 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 this formula directly into the cell.

Page 17 of 24PREVNEXT