Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show all work answers step by step, in excel. 3 In cells F5F17, calculate the yearly sales totals for the women's clothing line. In
Please show all work answers step by step, in excel.
3 In cells F5F17, calculate the yearly sales totals for the women's clothing line. In cells F21:F33. 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. 4 In B37: E37, 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 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 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 Sparkines 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. 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 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 H2 1, 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 H32 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started