147k views
5 votes
Enter a formula in cell b7 to calculate the average value of cells b2:b6

User Rktavi
by
8.0k points

1 Answer

4 votes
The answer is =AVERAGE(B2:B6)
Or, you can just go to "HOME" tab, then click the arrow down next to AutoSum, click the AVERAGE, then select B2:B6.
Average, which is also called arithmetic mean,can be calculated manually by adding all the numbers in a set, then dividing the count of the numbers in a set. But, in excel, there are shortcut formulas to calculate it.
User Jack Culhane
by
8.5k points