plz do this excel and all point

PROJECT STEPS 1. Camille Beauclaire is a financial analyst for Pet Stop, an online pet supply company in Huntsville, Alabama. Camille is reviewing the recent sales of products and ad campaigns. She asks for your help in using Excel tables to analyze the data. Go to the October Sales worksheet, which lists the products sold in October 2021. Format the October Sales data (range A1:G27) as a table with headers using Olive Green, Table Style Medium 5 so that Camille can summarize and filter the data. Use October as the name of the table. 2 Add a column to the right end of the table and use Total Price as the column heading. n cell H2, enter a formula without using a function that uses structured references to multiply the price per unit (cell G2) by the units sold (cell F2) to find the total price. Fill the range H3:H27 with the formula in cell H2 if Excel does not do so automatically 3 Filter the table using a custom AutoFilter to display products with a Price per Unit amount greater than $25.00. 4. Go to the Proposed Discounts worksheet, which lists products and the discount prices that have been proposed for an upcoming sale in November. Camille notices that the Discounts table has a duplicate record. Clear the filter from the Discounts table to display all the records. Use the Remove Duplicates tool to identify duplicates in the Product ID column and remove the duplicate record. 5. Pet Stop plans to run promotional ads for all dog products with a discount price of more than $30.00. In cell H2, enter a formula using the AND function that includes structured references to display TRUE if a product has a [@[Pet Type]] of "Dog" and a [@[Discount Price]] value >30. Fill the range H3:H16 with the formula in cell H2 If Excel does not do so automatically. 6. Add a Total Row to the Discounts table, which automatically counts the number of Promo Ad values. Using the total row, display the sum of the Current Price and Discount Price amounts