One of the most useful tools of recent times is the Microsoft Office package, mainly its Microsoft Excel program, which allows you to do a large number of things. This is largely due to the fact that it has a large catalog of functions that we can use for our purposes.
In this article we will explain how to average grades or grades using the AVERAGE function in Excel. That way you will be able to know how many you have accumulated to pass a subject. In the same way, you can get the average of all the students you have.
How to Average Grades or Notes Using the ‘Average’ Function in Excel
What functions can you use to get an average?
Excel offers us three functions whose main purpose is to take the average of a set of cells that we select . Each of them requests some parameters that we will have to provide in order to achieve the result we expect. Below we mention each of them so that you are clear about what they are.
As well as these functions, we will be able to find the complete catalog of them in the Microsoft registries ordered by categories . It is also important to know what an average is but how to calculate the arithmetic mean of a set of values . To get an average, the data must be added and divided by the amount of the same.
This is the most basic function for taking an average , because it only asks for the data to be considered in the calculation. To use this function just follow the following steps:
- Within Excel, we will click on the cell where we want the result to be saved.
- We will have to write: “= AVERAGE (“ , without the quotes.
- Next, we can select with the mouse the range of cells where the data to be taken into account are or we can write one by one the cells that we want to be part of the average.
- After selecting all the data, we close the parentheses and press “Enter” . The average of the data we chose will immediately appear.
In this case, the AVERAGEIF function is able to calculate the arithmetic mean considering an implicit condition . To use this function just follow the following steps:
- We select the cell where we want to save the result.
- We will write: “= AVERAGEIF (“ , without the quotes.
- The expression of this function requires that we pass three parameters to it. It has the following form: “= AVERAGEIF (range; criterion; [average range])” .
- In range we will have to select the cells to which we want the criteria to be applied.
- In criteria we will place the implicit condition that we want to take into account when taking the average.
- And in the average range we must place the range of cells where the data to which we will take the average are located.
- After completing all the parameters, we close the parenthesis of the function and press “Enter” .
In the event that we want to apply more than one condition to the average calculation , we will have to use the AVERAGEIFS function so that we can enter all the conditions. The use of this function is as follows, explained step by step:
- We will click on the cell where we want to save the result.
- We will write: “= AVERAGEIF.SET (“ , without the quotes.
- This function requires that we pass at least 5 parameters to be able to produce a result.
- The function expression is the following: “= AVERAGEIF.SET (average_range; criterion_range1; criterion1; criterion_range2; criterion2; …)” . You can enter the amount of ranges and criteria you want.
- In average_range we will have to place all the cells that we want to be part of the calculation.
- In criterion_rango1 we will have to establish the range of cells to which criterion 1 will be applied.
- In criterion1 we will place the condition that we want to apply to the previously established range of cells.
- In criterion_rango2 and criterion2 you must enter both the range of cells to which we want to apply criterion 2 and the same criterion 2 to apply.
- After placing all the ranges and criteria, we close parentheses and press “Enter” .
What else can you do with these features?
Just as we can take the average of a data set, we can also generate random numbers without repetition , if necessary. We can also apply conditional formatting to cells for a better presentation.
Likewise, taking averages we can create an income and expenses control sheet that can help us keep our finances less, be they personal or work.