Question: Perform What - If Analysis by changing the Advertising % under Assumptions from 1 0 % to 1 5 % Copy the new Total Expenses
Perform WhatIf Analysis by changing the Advertising under Assumptions from to Copy the new Total Expenses and Profit Loss rows and paste them under the Option Heading rows and Note: You need to "Paste Special" and use Values and Number formats. Change the Advertising under assumptions back to Be sure the values under Option do not change Perform What If Analysis again, this time by changing the Sales Force under Assumptions from to Copy the Total Expenses and Profit Loss rows and paste them under the Option Heading rows & See note in step Change the Sales Force back to Use a function in cell B 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
