Desiree Tuazon Class/Section: IFSM 201 6364 Project: Excel Project 1 Date Due:

In the Airport worksheet, a. add a new column head AvgRev that calculates the Average Revenue for a row, b. add a formula to calculate the AvgRev by dividing the Revenue by the NumCars for all rows in the table, and c. use 2 decimal points in the values. d. Column adjustment may be needed to insure both the title and the data is visible. e. Use the formatting instructions in the Comments. 

The format of the table should be extended to the new column. Use the following text format: Arial 10 point Bold Insure all of the data values for AvgRev are Currency Format (using the Format Cells option). 

In the Airport worksheet, a. range named AE that includes every AvgRev value for Economy cars, and b. build a range named AP that includes every AvgRev value for Premium cars. 

AE stands for Airport Economy, AP stands for Airport Premium. 

In the Airport worksheet, a. on the third row below the final row of the data, b. build a label called Average Quarterly Revenue per Economy Car (Airport). c. Use the formatting instructions in the Comments. 

Use the following text format: Arial 10 point Bold 

In the Airport worksheet, a. in the first fully visible cell to the right of the label, b. calculate the Average Quarterly Revenue per Economy Car (Airport) using the average function and the named range AE. Insure the Average is Currency format with two decimal points. No credit will be awarded if anything other than AE as the function range is used instead of the named range. 

Use the following text format: Arial 10 point Normal 

In the Airport worksheet, a. on the fourth row below the final row of the data, b. build label called Average Quarterly Revenue per Premium Car (Airport). c. Use the formatting instructions in the Comments. 

Use the following text format: Arial 10 point Bold 

In the Airport worksheet, a. in the first fully visible cell to the right of the label, b. calculate the Average Quarterly Revenue per Premium Car (Airport) c. using the average function and the named range AP. Insure the Average is Currency format. d. Use the formatting instructions in the Comments. No credit will be awarded if anything other than AP as the function range is used instead of the named range. 

Use the following text format: Arial 10 point Normal 

20 In the Airport worksheet,

Requirement Points Allocated 

Comments 

a. build bar chart that clearly shows the average revenue per economy car versus the quarter for 2015. b. Provide an internal chart title that explains what is portrayed on the graph. c. Place the chart to the right of the data. 

In the Airport worksheet, a. build bar chart that clearly shows the average revenue per premium car versus the quarter for 2015. b. Provide an internal chart title that explains what is portrayed on the graph. c. Place the chart to the right of the data and below the first chart. 

For the questions below, present your answers in a very readable format under the data. These answers may be placed on the page below your chart if there is not sufficient room on page 1. Do not let the answers be "split" over more than one page. You can type answer in one cell (in Column A), then highlighting and selecting several rows and columns, selecting merge cells and selecting Wrap Text. Do NOT widen the columns as this will adversely impact the appearance of the data above. You will want to change the text from Center to Left justification. Play with this a bit. If you simply type answer on a single line in Column A, that will also be ok. But be sure the entire answer can be read without the reader having to change any formatting. 

Question1: Is there a trend that is shared between the Economy and Premium average revenue per car based on the two graphs? Along with the yes or no explain why there is or why there is not a trend. 

a. Label your response Question 1. Answer this question in 2 to 3 sentence after the average revenue per premium car (airport). DO NOT change your spreadsheet. Just respond to the question. (1.0) b. Readability, format and location (0.2) 

1.2

Use the following text format: 

Arial 10 point 

Normal/Black 

Align text left in the cell 

Position on worksheet 

Question 2: Explain one possible cause for the average revenue per share in Q3. The answer should relate to both economy and premium cars. 

a. Label your response Question 2. Answer this question in 2 to 3 sentence in a new row under your response to Question 1. DO NOT change your spreadsheet. Just respond to the question. (1.0) b. Readability, format and location (0.2) 

1.2 

Use the following text format: 

Arial 10 point 

Normal/Black 

Align text left in the cell 

I need it in the next 30 minutes. Thank you