Exam 77-420 Microsoft Excel 2013
4. Apply Formulas and Functions
4.2 Summarize Data with Functions: SUM

 

graphic2
graphic3
graphic1

AutoSum the Total Sales

What is the sum of all the products sold?  Here are the steps to calculate the total sales.

 

Try it: AutoSum the Revenue

Select Cell E25

Go to Home ->Editing->AutoSum.

 

Excel will enter the formula:

=SUM(E2:E24)

 

Click ENTER on your keyboard.

 

What Do You See? In the example on this page the Sum is $5,347.50.

Home ->Editing->AutoSum