CBSE Class 9 Computer Applications
Question 36 of 39
Microsoft Excel 2010 - I — Question 2
Back to all questions 2
Question Question 2
Can we find the average of more than one range of cells? If yes, what will be the structure of such a function?
Yes, we can find the average of more than one range of cells by using the AVERAGE function.
The structure of the AVERAGE function used is as follows:
= AVERAGE (Range1 , Range2, ...)
For example, to find out the average of range B2 : D2 and B3 : D3, we will write the formula as follows:
= AVERAGE (B2 : D2 , B3 : D3)