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 cool greys with the year's top colors.View Article
Explore a range of beautiful hues with the year’s must-have colors.View Article
Understand how color and its visual effects can be applied to your closet.View Article
Barack Obama's signature color may bring presidential power to your wardrobe.View Article
- Stockbyte/Stockbyte/Getty Images