Microsoft Excel's formula functions handle a variety of calculations. One of the most common is determining an average. You can determine the average of the values in any range of cells in your spreadsheet using the Average function.
Using the Average Function
The basic formula for finding an average in Excel is "=AVERAGE(number1,number2,...)". You can place up to thirty numeric arguments within the parentheses. To select a cell or range of cells you can either type them in by hand or click the cells with your mouse after typing "=AVERAGE(" into the cell. Press "Enter" after you have completed your argument list and the output is displayed.
Use of the Average function always returns the arithmetic mean. To determine the median, use the Median function and for the mode, use Mode. The input method is the same.
Style Your World With Color
Explore a range of beautiful hues with the year’s must-have colors.View Article
Barack Obama's signature color may bring presidential power to your wardrobe.View Article
Create balance and growth throughout your wardrobe.View Article
Explore a range of deep greens with the year's "it" colors.View Article
- Stockbyte/Stockbyte/Getty Images