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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!