Dummy Essentials
A complete source of effective solutions to all your computer problems in simplified manner.

Average In MS Excel 2007

Let us learn how to calculate an average of any data. For this consider the table below:
As we see above we have data for 5 batsmen playing cricket along with the scores in every match. So the consolidated score for 3 matches is available. Now in order to calculate what is the average score for each batsman is, here is how we go about calculating: Put the =average formula and select the range of which you need to take an average. Now press enter and we arrive at the average score for the first batsman as below: As we can see above the average score of 1st Batsman is 50.3 runs. Now in order to calculate for the remaining, just copy & paste the same formula. Here you go. Now we have arrived at the average of the entire list of batsmen. We illustrated above how to calculate row wise, we can do the same column wise too (refer below): And then you can copy and paste the same formula in rest of the columns. Now you can easily calculate the average of any given data.
6 comments:

thanks for the info..... , i was getting trouble on average now its clear for me thanks again.....


Thanks, I always seem to forget these simple things. Will bookmark your post for future reference.


Thanks, I always seem to forget these simple things. Will bookmark your post for future reference.


Thanks for this deemonstration


Post a Comment

Search Dummy Essentials Here:






Visitor's Review

We would appreciate you taking out a little more of your time to rate our blog. It would help us to improve and encourage us to share whatever we get to learn in the process. Thanks!
Bookmark and Share

 Subscribe To Dummy Essentials

Enter Your Email Address & Click On Go:

  
Delivered by FeedBurner

Translate Dummy Essentials

Google-Translate-Chinese (Simplified) BETA Google-Translate-English to French Google-Translate-English to German Google-Translate-English to Italian Google-Translate-English to Japanese BETA Google-Translate-English to Korean BETA Google-Translate-English to Russian BETA Google-Translate-English to Spanish
Powered by Google

Dummy Essentials Visits