You are the systems manager for Blue City Movies Rentals and you have been asked to create a report on historical sales data. To complete your task you will combine and edit data from multiple sources using Excel’s Power add-ins, XML, and text functions. Instructions:For the purpose of grading the project you are required to perform the following tasks:StepInstructionsPoints Possible1. Open e10c2MovieRentals. xlsx and save the workbook with the name e10c2MovieRentals_LastFirst.2 Import the movie data from the delimited file e10c2Movies. txt and rename the new worksheet Inventory. On the Table Tools Design tab, in the Properties group, ensure that the table name is e10c2Movies (modify it, if necessary).3.Copy the data in the range B2:B26 and paste it in the range G2:G26. Then delete the values in the range B2:B26.4.Enter a function in cell B2 that references the copied value in cell G2 and formats the data with the first letter capitalized. Use the Fill handle to copy the function down to complete the column.5.Copy the range B2:B26 and paste the values back into the range B2:B26 to remove the underlying functions. Then delete the values in Column G. 6.256.Create a new worksheet named Customers.7.Create a connection to the e10c2Contacts. xml file. Select Account, and then load the data to A1 of the Customers worksheet. On the Table Tools Design tab, in the Properties group, ensure that the table name is Account (modify it, if necessary)8.Open e10c2Contacts. xml in Notepad. Locate the spelling error in the first account type siver. Edit the text to say Silver and save the file. Refresh the connection.9.Create a new worksheet named Transactions.10.Use Power Pivot to import the file e10Transactions. accdb into a PivotTable on the Transactions worksheet. On the PivotTable Tools Analyze tab, ensure that the PivotTable name is PivotTable1 (modify it, if necessary).11.Add the Date field from Transactions to the FILTERS area, Account from Account table to the ROWS area, Transaction # to the ROWS area, Last from Account table to the ROWS area, and Total to the VALUES area.12.Create a relationship between the Account fields in Account (Related) and the Transactions (Table) table.13.Get the data from the e10c2Rates. xlsx workbook, and load the data into a new worksheet named Rates. On the Table Tools Design tab, in the Properties group, ensure that the table name is Rates (modify it, if necessary). Apply Currency Number Format to the values in column B.14.Add the Insert a Power View Report button to the Quick Access Toolbar, if necessary. Create a new Power View report. Ensure that the sheet name is Power View1 (rename it, if necessary).15.Create a visualization in the right half of the canvas that displays Date and total earnings (Total) from Transactions, by account type (Type). Set the aggregation settings to Sum, if necessary16.Create a visualization pie chart of number of accounts by account type (both from Account table) in the upper left corner. Set the aggregation settings to Count (Distinct).17.Create a table visualization in the lower left corner that displays the rental cost by account type (from Rates). Add an appropriate title to the Power View.18.Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of each worksheet.19.Save and close the file. Based on your instructor’s directions, submit e10c2MovieRentals_LastFirst. xlsx.