Question
5. Change the Bounds Axis Options as follows: a. Change the Minimum Bounds of the vertical axis to 1,000,000 and leave the Maximum Bounds at
5. Change the Bounds Axis Options as follows:
a. Change the Minimum Bounds of the vertical axis to 1,000,000 and leave the Maximum Bounds at 2,000,000.
b. Change the Number format of the vertical axis to Currency with 0 Decimal places and $ as the Symbol.
c. Change the Minimum Bounds of the horizontal axis to 3,000 and the Maximum Bounds to 5,000.
6. Create two scenarios to compare the costs for standard consultants and consultants with change certification as follows:
a. In the Scenario Manager, add two scenarios using the data shown in bold in Table 1 below.
b. The changing cells for both scenarios are the nonadjacent cells B11 and B14.
c. Close the Scenario Manager without showing any of the scenarios. Table 1: Organizational Change Scenario Values Values Scenario 1 Scenario 2 Scenario Name Standard Certified Variable_Cost_Per_Hour_Change (B11) 380 420 Total_Fixed_Cost_Change (B14) 380,000 335,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started