Calculate the average score in Excel quickly and standardly to serve the documents that need the average calculation. In the following article, TipsMake.com will guide you how to calculate the average score in Excel.
Let's first repeat the definition of the average calculation. An average calculation means that we take the sum of all the elements to average and then divide by the number of elements we have summed.
To calculate the average score, you can also apply that calculation directly to your data, as shown below, you will have to calculate the sum of the three Mathematical Physics Points and divide it by three. From there we have the following calculation for the first line:
= (C2 + D2 + E2) / 3
After using that calculation to average, you can copy that formula down to the average for the following lines.
But if you are a good Excel user, you usually do not use such a direct calculation, simply because it will take time to register the location of the data cell, and you have to count the number of elements. total.
Therefore, to make it simpler, Excel has a separate function for calculating the average score which is AVERAGE function.
The formula of the AVERAGE function is:
= AVERAGE (elements to calculate average score)
In which the elements to calculate the average score may be the elements directly separated by commas or semicolons. Or you can enter the data array containing the elements to calculate the average score.
Accordingly, along with the example that TipsMake gives, we have the formula for calculating the average score as follows:
= AVERAGE (C2: E2)
After pressing Enter you will get the result that is the average of the selected element. Continue to copy the formula in the first line down the back line easily by clicking on the bottom left corner and dragging it down to copy.
You will get the results that are the average points in the data sheet of Excel.
Next to the average score is presented beautifully and neatly with only two numbers after the comma, you click on the comma Style comma icon in the Number section in the Home ribbon of the toolbar.
The average values found will be automatically reduced to only two numbers after the comma.
Thank you for reading the article How to calculate the average score quickly and accurately in our TipsMake.com . Wish you can perform this trick in the most proficient.