Excel Average Formula – The average formula is a method used to calculate the number of values in a group of data and then divide by the number of data.
In general, the average value is used to get an overview of the data.
While the average formula that is commonly used is the one found in the Microsoft Excel application which is already well known for its various calculation formulas.
In fact, Microsoft Excel has been widely used by various groups, ranging from students, entrepreneurs, private employees and other professions to complete their assignments and work.
With the Excel average formula, you can more easily calculate the average value that is often encountered in Mathematics.
Excel Average Formula Discussion
For people who don’t understand MS.Excel, they must think that the Excel average formula is very difficult to use.
In fact, the Excel average formula can be used easily and quickly, as long as you understand which menu to use.
If you are one of those people who don’t know or are still confused about how to use the Excel average formula, then we recommend reading this article to the end.
Because we will share how to use the Excel average formula for calculations, instead of small talk, let’s just look at the review as follows.
Excel Average Formula
1. How to Write Excel Functions in Excel’s Average Formula
 |
| How to Write Excel Functions in Excel’s Average Formula |
To calculate the average Excel formula, you will be introduced to syntax or how to write Excel functions, guys.
This Excel function is important to know, because it relates to the formula to be used.
As for how to write Excel functions on the Excel average formula as follows:
- Average, is the name of the Excel function used to calculate the average value.
- The first number that must be filled in and is the cell reference or range for which the average value will be calculated is the number 1.
- Number 2 is optional, meaning it may or may not be filled in. That’s what makes the number 2 is said to be a further additional number or range whose average value will be calculated with a maximum number of 255 cells.
2. How to Use Excel’s Average Formula
 |
| How to Use Excel’s Average Formula |
After reading how to write Excel functions, then you can immediately try how to use the Excel average formula guys.
In this discussion, we will give an example that will start calculating the average number of 20, 30, 20, 10, 30, 10.
- For the first step, please enter the number in column A and write it down starting from A1-A7.
- Then put the cursor to the average value line then write the formula =average(A1:A7) and press enter.
- Then mark all data from column C row 2 to row 11 and put a closing parenthesis then press enter, so that you can enter data more easily, after the =average(,.
The final word
Thus a brief review of the Excel average formula and how to use it.
Before using the formula, it’s a good idea to learn about MS. Excel in more depth first, so that the calculation results are correct and appropriate.
