Open up the Excel file you created for the previous deliverable, which you named “D3 – Your Business Name” and save it as “D4 – Your Business Name”. The new Excel file should meet the following requirements: (My D3 file is attached below)1. On the Customer Purchases sheet, all values in the column Order Amount that exceed some threshold that you choose should be automatically highlighted.2. On the Customer Purchases sheet, include a table, preferably below the part of the sheet that contains customer information, that counts the numbers of customers in Tampa, and the number of customers in Sarasota.3.On a new sheet, show how often a particular payment type was used in each city. Rename the sheet “Payment Type by City”. Include your logo on the sheet, and the title “Payment Type by City”.4. On a new sheet to be called “Orders by City” show the sum of Order Amount for each city on a new sheet, and include your logo on the sheet and the title “Most Profitable City”. Include a column chart on the sheet that shows the total sales by city and a pie chart that shows the distribution of sales between cities.5. Create a Power Point file called “D4 – Order Totals”. The Power Point slide should meet the following requirement:The file should two slides, one that shows the column chart that you created in 4 and a second one that shows the pie chart.