Assignment

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 file Excel Project-Data.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).

Attachment:- Project-Data.rar