Please show step to step in EXCEL. thank you.

You are the executive assistant to the director of sales at B-Trendz, Inc, a trendy retail store that has locations in only ten states. The company is considering branching into the online retail market. Your supervisor, Kayla Zimmerman, wants to review last year's sales data and make predictions about this year's sales data before making any decisions on whether or not to begin selling online and, if so, which products may sell well online. You have been asked to determine the best-selling women's and men's clothing line by ranking them on a scale from A to E. Only products that have a ranking of A or B will be considered for online sales. To branch into the online market in the future, next year's total sales must be at least $3,000,000 Finally, if B-Trendz, Inc. begins selling products online, you will need help setting up and maintaining the online store. Several companies have given you their information, and you need to determine which company would best fit the needs for the BTrendz online website. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Open the file named \( 002_{\text {_grader_hw_B-Trendz } x / s x \text {. Save the file with the name }} \) 0 e02_grader_hw_B-Trendz_LastFirst, replacing LastFirst with your last and first name. 2 On the Retail worksheet, in cells B17:E17 calculate the quarterly sales totals for the women's 4 clothing line. In cells B33. E33 calculate the quarterly sales totals for the men's clothing line. 3 In cells F5:F17, calculate the yearly sales totals for the womer's clothing line. In cells F21: F33, 5 calculate the yearly sales totals for the men's clothing line. In B36:F36, calculate the grand totals of women's and men's clothing sales. 5 You have been asked to determine whether the grand total yearly sales goals were met. 5 The 2018 yearly sales goals were met if the yearly sales were $25.000,000 or more. In cell G36, using a logical function, determine whether the yearly sales goals were met. Set the formula to return a value of Yes if the goal was met or a value of No if the goal was not met. 6 You want to create quick visuals of the quarterly sales of each product line, so you decide to use Sparklines to view the sales at a glance. In G5.G16, insert Line Sparklines based on the data in B5:E16. Add High Point markers. Also add Line Sparklines for the Men's clothing data in G21:G32 based on data in B21:E32. Add High Point markers. 7 Assign the named range of Rank to the cells M4:N8. 2 8. To determine which clothing lines may sell well online, you decide to rank them on a scale 5 from A to E. In cell H5, using a Vlookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H16. In cell H21, using a Viookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H32. You are the executive assistant to the director of sales at B-Trendz, Inc, a trendy retail store that has locations in only ten states. The company is considering branching into the online retail market. Your supervisor, Kayla Zimmerman, wants to review last year's sales data and make predictions about this year's sales data before making any decisions on whether or not to begin selling online and, if so, which products may sell well online. You have been asked to determine the best-selling women's and men's clothing line by ranking them on a scale from A to E. Only products that have a ranking of A or B will be considered for online sales. To branch into the online market in the future, next year's total sales must be at least $3,000,000 Finally, if B-Trendz, Inc. begins selling products online, you will need help setting up and maintaining the online store. Several companies have given you their information, and you need to determine which company would best fit the needs for the BTrendz online website. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Open the file named \( 002_{\text {_grader_hw_B-Trendz } x / s x \text {. Save the file with the name }} \) 0 e02_grader_hw_B-Trendz_LastFirst, replacing LastFirst with your last and first name. 2 On the Retail worksheet, in cells B17:E17 calculate the quarterly sales totals for the women's 4 clothing line. In cells B33. E33 calculate the quarterly sales totals for the men's clothing line. 3 In cells F5:F17, calculate the yearly sales totals for the womer's clothing line. In cells F21: F33, 5 calculate the yearly sales totals for the men's clothing line. In B36:F36, calculate the grand totals of women's and men's clothing sales. 5 You have been asked to determine whether the grand total yearly sales goals were met. 5 The 2018 yearly sales goals were met if the yearly sales were $25.000,000 or more. In cell G36, using a logical function, determine whether the yearly sales goals were met. Set the formula to return a value of Yes if the goal was met or a value of No if the goal was not met. 6 You want to create quick visuals of the quarterly sales of each product line, so you decide to use Sparklines to view the sales at a glance. In G5.G16, insert Line Sparklines based on the data in B5:E16. Add High Point markers. Also add Line Sparklines for the Men's clothing data in G21:G32 based on data in B21:E32. Add High Point markers. 7 Assign the named range of Rank to the cells M4:N8. 2 8. To determine which clothing lines may sell well online, you decide to rank them on a scale 5 from A to E. In cell H5, using a Vlookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H16. In cell H21, using a Viookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H32