Excel 2010 Tutorial - Average Functions

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.


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.


External links provided on Rasmussen.edu are for reference only. Rasmussen College does not guarantee, approve, control, or specifically endorse the information or products available on websites linked to, and is not endorsed by website owners, authors and/or organizations referenced.

Kendall Bird is an Online Community Specialist for Rasmussen College. With her Bachelor’s degree in public relations and a passion for social media, she enjoys writing motivating and enthusiastic blog content to encourage future, current and former students to learn more about their discipline of study. Kendall’s ultimate goal is to generate a positive community through blogging to promote learning and change lives.

comments powered by Disqus