Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.1 Apply Cell Ranges and References In Formulas and Functions

Calculate the Bonus Now, we can calculate the bonus for each sales rep. Each sales rep's Total is entered in Column B. The VLookup formula looks up the right Commission in the Sales table.   7. Try it: Calculate the Bonus Select Cell D2. Enter the following equation: =B2*C2.   Try This, Too: AutoFill the Formula Select Cell D2. Use to AutoFill handle to copy the formula from Cell D3 through D5.   What Do You See? The formula in Cell D5 is =B5*C5.   Memo to Self: ### means you have too much money. Technically, the column is not wide enough to display the numbers correctly You can make the column wider if you wish.