What will be the value of the following MS Excel formula?  =AVERAGE(5, 4, 4, 3, 6) 

What will be the value of the following MS Excel formula?  =AVERAGE(5, 4, 4, 3, 6)  Correct Answer 4.4

The correct answer is 4.4.

Key Points

• The formula to calculate the average of given numbers is equal to the sum of all the values divided by the total number of values.
• In MS-Excel the format of using the Average formula is
  • ​= Average(number1, number 2, number 3, .....).
• Here, the sum of numbers is 22 and this should be divided by 5.
• Hence the result is 4.4

Additional Information

• SUM(): This function is used to adds all the values within a cell range.
• ROUND(): The round function is used to round a number to a specified number of digits.
• RAND(): This function is used to returns a random number greater than or equal to 0 and less than 1.
• MOD(): This function is used to find the remainder after dividing a number by another number.