Create a Microsoft Excel spreadsheet with any single worksheet, and perform the following steps

Part 1: Create a Microsoft Excel spreadsheet with any single worksheet, and perform the following steps:

Name the worksheet FirstInitialLastName_Week3IPa (e.g., MRogers_Week3IPa.xls). Create a table with 3 columns. Label the first column "Weekly Trouble Calls -  X," the second column "Salary," and the third column "Income." In the column labeled "Weekly Trouble Calls," enter numbers from 1 to 50, one number per row. Create formulas for the Salary column and Income column to calculate the value of S and I based on the equations above for each of the 50 values of X. Format these 2 columns to be currency, rounded to whole dollars. Create a line graph showing the two lines formed by both equations. Add a  legend  identifying the lines as Salary and Income. Format the axes, if necessary, to avoid a crammed look. For the horizontal axis, specify an interval unit of 5 and choose "Position Axis on Tick Marks."

Part 2: Using text labels, indicate the following information on the graph:

The break-even point The area that represents profit The area that represents loss

CLICK HERE TO ORDER NOW