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
Create balance and growth throughout your wardrobe.View Article
Let your imagination run wild with these easy-to-pair colors.View Article
See how the colors in your closet help determine your mood.View Article
- Stockbyte/Stockbyte/Getty Images