Excel 2007 AutoAVERAGE

The AutoAVERAGE feature is a shortcut to using Excel's AVERAGE function. It provides a quick way to find the average value in columns or rows of numbers in a spreadsheet.

The syntax for AutoAVERAGE is the same as the AVERAGE function.

=AVERAGE ( Number1, Number2, ... Number255 )

Up to 255 numbers can be entered into the function.

Example Using Excel's AutoAVERAGE Feature:

Note: For help with this example, see the image above and to the right.

1. Enter the following data into cells C1 to C6:
   

   11, 12, 13, 14, 15, 16

2. Make sure that cell C7 - the location where the results will be displayed is blank.


3. Drag select cells C1 to C6 in the spreadsheet.


4. Click on the Home tab.


5. Click on the down arrow beside the AutoSum button on the ribbon to open the drop down menu.


6. Click on the word AVERAGE in the menu to enter the AVERAGE function into cell C7.


7. Press the ENTER key on the keyboard to accept the function.


8. The answer 13.5 should appear in cell C7.


9. Click on cell C7 and the complete function = AVERAGE (C1 : C6) appears in the formula bar above the worksheet.

• Excel 2007 AVERAGE Function
• Excel 2007 AutoSum
• Excel 2007 MAX Function
• Excel 2007 MIN Function