Question

What will be the value of the following MS Excel formula? 

=AVERAGE(5, 4, 4, 3, 6) 

1. 5 
2. 3.72 
3. 4.4
4. ERROR

Answer 1

Correct Answer - Option 3 : 4.4

The correct answer is 4.4.

• 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

• 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.