Thursday, 27 November 2014

How to use the AVERAGE Function in Microsoft Excel 2010


The AVERAGE Function adds a range of cells and then divides by the number of cell entries.
For example, this could be used to calculate the average amount of expenses that you actual spent during a month. The formula syntax for the AVERAGE function is: AVERAGE (number1, number2, ...). There are two ways to use the AVERAGE function:

Using the Home Tab
1. Select the cell where you want to place the average value.
2. On the [Home] tab, in the [Editing] group, click the arrow next to [AutoSum].



3. Click [Average], and then press ENTER.

Using the Formulas Tab
1. Select the cell where you want to place the average value.
2. On the [Formulas] tab, in the [Function Library] group, click [Insert Function].
The [Insert Function] dialog box will be displayed as shown below:



3. Having the AVERAGE function highlighted, click OK.
4. The [Function Arguments] dialog box will appear showing the range and values for the arguments.
5. Click OK to accept the function arguments. The AVERAGE value will be inserted automatically in the cell you have selected in step 1.