Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities for charting.
Use the project description HERE to complete this activity. For a review of the complete rubric used in grading this exercise, click on the Assignments tab, then on the title Excel Project #3. Click on Show Rubrics if the rubric is not already displayed.
Summary
Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities for charting. The charts will be copied into a Microsoft PowerPoint file and the student will develop appropriate findings and recommendations based on analysis of the data.
A large rental car company has two metropolitan locations, one at the airport and another centrally located in downtown. It has been operating since 2015 and each location summarizes its car rental revenue quarterly. Both locations rent four classes of cars: economy, premium, hybrid, SUV. Rental revenue is maintained separately for the four classes of rental vehicles.
The data for this case resides in the file summer2019rentalcars.txt and can be downloaded by clicking on the Assignments tab, then on the data tile name. It is a text file (with the file type .txt).
Do not create your own data, you must use the data provided and only the data provided.
Default Formatting. All labels, text, and numbers will be Arial 10, There will be $ and comma and decimal point variations for numeric data, but Arial 10 will be the default font and font size.
Year Quarter Location CarClass Revenue NumCars
2017 Q1 Downtown Economy 955340 5992
2017 Q1 Airport Economy 1023868 5680
2015 Q3 Downtown Economy 786907 5313
2016 Q4 Airport Economy 937999 5156
2016 Q1 Downtown Economy 734280 4839
2015 Q3 Airport Economy 717241 4688
2016 Q4 Downtown Economy 719879 4569
2016 Q3 Downtown Economy 695970 4491
2016 Q2 Downtown Economy 655116 4260
2015 Q4 Airport SUV 631293 4078
2015 Q4 Airport Economy 625827 4075
2015 Q4 Downtown SUV 609073 4062
2016 Q3 Airport SUV 672559 4061
2017 Q1 Airport SUV 694337 3968
2017 Q2 Airport SUV 706080 3963
2015 Q4 Airport Hybrid 648294 3943
2015 Q4 Downtown Hybrid 609455 3914
2016 Q3 Airport Hybrid 673030 3896
2015 Q4 Airport Premium 648717 3862
2017 Q1 Airport Hybrid 693613 3858
2016 Q3 Airport Premium 672695 3853
2017 Q2 Airport Hybrid 705958 3827
2015 Q4 Downtown Premium 609781 3826
2017 Q2 Airport Premium 706252 3773
2017 Q1 Airport Premium 694130 3769
2016 Q2 Airport SUV 612423 3756
2016 Q2 Airport Hybrid 612038 3626
2016 Q1 Airport SUV 578060 3600
2017 Q2 Downtown Economy 587507 3580
2015 Q3 Downtown SUV 528259 3580
2016 Q2 Airport Premium 612737 3535
2016 Q3 Airport Economy 606904 3534
2016 Q1 Airport Hybrid 578032 3495
2015 Q4 Downtown Economy 519897 3439
2015 Q3 Downtown Hybrid 528028 3426
2016 Q1 Airport Premium 578281 3401
2015 Q3 Downtown Premium 527862 3365
2015 Q2 Airport Economy 491053 3323
2016 Q1 Airport Economy 509983 3282
2015 Q2 Downtown SUV 476686 3264
2015 Q1 Airport Economy 459373 3247
2016 Q2 Downtown SUV 511389 3239
2016 Q4 Airport SUV 552365 3220
2015 Q3 Airport SUV 493341 3190
2016 Q3 Downtown SUV 506157 3186
2017 Q2 Airport Economy 608327 3166
2016 Q2 Downtown Hybrid 511499 3162
2015 Q2 Downtown Hybrid 476875 3125
2016 Q4 Airport Hybrid 552888 3107
2016 Q2 Downtown Premium 511239 3093
2015 Q2 Downtown Premium 476477 3087
2015 Q3 Airport Hybrid 494215 3082
2016 Q4 Airport Premium 552173 3075
2016 Q3 Downtown Hybrid 505438 3058
2016 Q3 Downtown Premium 505355 3001
2015 Q3 Airport Premium 493845 2999
2016 Q1 Downtown SUV 433969 2800
2015 Q2 Downtown Economy 387772 2744
2016 Q1 Downtown Hybrid 434387 2731
2015 Q1 Downtown Economy 366539 2714
2016 Q4 Downtown SUV 440417 2711
2017 Q1 Downtown SUV 441608 2699
2016 Q1 Downtown Premium 434087 2666
2016 Q4 Downtown Hybrid 440531 2626
2017 Q1 Downtown Hybrid 442145 2573
2016 Q4 Downtown Premium 441165 2570
2017 Q1 Downtown Premium 442215 2558
2015 Q1 Downtown SUV 362575 2521
2015 Q1 Airport SUV 367887 2497
2015 Q1 Downtown Hybrid 362479 2432
2015 Q1 Airport Hybrid 367637 2413
2015 Q1 Downtown Premium 362201 2395
2015 Q1 Airport Premium 367216 2349
2016 Q2 Airport Economy 376314 2172
2015 Q2 Airport SUV 309815 2049
2015 Q2 Airport Hybrid 310231 2006
2017 Q2 Downtown SUV 337049 1980
2015 Q2 Airport Premium 309858 1958
2017 Q2 Downtown Hybrid 336498 1936
2017 Q2 Downtown Premium 337130 1901