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 I$16.$ Repeat the same formula for the men's clothing lines starting in cell I$21,$ and copy the formula through I$32.$

Create a $3-$D clustered column chart that represents the women's clothing sales based on each product line and the product line's yearly sales. Enter a chart title of Women's Clothing Sales. Move the chart so the top left comer of the chart is in cell K$10$ and the bottom right corner of the chart is in cell Q$22.$ Apply Style $3$ to the chart.

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 K$23$ and the bottom right corner of the chart is in cell Q$38.$ 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.

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, Pattern 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 Corners. Enter the text Women's products consistently outsold men's products. Change the size of the rounded rectangle shape to ${0\mathrm{.}6}^{\text{'}\text{'}}$ high and ${2\mathrm{.}25}^{\text{'}\text{'}}$ wide.

On the Predictions worksheet, in cell B$5,$ calculate the $2019$ sales goal amount for women's actixeware based on the $2018$ amount on the Retail worksheet and the percent in cell B$1$ on the Predictions worksheet. Copy this formula to the range B$5$:E$16.$