How to Use the 'Average' Function Excel 2007?
Are you looking for easy ways to use the ‘Average’ function in Microsoft Excel 2010? It is very simple to calculate, all you need to do is, just follow some simple solution steps and you will also be able to do it.
There are times when we want to find out the average of anything such as the average number of students being present during games and so. But, while calculating the average, it is recommended to keep in mind the difference between empty cells and those containing the value zero, especially if you have cleared the Show a zero in cells that have a zero value check box in the Excel Options dialog box.
When you perform these changes, empty cells in the row are not counted, but zero values are. Now, to find out the average, you can follow the below given steps:
- 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.
- Press ‘Enter’ and it calculates the average of the values and returns the result.
- Excel also provides a built-in ‘Average Function’ to calculate an average in Excel.
- Type ‘=AVERAGE(reference to first cell containing number : reference to last cell containing number)’ that you want to calculate the average of
- Press ‘Enter’ and the function calculates the average of the values in cells and return the result.
So, now when you know the steps and have also applied them in your Excel spreadsheet. Are these steps easy to follow in Microsoft Excel 2007? You can also simplify these steps for yourself by going through our video solution which is posted below.
Image Source : homeandlearn.co.uk