Question: I need help with formulas for these steps. In B37:E37, calculate the percentage of sales from womens clothing. Format as Percentage and display zero decimal

I need help with formulas for these steps.

In B37:E37, calculate the percentage of sales from womens clothing. Format as Percentage and display zero decimal places. In B38:E38, calculate the percentage of sales from mens clothing. Format as Percentage and display zero decimal places.

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 return a value of Yes if the goal was met or a value of No if the goal was not met.

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 Mens clothing data in G21:G32 based on data in B21:E32. Add High Point markers.

I need help with formulas for these steps. In

Search Ashley Sekhon AS - AutoSave A File Home Insert e 02_grader_hw_B-Trendz SekhonAshley.xlsx - Excel Formulas Data Review View Help 0 x Comments Page Layout Share U32 f L M N O P Q R S T U V W B-Trendz, Inc. 2018 Quarterly Sales Product Line Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking Online Product 4 Women's Clothing 5 Activeware 6 Casual Shirts 7 Graphic Tees 8 Jackets 9 Jeans 10 Outerwear 11 Pants 12 Shorts 13 Sleepwear 14 Socks 15 Sweaters 16 Swimsuits 17 Total 734 765 745.777 732.937 740.375 245.194 256,289 255,93 251.529 457,000 478,123 477,229 472,721 312,789 311,987 312,892 315,837 423,465 413,726 414,756 419,202 182.706201,725 200, 273 1944,768 293,476 291,234 293,745 297,312 192.782 197.315 198.295 193.800 283,927 281,334 280,687 265,111 124.587 125,079 126,211 121,510 239,847 242,703 245,666 247,897 234,987 310,719 306,827 245,321 3,725, 569 3,856,511 3.845,456 3,785,383 2.953.854 1,003,452 1,885,073 1,253,505 1,671,149 779.512 1,175,767 782.192 1,131,059 497,389 976,113 1,097,854 Product Online Product Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking 20 Men's Clothing 22 Casual Shirts 23 Graphic Tees 24 Jackets 25 Jeans 26 Outerwear 27 Pants 28 Shorts 29 Sleepwear 30 Socks 31 Sweaters 12 Swimsuits 33 Total 445.321 446,123 449,154 451,826 324,987 325,958 331,825 337,345 267,210 209,432 272,045 274,123 392,876 394,836 395,185 395.987 283.745 284.998 193 199 300.154 182.649 164,316 186.978185.285 294 517 301,512 310,936 312,123 222.036 226.897 229.465 232.000 99,254 97,312 98,251 97.945 122,475 122,978 126.253 127,423 101,345 94,968 90,156 98.127 75.97879196 83,926 26,293 2.812,394 2,828,536 2.867,373 2,888,681 1,292,474 1,320,125 1,082,810 1,578,884 1.162.097 239,228 1,219,088 910.398 392,762 499,129 384,596 315, 3 Quarter 1 Quarter 2 Quarter Quarter 4 Yearly Sales Sales Goal Met? 36 Grand Total 6.537,963 6,685,047 6.712,829 6,674,054 37 Women's of Sales 20. Man's Els Retail Predictions Online Ready 2 - + 78% 10:16 PM Search Ashley Sekhon AS - AutoSave A File Home Insert e 02_grader_hw_B-Trendz SekhonAshley.xlsx - Excel Formulas Data Review View Help 0 x Comments Page Layout Share U32 f L M N O P Q R S T U V W B-Trendz, Inc. 2018 Quarterly Sales Product Line Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking Online Product 4 Women's Clothing 5 Activeware 6 Casual Shirts 7 Graphic Tees 8 Jackets 9 Jeans 10 Outerwear 11 Pants 12 Shorts 13 Sleepwear 14 Socks 15 Sweaters 16 Swimsuits 17 Total 734 765 745.777 732.937 740.375 245.194 256,289 255,93 251.529 457,000 478,123 477,229 472,721 312,789 311,987 312,892 315,837 423,465 413,726 414,756 419,202 182.706201,725 200, 273 1944,768 293,476 291,234 293,745 297,312 192.782 197.315 198.295 193.800 283,927 281,334 280,687 265,111 124.587 125,079 126,211 121,510 239,847 242,703 245,666 247,897 234,987 310,719 306,827 245,321 3,725, 569 3,856,511 3.845,456 3,785,383 2.953.854 1,003,452 1,885,073 1,253,505 1,671,149 779.512 1,175,767 782.192 1,131,059 497,389 976,113 1,097,854 Product Online Product Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance Ranking 20 Men's Clothing 22 Casual Shirts 23 Graphic Tees 24 Jackets 25 Jeans 26 Outerwear 27 Pants 28 Shorts 29 Sleepwear 30 Socks 31 Sweaters 12 Swimsuits 33 Total 445.321 446,123 449,154 451,826 324,987 325,958 331,825 337,345 267,210 209,432 272,045 274,123 392,876 394,836 395,185 395.987 283.745 284.998 193 199 300.154 182.649 164,316 186.978185.285 294 517 301,512 310,936 312,123 222.036 226.897 229.465 232.000 99,254 97,312 98,251 97.945 122,475 122,978 126.253 127,423 101,345 94,968 90,156 98.127 75.97879196 83,926 26,293 2.812,394 2,828,536 2.867,373 2,888,681 1,292,474 1,320,125 1,082,810 1,578,884 1.162.097 239,228 1,219,088 910.398 392,762 499,129 384,596 315, 3 Quarter 1 Quarter 2 Quarter Quarter 4 Yearly Sales Sales Goal Met? 36 Grand Total 6.537,963 6,685,047 6.712,829 6,674,054 37 Women's of Sales 20. Man's Els Retail Predictions Online Ready 2 - + 78% 10:16 PM

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

In B37:E37, calculate the percentage of sales from women. clothing. Format as Percentage and display zero decimal places. InB38:E38, calculate the percentage of sales from men's clothing. Format as...

In cell range B 3 7 :E 3 7 , calculate the percentage of sales from women's clothing based on women's total and the grand total. Display zero decimal places

Flexible Budget l'erformance Report Project Kelscy's Frozen Confectionarica buys and distributes singlo-scrve ice cream treats, popsicles, etc., such as those sold at convenience stores, sporting...

Budget assumptions: Kelsey's Frozen Confectionaries Master Budget Performance Report For the month ended June 30 Volume Sales Revenue 20,000 cases 50.00 per case $ MASTER Percent sold on credit 90%...

master budget performance report (planning budget vs. actuals and variances), and 2) a flexible budget performance report. You will be submitting a quiz to record your answers to the completed...

Flexible Budget Performance Report Project Kelseys Frozen Confectionaries buys and distributes single-serve ice cream treats, popsicles, etc., such as those sold at convenience stores, sporting...

Kelseys Frozen Confectionaries buys and distributes single-serve ice cream treats, popsicles, etc., such as those sold at convenience stores, sporting events and amusement parks. Download the file...

please help missing columns, Show formulas too please they are required please help fill All missing cells shows formulas too they are required. Variance % and the missing ones from the master budged...

A certain warehouse is worth P700,000. The average value of the merchandise in the warehouse is P600,000. The annual insurance rate on the warehouse is 1% and the merchandise stored in the warehouse...

Advertising objectives can be classified by their primary purpose to inform, persuade or remind. Identify one advertisement that primarily inform, one that persuade and one that reminds. Explain how...

Which of the following pairs represents a source of cash and a use of cash? Collections of accounts recelvable and Financing Payments to employees and payments to suppliers thvestment income and...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...