0
There are a few ways. It is a Statistical function, so it is in that group of functions. You could also click on the Autosum button and choose Average from it. You can just type it in rather than having to look for it.
Wiki User
∙ 11y ago
Wiki User
∙ 8y agoYou can type it in. It is also found in the Statistical functions category. You also click on the arrowhead on the side of the AutoSum button and choose the Average function from there too.
Wiki User
∙ 9y agoIt gets the arithmetic mean, which is the total of the numbers, divided by the amount of numbers.
Add your answer:
Earn +20 pts
Where do you find the Average function on Excel?
If you go to Insert Function, you will find it in the Statistical Functions category. You can also get it through the Autosum in versions from 2007 onwards.
How many arguments can the average function have?
The AVERAGE function has up to 255 arguments in Excel.
Does the total function sum the numbers in the specified range and then divides the sum by the number of nonzero cells in the range?
To be technically accurate, no function does this. The answer you are looking for is the AVERAGE function. It divides by the amount of cells that have values in them, not by the amount of cells. In most situations, all of the selected cells have values in them, but there are cases when they don't.
How do you average Excel times?
Times in Excel can be averaged using the AVERAGE function. So if you have a list of time in the cells from A2 to A13, the function would be: =AVERAGE(A2:A13)
What Excel function sums values and then divides by the number of values?
The AVERAGE function.
Name a search function within Excel?
There is a function called FIND and a function called SEARCH in Excel. There are other functions that can be used to find things, such as the various lookup functions.
Which function is similar to the Find and Replace feature in excel?
the SUBSTITUTE function
Can you enter a function in Excel using autocomplete?
You can use the clipboard in Excel. It is a facility as opposed to a traditional function, like the SUM function or AVERAGE or MAX and other functions that are built in to Excel.
What is used to locate a string in excel?
You can use the find command of the FIND function.
What is a function to find the number of values in cells?
In Excel is it COUNT.
What is an excel function such as AVERAGE that is useful to analyze a group of measurements?
Statistical Functions
What can be used to find an Excel function by typing a description of the formula?
You can use the Insert Function button fx on the Formula bar to find an Excel function by typing a description of the formula at the Insert Function dialog box, in the Search for a function text box and then click Go.
