How to Use the 'Average' Function Excel 2010?

If you are trying to find out an average, it means you are trying to calculate what the most common value is. And, finding out an average in Microsoft Excel 2010 also means the same thing. The process in Excel is not that difficult. However, it needs to be carried out in a systematic manner to get the accurate results.

For instance, you took exams of eight students and you may want to know what the average score was. In order to calculate the average, you will have to add up all eight exam scores and divide by how many students took the exam. Isn’t the process time consuming.

But, with Excel 2010, calculating the average of some number is very easy – you just need to use the inbuilt Average function. How? You can check out the below given steps to find out how. Here’s how it goes:

1. The Excel average formula consists of the ‘=’ sign, followed by a sum of two or more values, divided by the number of values in the group.
2. Press ‘Enter’ and it calculates the average of the values and returns the result.
3. Excel also provides a built-in ‘Average Function’ to calculate an average in Excel.
4. Type ‘=AVERAGE(reference to first cell containing number : reference to last cell containing number)’ that you want to calculate the average of
5. Press ‘Enter’ and the function calculates the average of the values in cells and return the result.

See, how easy it is to calculate Average in Microsoft Excel 2010. As said, it is important to move ahead step-by-step to get the accurate results. If you need to comprehend the above mentioned steps in a better manner, you can go through our video solution which is given below.

http://www.youtube.com/watch?v=Gp0F_WuZFwM