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 Percentage and display zero decimal places.

Transcribed Image Text:

AutoSave OFF ^B 2.0 *** Home Insert. Draw Page Layout - 5 1 2 F37 Poste 3 4 Women's Clothing 5 Activeware Casual shirts 7 Graphic Tees 8 Jackets 9 Jeans 10 Duterwear 11 Pants ď [A- po 12 Shorts 13 Sleepwear 14 Socks 15 Sweaters 16 Swimsuits 17 Total 18 19 20 Men's Clothing 21 Activewire 22 Casual shirts 23 Graphic Tees 24 Jackets 25 Jeans 26 Outerwear 27 Pants 22 Seper 30 Socks 41 31 Sweaters 32 Swimw.ha 33 Total 34 35 36 Grand Total 37 Women's % of Sales 38 Men's % of Saks 39 ← Ready Calibri (Body) В 1 ✓ fx Retail B Quarter 1 C Quarter 1 M ✓11 Y D Formulas Data ✓ À À A Y E 734,765 745.777 732.937 740,375 245.198 256.789 235,930 251,329 457,000 478.123 312,789 311,987 Predictions B-Trendz, Inc. 2018 Quarterly Sales 2,963,854 1,009,452 477 229 472,721 1,595,073 312,892 315,837 1,253,505 www. 413.725 414,756 419,202 1,571,149 201,725 2001273 744,765 182,746 795,476 192,782 223,927 124,547 239,847 245,656 247,897 234,987 310,719 306,827 245.321 1,007,854 3,725,569 3,856,511 3,845,456 3,785,383 15,212,919 F Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance 779,512 747,317 1,175,767 291,794 197,115 198795 191,00 wwwww 261334 2011. 285.111 126,213 121,510 www.s 782,192 1,131,069 Online 445,321 446,123 49,154 451,875 1,792,474 323.968 331,825 337,345 1,320,125 1,082.810 182,M 324,987 267,210 259432 272045 274,123 392,876 391,230 395.185 395,587 264,540 291199 300,154 14,116 186,9780 185,285 294,517 301,512 $111,996 312,123 1,219, 222,096 226,897 229,465 99,254 97,312 98251 122,475 122,978 126,253 127423 101.345 94,968 90,156 98,127 75,978 79,195 83.926 76,293 910,396 232,000 MARE 97,045 345 35 392,762 499,129 384,506 315,303 2,812,304 2,828,536 2867,373 2,388,681 2,867,373 2,388,681 11,396,984 497,349 975,113 Quarter 2 Quarter 3 Quarter 4 Yearty Sales Sales at a Glance 1,578,84 1,162,097 739,778 + Review == G Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearty Sales Sales Goal Me? 6,537,963 6,683,047 6,712,829 6,674,064 25,509,903 View 20 == H I Product Line Online Ranking Product Product Line Online Ranking | Product | McKinney_e02_grader_hw_B-Trendz Tell me Wran Text Merge & Center v J K General L $ M 500,000 1.000.000 1,250,000 1,500,000 to m N Product Line Rank 0 E D r B A v 0 Conditional Format Cell Formatting as Table Styles P R 5 Insert v Delete Format v T U 27. ↓ Sort & ✓✓ Filter V V W Find & Select X Share db)- AZ Analyze Data Y Comments Sensitivity + O z 90% A T AutoSave OFF ^B 2.0 *** Home Insert. Draw Page Layout - 5 1 2 F37 Poste 3 4 Women's Clothing 5 Activeware Casual shirts 7 Graphic Tees 8 Jackets 9 Jeans 10 Duterwear 11 Pants ď [A- po 12 Shorts 13 Sleepwear 14 Socks 15 Sweaters 16 Swimsuits 17 Total 18 19 20 Men's Clothing 21 Activewire 22 Casual shirts 23 Graphic Tees 24 Jackets 25 Jeans 26 Outerwear 27 Pants 22 Seper 30 Socks 41 31 Sweaters 32 Swimw.ha 33 Total 34 35 36 Grand Total 37 Women's % of Sales 38 Men's % of Saks 39 ← Ready Calibri (Body) В 1 ✓ fx Retail B Quarter 1 C Quarter 1 M ✓11 Y D Formulas Data ✓ À À A Y E 734,765 745.777 732.937 740,375 245.198 256.789 235,930 251,329 457,000 478.123 312,789 311,987 Predictions B-Trendz, Inc. 2018 Quarterly Sales 2,963,854 1,009,452 477 229 472,721 1,595,073 312,892 315,837 1,253,505 www. 413.725 414,756 419,202 1,571,149 201,725 2001273 744,765 182,746 795,476 192,782 223,927 124,547 239,847 245,656 247,897 234,987 310,719 306,827 245.321 1,007,854 3,725,569 3,856,511 3,845,456 3,785,383 15,212,919 F Quarter 2 Quarter 3 Quarter 4 Yearly Sales Sales at a Glance 779,512 747,317 1,175,767 291,794 197,115 198795 191,00 wwwww 261334 2011. 285.111 126,213 121,510 www.s 782,192 1,131,069 Online 445,321 446,123 49,154 451,875 1,792,474 323.968 331,825 337,345 1,320,125 1,082.810 182,M 324,987 267,210 259432 272045 274,123 392,876 391,230 395.185 395,587 264,540 291199 300,154 14,116 186,9780 185,285 294,517 301,512 $111,996 312,123 1,219, 222,096 226,897 229,465 99,254 97,312 98251 122,475 122,978 126,253 127423 101.345 94,968 90,156 98,127 75,978 79,195 83.926 76,293 910,396 232,000 MARE 97,045 345 35 392,762 499,129 384,506 315,303 2,812,304 2,828,536 2867,373 2,388,681 2,867,373 2,388,681 11,396,984 497,349 975,113 Quarter 2 Quarter 3 Quarter 4 Yearty Sales Sales at a Glance 1,578,84 1,162,097 739,778 + Review == G Quarter 1 Quarter 2 Quarter 3 Quarter 4 Yearty Sales Sales Goal Me? 6,537,963 6,683,047 6,712,829 6,674,064 25,509,903 View 20 == H I Product Line Online Ranking Product Product Line Online Ranking | Product | McKinney_e02_grader_hw_B-Trendz Tell me Wran Text Merge & Center v J K General L $ M 500,000 1.000.000 1,250,000 1,500,000 to m N Product Line Rank 0 E D r B A v 0 Conditional Format Cell Formatting as Table Styles P R 5 Insert v Delete Format v T U 27. ↓ Sort & ✓✓ Filter V V W Find & Select X Share db)- AZ Analyze Data Y Comments Sensitivity + O z 90% A T

Answer rating: 100% (QA)

A Womens Clothes Sales Percentage Calculation Step 1 Apply formula On cell B37 B17B36 Step 2 ... View the full answer