just need the formulas please

You are the executive assistant to the director of sales at B-Trend, 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-seling 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-Trend, 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 B- Trendz online website 5 3 In cells F5:F17, calculate the yearly sales totals for the women's dothing line. In cells F21F33. calculate the yearly sales totals for the men's clothing line. In B36 F36, calculate the grand totals of women's and men's dothing sales. 4 In B37E37, calculate the percentage of sales from women's clothing Format as Percentage and display zero decimal places in B38 E38, calculate the percentage of sales from men's clothing Format as Percentage and display zero decimal places 5 5 You have been asked to determine whether the grand total yearly sales goals were met 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 retum a value of Yes if the goal was met or a value of No if the goal was not met 6 3 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 B5E16. Add High Point markers. Also add Line Sparklines for the Men's dothing 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 5 To determine which clothing lines may sell well online, you decide to rank them on a scale from A to E. In cell H5, using a Vlogkur 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 Vlookup function, determine the product line ranking of each product based on the Yeary Sales. Use the range name assigned to the lookup table. Copy the formula through H32 grade Bande Caneleison Beel Dynamic Tallmente File Page Layout Fomus Dua Review A Sage there Home Insert y ante Walet Me o 45 Pale B. RE weer te fund w Condom For Wyn X V + 1 M N a D Online Product Prime Rank 0 1 - 0 U 0 B-Trendz, Inc. 1 2018 Quarterly Sales Line 3 Quarter 1 Chrud Yearly sales at a Glanceaning 4 Women's Clothing Activeware 7 12,93 Casual that 26.1250,799, 251,529 Graphic Tees 457.000 478,1 477,22347, tackets 112, 011, 112, 325.37 4224 411,414,750403 10 Outer 201, 75200, 11 Pant 2018 291,23 291, 292,012 12 Outs 1 197,113 293 13 Sleepwear 297 281,334 2006 14 Socks 12 125,079 13 121,510 15 Sweets 29 42,00 347, 16 Swimsuit 234,087 330,700.745.21 I Total 275,50 1,036,515.450 1,000,000 1.30 1,000 OWE 196 000 UL Online Proda Predict Line 19 Guter Quarters & Yearly all Cala Gananking 20 Men's Clothing Active 412 416 41 4310 22 Casual Tees 267.710.04 MB 24 HUN 195 an Retail On WESTER WETE tur op MITIM 2002 D o MacBook Air ER Online Product 786 wee 1 Weepwear 281,922781,331 280,097 2:05, 111 14 Socks 124,583 128,079 126,213 121,510 15 Sweaters 229.14722, 203 245,666 247,897 16 Swimsuits 234, 310,719 107 205,321 17 Total 2,725,50 1,856,5113,215,456 1,7RS, 18 Product Line 19 Quarter Quarter 2 Quarte Carter Yugely Sale Sales at a Glance Hanking 20 Men's Clothing 21 Activeware 445,321 446,123 449,154 151,376 22 Casual Shirts 325, 331,825 337, 45 2 Graphic Tees 267,210 209.432272,045 24,121 24 Mackets 392,870 294,836 395,185 1957 25 ans 21,740 29.998 291,199 300,154 26. Outerwear 182,609 18,316 18.971185, 285 27 Pants 201,517 301,512 110,916 312,123 20 Shorts 222,0:16 225,192 229,465 227,000 29 Sleepwear 99.254 97.312 97,145 30 Socks 122,475 122,978 126,253 12743 31 Sweaters 101,345 1.900 90,156 127 32. Swimsuits 79,978 79,120 83,920 76,293 13 Total 2,312,394 2,028,536 2.862,823 2,888,6 34 35 Quarter 1 Quarter 2 Quarter 3 Quarter Yearly Sales Sales Goal Met? 36 Grand Total 37 Women's of Sales 38 Men's of Sales 39 TGC Retail Predictions Onne Rody