Question: Perform What - If Analysis by changing the Advertising % under Assumptions from 1 0 % to 1 5 % Copy the new Total Expenses

Perform What-If Analysis by changing the Advertising % under Assumptions from 10% to 15% Copy the new Total Expenses and Profit /Loss rows and paste them under the Option1 Heading (rows 34 and 35). Note: You need to "Paste Special" and use Values and Number formats. 16. Change the Advertising % under assumptions back to 10%(Be sure the values under Option 1 do not change).17. Perform What -If Analysis again, this time by changing the Sales Force % under Assumptions (826) from 10% to 18% Copy the Total Expenses and Profit/ Loss rows and paste them under the Option Heading ( rows 38 & 39). See note in step 1518. Change the Sales Force back to 10%19. Use a function in cell B4 to display the current date. (you may need to format so that only the date appears )

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 Programming Questions!