Create a Microsoft Excel file with four worksheets that provides extensive use of Excel capabilities including creating a pivot table, graphing, 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 attachments below.
Do not create your own data. You must use the data provided and only the data provided. Must be completed by deadline of 10:30 PM EST TONIGHT