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
0 comments:
Post a Comment