Can we find the average of more than one range of cells? If yes what will be the structure of such functions?
Answers
Answered by
17
Answer:
I hope it will help you.....
Explanation:
Attachments:
Answered by
15
Yes, any one can calculate the average of more than one range of cells. The synax to do this is as follows:
Explanation:
The syntax to define the average of more than one range is "Average(range1;range2;range3;...;rangeN)", where N can be any positive natural number.
- The range is used to define more than one value. Just for example "N1: N6" states the range from N1 to N6 including the value of N2, N3, N4, and N5.
- If there is a need to define the more ranges in the MS-Excel worksheet, then it can be done with the help of the above-defined syntax.
Learn More:
- MS-Excel : https://brainly.in/question/9086619
Similar questions