In this video of the Excel 2010 Tutorial series, School of Technology Program Coordinator, Justin Denton, describes the average functions in Microsoft Excel 2010. This tutorial video is a great beginning step to your courses in the School of Technology and Design program at Rasmussen College.
Transcript
If we go down to average cost and we'll see just like the equal sum that we are working with, average cost is equals AVG. Open bracket, close bracket, a lot of these the same principles will apply. If I want to find the average cost for all the items that I have, I basically just type equals average.
But if I want to calculate the total cost, I'll type in equals average open bracket. And I'll do that same thing where we selected the cell range. Instead, I'm going to select the cell range within cost. So I'll start with $0.95. Then I'll click and pull down to the $12.99. I'll see my cell range is highlighted with the little squiggly lines that are going on right now. I'll end my formula and hit Enter. And it'll average my cost as $6.61.
