this homework requires excel usage. I will be glad if you help. Thanks

Part 2 1 2 Part 3 1 2 3 Answer the following questions. (This part is independent from other parts.) Combine the brand, color and energy efficiency of the product with the largest discount rate as follows - brand / color / energy efficiency. (For example: Canny / Black / C) Discounted price: The Adams family wins a 30% discount coupon as a result of the lottery. Find the discounted price of the cheapest product they have purchased, and the product's ID. (Apply 30% discount on the current discounted price) Product D: There is additional discount in some of the products. Please create a new column to find and report the total prices in regards to the conditions defined in the questions. (In the new column, there should be discounted prices, if there is a product that does not meet the requirements specified in the question, its price should remain the same, you should put the summation of the values that are in the new column to the answer sheet. Each question is separate from each other.) For products with a Discount Rate of O and Energy Efficieny is C, 10% discount will be applied. For both Washing Machines and Fridges, if the guarantee is over 10 years, 15% discount will be applied. (Discount will be an addition if there is already a discount, for example if there is already 5% discount, new discount rate is 20%.) For the products that have a Discounted Price lower or equal to 9,000, or an NPS score of 7 or higher, 20% discount will be applied. (Discount will be an addition if there is already a discount, for example if there is already 5% discount, new discount rate is 25%.)