Question

1. Enter your quantity and total cost data into your Excel spreadsheet. You should be starting with a table that looks like this:

Q	TC
0	27
1	30
2	32
3	35
4	38
5	42
6	48
7	57
8	68

2. Create a third column for ATC with the appropriate formula to determine the cell contents – but, after you have done so, ** delete the first cell of the ATC column, where 27/0 is an undefined number **.
3. Create a fourth column for MC, once again using the appropriate formula, and a fifth column for price.
4. Use your cursor to highlight the entire contents of your table, including the column-headers row, and from the “Insert” tab choose “Recommended Charts,” then “Line.”
5. Right-click on the chart that is produced, and then click “Select Data.” Remove the TC curve by selecting it from among the various series and clicking the “-“ sign. Thus you will be left with a graph of only the ATC, MC, and price curves.
6. Click on the Chart Title to label it as you see fit.
7. Copy the entire chart and paste into this document.]

Answer 1