Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a two - variable data table to calculate the gross profit based on the hours of fitness training provided and the hourly rate charged:
Create a twovariable data table to calculate the gross profit based on the hours of fitness training provided and the hourly rate charged:
a For the range E:L create a twovariable data table using the hourly rate charged cell C as the Row input cell.
b Use the hours of fitness training provided cell C as the Column input cell.
c Apply a custom format to cell E to display the text HoursRate in place of the cell value.
Switch to the Consulting worksheet. Create a Scatter with Straight Lines chart based on the range E:G in the data table titled Consulting BreakEven Analysis.
Modify the new chart as follows:
a Resize and reposition the chart so that it covers the range E:H
b Remove the chart title from the chart.
c Add Sales and Expenses as the vertical axis title and Hours as the horizontal axis title.
Change the Bounds Axis Options as follows:
a Change the Minimum Bounds of the vertical axis to and let the Maximum Bounds change automatically to
b Change the Number format of the vertical axis to Currency with decimal places and $ as the symbol.
c Change the Minimum Bounds of the horifgontal axis to and the Maximum Bounds to
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