Use the formula =AVERAGE(<cell range>), where <cell range> comprises the cells to be averaged.
Example:
A1 = 2, A2 = 4, A3 = 6, A4 = 8
In cell B1 (or any other blank cell), type =AVERAGE(A1:A4) and press enter. Excel will replace the formula with the number 5.
The right word for what?? Excel is a spreadsheet used to crunch numbers and get results by using formulas, if you want to write a paper use Word.......
Add the five numbers; divide the result by 5.
In the cell where you want the mean to appear, write =AVERAGE(description of the cells containing the group of numbers) Or, when you have typed '=AVERAGE(', highlight the cells that you want to be in the set. This is easier instead of typing it in. Remember to close parentheses!
They can be used to search for both letters and numbers.
The AVERAGE function returns the average (arithmetic mean) of the numbers provided.=AVERAGE(number1,number2,...number_n)number1, number2, ... number_n are numeric values. They can be numbers, named ranges, arrays, or references to numbers. You can enter up to 30 values.
Excel formulas that will find the average of cells A1, A2, and A4 are: =AVERAGE(A1 ,A2, A4) or =AVERAGE(A1:A2, A4)
To find the average of a list of numbers, add the numbers and divide by the number of numbers in the list.
The average of n numbers = (sum of n numbers) / (count of n numbers).
2
The four basic operations are:+ for addition- for subtraction* for multiplication/ for divisionTo calculate an average, you can use the average() function. Type:=average(then select a range of cells with the mouse. Finish by closing parentheses.
You may find an amortization calculator for excel at http://office.microsoft.com/en-us/excel-help/using-the-loan-amortization-and-loan-analysis-templates-HA001034640.aspx.
The Edit menu.