Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a . Change the Minimum Bounds of the vertical axis to - 3 0 , 0 0 0 and let the Maximum Bounds change automatically

a. Change the Minimum Bounds of the vertical axis to -30,000 and let the Maximum Bounds change automatically to 130,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 700 and the Maximum Bounds to 1500.
6. Create two scenarios as follows to compare the costs of hiring fitness instructors with those for hifing cer personal trainers while increasing the number of hours provided:
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 C4, C11, and C14.
c. Close the Scenario Manager without showing any of the scenarios.
\table[[Values,Scenario 1,Scenario 2],[Scenario Name,Instructors,Trainers],[Hours_Sold_Consultion, (C4),1500,1800],[Kariableu Cost. Per_Houc_Consulting (C11),53,55],[Total Fixed Cost Consultion (C14),34500,35.500]]
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

compare and contrast 3 models of organiztion design

Answered: 1 week ago