Year Quarter Location CarClass Revenue NumCars

2018 Q1 Airport Economy 1011191 5650

2018 Q1 Downtown Economy 943509 5965

2017 Q4 Airport Economy 926382 5122

2016 Q3 Downtown Economy 777155 5280

2017 Q1 Downtown Economy 725178 4802

2017 Q4 Downtown Economy 710955 4529

2016 Q3 Airport Economy 708349 4649

2018 Q2 Airport Premium 697496 3726

2018 Q2 Airport SUV 697326 3918

2018 Q2 Airport Hybrid 697206 3781

2017 Q3 Downtown Economy 687341 4451

2018 Q1 Airport SUV 685728 3923

2018 Q1 Airport Premium 685524 3722

2018 Q1 Airport Hybrid 685013 3812

2017 Q3 Airport Hybrid 664684 3850

2017 Q3 Airport Premium 664353 3807

2017 Q3 Airport SUV 664219 4017

2017 Q2 Downtown Economy 646991 4218

2016 Q4 Airport Premium 640671 3816

2016 Q4 Airport Hybrid 640254 3898

2016 Q4 Airport SUV 623463 4034

2016 Q4 Airport Economy 618064 4031

2017 Q2 Airport Premium 605136 3486

2017 Q2 Airport SUV 604825 3709

2017 Q2 Airport Hybrid 604445 3578

2016 Q4 Downtown Premium 602216 3780

2016 Q4 Downtown Hybrid 601894 3869

2016 Q4 Downtown SUV 601517 4018

2018 Q2 Airport Economy 600780 3114

2017 Q3 Airport Economy 599375 3485

2018 Q2 Downtown Economy 580217 3532

2017 Q1 Airport Premium 571105 3351

2017 Q1 Airport SUV 570887 3552

2017 Q1 Airport Hybrid 570859 3446

2017 Q4 Airport Hybrid 546026 3054

2017 Q4 Airport SUV 545509 3168

2017 Q4 Airport Premium 545319 3022

2016 Q3 Downtown SUV 521701 3532

2016 Q3 Downtown Hybrid 521472 3376

2016 Q3 Downtown Premium 521308 3315

2016 Q4 Downtown Economy 513442 3389

2017 Q2 Downtown Hybrid 505147 3110

2017 Q2 Downtown SUV 505039 3187

2017 Q2 Downtown Premium 504891 3040

2017 Q1 Airport Economy 503650 3231

2017 Q3 Downtown SUV 499871 3134

2017 Q3 Downtown Hybrid 499161 3005

2017 Q3 Downtown Premium 499079 2947

2016 Q3 Airport Hybrid 488077 3029

2016 Q3 Airport Premium 487711 2945

2016 Q3 Airport SUV 487214 3138

2016 Q2 Airport Economy 484954 3272

2016 Q2 Downtown Hybrid 470951 3072

2016 Q2 Downtown SUV 470764 3213

2016 Q2 Downtown Premium 470558 3034

2016 Q1 Airport Economy 453665 3196

2018 Q1 Downtown Premium 436719 2500

2018 Q1 Downtown Hybrid 436650 2515

2018 Q1 Downtown SUV 436119 2643

2017 Q4 Downtown Premium 435682 2512

2017 Q4 Downtown Hybrid 435056 2569

2017 Q4 Downtown SUV 434943 2655

2017 Q1 Downtown Hybrid 428988 2675

2017 Q1 Downtown Premium 428691 2609

2017 Q1 Downtown SUV 428575 2744

2016 Q2 Downtown Economy 382948 2688

2017 Q2 Airport Economy 371631 2111

2016 Q1 Airport SUV 363309 2439

2016 Q1 Airport Hybrid 363062 2354

2016 Q1 Airport Premium 362646 2289

2016 Q1 Downtown Economy 361977 2658

2016 Q1 Downtown SUV 358062 2463

2016 Q1 Downtown Hybrid 357967 2373

2016 Q1 Downtown Premium 357693 2336

2018 Q2 Downtown Premium 332931 1837

2018 Q2 Downtown SUV 332851 1917

2018 Q2 Downtown Hybrid 332307 1873

2016 Q2 Airport Hybrid 306364 1943

2016 Q2 Airport Premium 305996 1895

2016 Q2 Airport SUV 305953 1987

please share a link, so i can download.

Year Quarter Location CarClass Revenue NumCars

2018 Q1 Airport Economy 1011191 5650

2018 Q1 Downtown Economy 943509 5965

2017 Q4 Airport Economy 926382 5122

2016 Q3 Downtown Economy 777155 5280

2017 Q1 Downtown Economy 725178 4802

2017 Q4 Downtown Economy 710955 4529

2016 Q3 Airport Economy 708349 4649

2018 Q2 Airport Premium 697496 3726

2018 Q2 Airport SUV 697326 3918

2018 Q2 Airport Hybrid 697206 3781

2017 Q3 Downtown Economy 687341 4451

2018 Q1 Airport SUV 685728 3923

2018 Q1 Airport Premium 685524 3722

2018 Q1 Airport Hybrid 685013 3812

2017 Q3 Airport Hybrid 664684 3850

2017 Q3 Airport Premium 664353 3807

2017 Q3 Airport SUV 664219 4017

2017 Q2 Downtown Economy 646991 4218

2016 Q4 Airport Premium 640671 3816

2016 Q4 Airport Hybrid 640254 3898

2016 Q4 Airport SUV 623463 4034

2016 Q4 Airport Economy 618064 4031

2017 Q2 Airport Premium 605136 3486

2017 Q2 Airport SUV 604825 3709

2017 Q2 Airport Hybrid 604445 3578

2016 Q4 Downtown Premium 602216 3780

2016 Q4 Downtown Hybrid 601894 3869

2016 Q4 Downtown SUV 601517 4018

2018 Q2 Airport Economy 600780 3114

2017 Q3 Airport Economy 599375 3485

2018 Q2 Downtown Economy 580217 3532

2017 Q1 Airport Premium 571105 3351

2017 Q1 Airport SUV 570887 3552

2017 Q1 Airport Hybrid 570859 3446

2017 Q4 Airport Hybrid 546026 3054

2017 Q4 Airport SUV 545509 3168

2017 Q4 Airport Premium 545319 3022

2016 Q3 Downtown SUV 521701 3532

2016 Q3 Downtown Hybrid 521472 3376

2016 Q3 Downtown Premium 521308 3315

2016 Q4 Downtown Economy 513442 3389

2017 Q2 Downtown Hybrid 505147 3110

2017 Q2 Downtown SUV 505039 3187

2017 Q2 Downtown Premium 504891 3040

2017 Q1 Airport Economy 503650 3231

2017 Q3 Downtown SUV 499871 3134

2017 Q3 Downtown Hybrid 499161 3005

2017 Q3 Downtown Premium 499079 2947

2016 Q3 Airport Hybrid 488077 3029

2016 Q3 Airport Premium 487711 2945

2016 Q3 Airport SUV 487214 3138

2016 Q2 Airport Economy 484954 3272

2016 Q2 Downtown Hybrid 470951 3072

2016 Q2 Downtown SUV 470764 3213

2016 Q2 Downtown Premium 470558 3034

2016 Q1 Airport Economy 453665 3196

2018 Q1 Downtown Premium 436719 2500

2018 Q1 Downtown Hybrid 436650 2515

2018 Q1 Downtown SUV 436119 2643

2017 Q4 Downtown Premium 435682 2512

2017 Q4 Downtown Hybrid 435056 2569

2017 Q4 Downtown SUV 434943 2655

2017 Q1 Downtown Hybrid 428988 2675

2017 Q1 Downtown Premium 428691 2609

2017 Q1 Downtown SUV 428575 2744

2016 Q2 Downtown Economy 382948 2688

2017 Q2 Airport Economy 371631 2111

2016 Q1 Airport SUV 363309 2439

2016 Q1 Airport Hybrid 363062 2354

2016 Q1 Airport Premium 362646 2289

2016 Q1 Downtown Economy 361977 2658

2016 Q1 Downtown SUV 358062 2463

2016 Q1 Downtown Hybrid 357967 2373

2016 Q1 Downtown Premium 357693 2336

2018 Q2 Downtown Premium 332931 1837

2018 Q2 Downtown SUV 332851 1917

2018 Q2 Downtown Hybrid 332307 1873

2016 Q2 Airport Hybrid 306364 1943

2016 Q2 Airport Premium 305996 1895

2016 Q2 Airport SUV 305953 1987

pls share a link (google drive etc) so that i can download the solution. thanks

review of the complete din grading this exercise click on the A g Tor t2 Cick on Show Rubric the rubric is not ready stayed ents when the Create a Microcal work for a prom ote including charting and written analysis and recommendations in of abus A borgerental car company has wompanie d Bohotin our c olar economy.premum hond, SUN R A more then on the data frame is where Deforming A usland w decimal w ariations for numeric data. but Ara b here e the front and font Change theme of the worst Analysis by inte Analysis by ons Alone per the following userName the colo Align the r each bol other in the ayon Ang Column a r e for your Name Chacross from the progra m Use the formating in the Commerc e maybe y o u with the four we are cominending ochy Ayisyen Profi Arking on the Alc he Date Retourenfoma NO ce n tre and the num Theo Though the sto import the best in the Duta worksheet wom e s when it is imported into a workshee new work . The change the name of the new world with the imported Make sure worth the comes Requirement choose a style that shows Banded rows.le.rowth rate between 2 colors Erre N etoftheweeg Err o w and the Table Style Options Group Box, but do NOT Data 2015 Located of the Phil head of from Puas the DO NOT EACH Our refour car and Grand Tooted in the proble Create a co r tar type of char that shows the v eforench of the four eyes Adidate that reflects the information presented by the chart The per la comer of the chan should be one or two rows below the above referenced and w ined with the pivota Create a cont r at shows the w ho four Adidatures the wormation presented by the chart The comer of the car houdbrewrows below the above referenced pivot table and and with d. The c ho i ce and type of table format. Then we should be placed on the page bow the w h o he t er over more than one you can d engandung We Do NOT recom m erce of the You gehefrom Carto on which Gu and t e combined producten wione Question location and is on the a b ove, which common for 20 and 2017 combined produced the your response Question 2 Use the following . A in Analysis worksho Inow and the themmediate Num e fotels in the wing the b each at the top of a column D ecay truncation The Erwehoud e nded the columns to the right in the Profi An is worth w e can do the DO NOT w ith for the The moes we were Penis in Profil Analysis works - Currency www termined from the use wore DO NOT the counce by At Expenses a coresponds to the number of cars IN THAT ROW Numarsinan P ertas part of Expenses by comparing the values in the con and conded the com Cars bythe d oom with a demon Requirement Create a volte in 2015 and 2017 Locate the patie of the Protein Rowland Declay the role or four years of which four columns Pu Cars in the course of the the Pacation in the Row and colum. c o m hohe Care nthe Fom DO NOT OWN The Boru t he Commun fou n d the Grand o ther of the form everage of EACH on and the average of profese Pow D O NOT PU all boo tions and Grand total below and in four car and the Grand Total to the nohto the Fraps with certo We and want in ROTH 1. For the comment.com Lallion locations and Grand Tobelow and four car and the Grand Tow to the right of the four classes in the pivo bile the Profit Analysis works a Crea t he 2016 and 2017 Postin the upper left come to left align with the live bove and two rows below the pivot be bove vehicles in four columns Put CarClass in the columns the wo d ocations in Put Location in the ro o Rowando. o the awape EACH location and the pro where provanth Photos DO NOT . bohonan Grand We Do NOT G e nce e bed without the reader having to change any forming Reading the on ding door w e were and the surfomfort Question and on the pivo , which of the location produces the greater protinclude the progrend which i s of the four produces the least o nclude the - A Label your response Question 1. Answer this question in 203 Out 2 Based on combination location lower pivote, which s MOST profitable and and one or two rows beneath Summary Create a Microsoft Excel Workbook with four worksheets that provides extensive use of Excel capabilities including charting, and written analysis and recommendations in support of a business enterprise. A large rental car company has two metropolitan locations, one at the airport and another centrally located in downtown. It has been operating since 2016 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 spring 2020rentalcars.txt and can be downloaded by clicking on the Assignments tab, then on the data file 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. Tutorials Note: Tutorials that address activities used in this project have been assigned in Week 1, 2 and 3. Step Comments Requirement Open Excel and save a blank workbook with the following name: a. "Student's LastNameFirstNameInitial Name Excel Project 2 Example: Smith JaneP Excel Project 2. b. Set Page Layout Orientation to Landscape. Use Print Preview to review how the first worksheet would print. Change the name of the worksheet to Analysis by. Format for column A: In the Analysis by worksheet: a. Beginning in Row 1, enter the four labels in column A (