Excel 2010 autosum

/a

1. Excel 2010 : AutoSum 1 Excel 2010

2. Excel 2010 2 L earning outcomes Use the AutoSum feature to calculate the sum of the values of multiple cells in a column.

3. Excel 2010 3 W here you can Find Sum Function ? W hat is Sum Function ? Is one of the math & trig functions, adds all of the arguments Click on Functions icon Choose SUM, Click OK OR Click on Formulas tab Click on Functions icon or AutoSum

4. Excel 2010 4 W here you can Find Sum Function ? Continued. OR Home tab, Click on AutoSum Or Press enter BUT ! W hat is AutoSum ? It’s a feature or function in Excel provides you a shortcuts to adding up a columns or rows of numbers in Excel spreadsheet H ow you can use it ? Just click on AutoSum

5. 5 Excel 2010 Adds all the numbers in a range of cells. In Excel: Generally: The total of the numbers in a range of cells Example Find the total budget: Lets try with AutoSum S um in AutoSum Continued .

6. 6 Excel 2010 Select the cells or the column 2. Home tab, Click on AutoSum S um in AutoSum Continued . You also can click on AutoSum it automatically enters Sum function

7. 7 Excel 2010 4. Got the Sum “ Total ” S um in AutoSum Continued . 3. Click on Sum

8. 8 Excel 2010 BUT ! AutoSum includes other formulas YES For w hat y ou can use each one of them ?

9. 9 Excel 2010 AutoSum includes other formulas Continued . Returns the average of its arguments, which can be number or names, references that contain numbers. In Excel: Generally: Is a calculation, adding a group of numbers and dividing them by the count of those number. Example Average age : Lets try with AutoSum

10. 10 Excel 2010 Select the cells or the column 2. Home Tab, AutoSum, Press enter AutoSum includes other formulas Continued .

11. 11 Excel 2010 3. Click on Average 4. Got the Average AutoSum includes other formulas Continued .

12. 12 Excel 2010 AutoSum includes other formulas Continued . Counts the number of cells in a range that contain numbers. In Excel: Generally: It’s a quick way to count number of cells without taking time. Example Count number of cells interred with numbers Lets try with AutoSum

13. 13 Excel 2010 Select the cells or the column 2. Home Tab, AutoSum, Press enter AutoSum includes other formulas Continued .

14. 14 Excel 2010 3. Click on Count Numbers 4. Got the C ount N umber AutoSum includes other formulas Continued .

15. 15 Excel 2010 AutoSum includes other formulas Continued . Returns the largest value in a set of values. Ignores logical values and text. In Excel: Generally: Finds the highest value in a range of cells. Example Find the highest quantity sold Lets try with AutoSum

16. 16 Excel 2010 Select the cells or the column 2. Home Tab, AutoSum, Press enter AutoSum includes other formulas Continued .

17. 17 Excel 2010 3. Click on Max 4. Got the Max AutoSum includes other formulas Continued .

18. 18 Excel 2010 AutoSum includes other formulas Continued . Returns the lowest value in a set of values. Ignores logical values and text. In Excel: Generally: Finds the lowest value in a range of cells. Example Lets try with AutoSum Find the lowest quantity sold

19. 19 Excel 2010 Select the cells or the column 2. Home Tab, AutoSum, Press enter AutoSum includes other formulas Continued .

20. 20 Excel 2010 3. Click on Min 4. Got the Min AutoSum includes other formulas Continued .