Please show step by step in EXCEL thank you!

Step Instructions 9. In cell 15, using logical functions, determine whether the product will be an online product. The product will be an online product if it has a ranking of A or B. Set the formula to return a value of Yes if rank was met and a value of No if rank was not met. Copy the formula through 116. Repeat the same formula for the men's clothing lines starting in cell 121, and copy the formula through 132 10 Create a 3-D clustered column chart that represents the women's clothing sales based on each product line and the product line's yearfy sales. Enter a chart title of Women's Clothing Sales. Move the chart so the top left corner of the chart is in cell K10 and the bottom right comer of the chart is in cell Q22. Apply Style 3 to the chart. 11 Create a second 3-D clustered column chart that represents the men's clothing sales based on each product line and the product line's yearly sales. Enter a chart title of Men's Clothing Sales. Move the chart so the top left corner of the chart is in cell K23 and the bottom right corner of the chart is in cell Q3B. Apply Style 3 to the chart. Adjust the vertical axis Bounds and Units of the men's clothing chart to match the vertical axis of the women's clothing chart. 12 Create a clustered column chart to compare the sales percentages of women's and men's clothing sales for all four quarters. Move the chart to a new chart sheet, and name the new worksheet SalesComparison. Position the SalesComparison worksheet to the right the Retail worksheet. Apply Style 4 to the chart. Enter the chart title Sales Comparison. Change the chart title format using WordArt, Pattem Fill-Blue, Accent 1. Light Downward Diagonal, Outline - Accent 1. Note, depending on the version of Office used, the WordArt style name may be Pattern Fill: Blue, Accent color 5 , Light Downward Diagonal Stripe; Outline: Blue, Accent color 5 . Increase the font of the chart title to 40 . Insert a rounded rectangle shape in the top left corner of the chart. Note, depending on the version of Office used, the shape name may be Rectangle: Rounded Comers. Enter the text Women's products consistently outsold men's products. Change the size of the rounded rectangle shape to 0.6 high and 2.25 wide. 13 On the Predictions worksheet, in cell B5, calculate the 2019 sales goal amount for women's activeware based on the 2018 amount on the Retail worksheet and the percent in cell B1 on the Predictions worksheet. Copy this formula to the range B5: E16. 14 In cell B17, calculate the total quarter 1 sales goal amount and copy the formula over to E17. in cell F5, calculate the total yearly sales goal amount for women's activeware. Copy the formula down to F17. 15 In cell B21 calculate the 2019 sales goal amount for men's activeware based on the 2018 amount on the Retail worksheet and the percent in cell B1 on the Predictions worksheet. Copy this formula to the range B21:E32. 16. In cell B33, calculate the total quarter 1 sales goal amount and copy the formula over to E33. In cell F21, calculate the total yearly sales goal amount for men's activeware. Copy the formula down to F33. 17 In B36:F36, total the quarterly and yearly sales for both women's and men's clothing