Question: 1. Download and open the Lab What-if spreadsheet. 2. Insert one row at the top. In cell C1 add the label: Estimated Growth rate and
1. Download and open the Lab What-if spreadsheet. 2. Insert one row at the top. In cell C1 add the label: Estimated Growth rate and in cell D1 enter 12%. 3. In cell C3 enter the label Estimated 2015 sales. 4. In cell C4 enter a formula to calculate the estimated sales for 2015. 5. Copy the formula in cell C4 to all the cells C5 to C12. 6. Enter an appropriate function to calculate the totals in cells B13 and C13. Answer What-If Questions Use your spreadsheet to answer the following what if questions and submit the answers as text online below. (Also, upload the completed spreadsheet) 1. What is the total sales if the growth rate drops to 6%? 2. What is the total sales if the growth rate increases to 15%? 1. Download and open the Lab What-if spreadsheet. 2. Insert one row at the top. In cell C1 add the label: Estimated Growth rate and in cell D1 enter 12%. 3. In cell C3 enter the label Estimated 2015 sales. 4. In cell C4 enter a formula to calculate the estimated sales for 2015. 5. Copy the formula in cell C4 to all the cells C5 to C12. 6. Enter an appropriate function to calculate the totals in cells B13 and C13. Answer What-If Questions Use your spreadsheet to answer the following what if questions and submit the answers as text online below. (Also, upload the completed spreadsheet) 1. What is the total sales if the growth rate drops to 6%? 2. What is the total sales if the growth rate increases to 15%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
