All-in-One Exam Prep Platform
Home
Important MCQs
Past Papers
Subject Wise
All Category
×
English
Urdu
The formula = (B3+B4+B5+B6)/4 would have the same result as the function _______?
The formula = (B3+B4+B5+B6)/4 would have the same result as the function _______?
=SUM (B3:B6)
=AVERAGE (B3:B6)
=MAX (B3:B6)
None of these
Explanation
The
AVERAGE
function calculates the mean of the values in the range
B3 to B6
.
It gives the same result as
dividing the sum of the values by 4.