(2) Use of Average function in Microsoft Excel.
a. Average: For Average write formula like below
=AVERAGE(RANGE)
Example:
Give the formula in B11 cell.
| Formula |
Description |
Result |
| =AVERAGE(B2:B10) |
here RANGE=B2:B10, you can use any range as per your requirement |
84
|
=AVERAGE(B2,B3,B4,B5,B6,
B7,B8,B9,B10) |
|
84
|
=AVERAGE(85,80,80,85,95,
85,80,80,85) |
|
84
|
Video:
Use of Average function in Microsoft Excel:
|