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

Summation In MS Excel 2007

Dear Readers,
Taking into consideration, all the mails that we have been receiving from you, we will be coming up with short and easy tutorials on Microsoft Excel 2007 functions for naïve users. Watch out for our new series.
Let's start by the easiest and most used function: Summation! A simple excel function which most of us use and at the same time this has been a challenge faced by a lot of users who are new to Excel and its features. Let's understand, how you can perform summation of a particular data. Consider the data shown below, as an example.
Now if you want to find out the total amount that is to be paid, you would need to perform the "sum" function. The formula is simple and goes like this (as shown below):
=sum(range)
Once the range is selected, then press "enter" on your keyboard and you will get the desired output or the total cost to be paid.
That is all to the SUM function. Shoortcut: The shortcut for the sum function is "Alt + = " (without the quotes). Hitting these keys, will activate the SUM function and select the range, automatically.
4 comments:

I am quite interesting in this topic hope you will elaborate more on it in future posts.
mba


@Amit:
Sure, do let us know what would you like us to give a tutorial on. We will try and get it in one of our future posts.


Dummys essentials is the key.Currently I'm running a blog sites that consist of technology questions and concerns

Please posted your comments:

http://geekstalks.blogspot.com/2010/04/understanding-microsoft-excel-2007.html

https://sites.google.com/a/email.phoenix.edu/geeks-blogs/


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