Excel Project #2 – Due June 23

Create a Microsoft Excel workbook with four worksheets that provides extensive use of Excel capabilities including creating a pivot table, 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 2015 and each location summarizes its car rental revenue quarterly. Both locations rent two classes of cars: economy and premium. Rental revenue is maintained separately for the two classes of rental vehicles. The data for this case resides in the file summer2018rentalcars.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.