Home -> Editing ->AutoSum Exam 77-882: Microsoft Excel 2010 Core 5. Applying Formulas and Functions 5.1. Create formulas: Use SUM, COUNT, COUNTA, AVERAGE, MIN, and MAX: SUM

AutoSum How Much Does It Cost? AutoSum creates the equation: =Sum(B2:B5). In real words, that means: add up all the numbers in cell B2 through B5 for the apples, basket, bow and box.   Before You Begin: Look on the Home Ribbon for the Sum button. It looks like the Greek letter S, or sigma. When you roll your mouse over the toolbar, the tool tip says, “Sum.”   1.Try This: Calculate the Wholesale Cost Select Cell B6. Go to Home -> Editing ->AutoSum.   The wholesale price should be $8.50. 2. Try This: Calculate the Retail Cost Select Cell D6, and then click on the AutoSum. Did you get $12.75?   Memo to Self: Click on the Enter key on your keyboard to finish the equation and see the results. Microsoft Excel won’t calculate until you leave the cell.