Now we will use the ROUND function ROUND Function ROUND is a built-in Excel function that calculates the round number of a given number using the number of digits as an argument. We get the following result.Īs we can see that we have got values in decimal for average marks, which doesn’t look good.
We will use Ctrl+D to copy down the function.Īpply the above formula to all the remaining cells. We will select marks scored by a student in all 5 subjects. We can pass arguments to this function in the same way as we pass arguments to the SUM function.įor evaluating the average in the excel mark sheet, we will use the AVERAGE function in the following way. This function returns the average of its arguments. The syntax for the AVERAGE function is the same as the SUM function. #2 – AVERAGE Functionįor calculating Average Marks, we will use the AVERAGE function. We can select continuous cells or specify the range with the colon manually.Īfter entering the formula for the first student, we can copy down the formula using Ctrl+D as a shortcut key after selecting the range with the first cell at the top so that this formula can be copied down.Īpply the above formula to all the remaining cells. In this method, we have used the ‘Shift’ key after selecting the first cell (E3) and then used the Right Arrow key to select cells until I3. We have specified or selected various cells with commas.
In this method, we use commas for specifying and separating the arguments.