answer fully this excel problem
Seasons Customer Fall Macys NOTE: Winter Kohls The data listed here is for the pull down Spring Target lists in the table for Seasons and Customers. Summer Belk's Back to School Dillards Normally these cells would be locked and password Boscov's protected. Some companies would even hide these cells JC Penney to keep access limited to specific employees for editing. Mandee Things to do: 1. Create a lookup table to determine the Date to Ship for each order. The shipping dates depend on the Merchandising Season. Fall goods need to ship by 8/1/2019, Spring needs to ship by 10/1/2019, Winter needed to have shipped by 9/15/2019, Summer needs to ship by 3/1/2019 and Back to School need to ship by 7/1/2019. 2. Copy the Style Information to another worksheet. Label it Belk's Orders. Using the filter tool find all of the Belk orders worth more than 30K. Make sure you use the number filter for the Extension field. Do not hand pick the results. 3. Create a pivot table in this worksheet that shows the sum of booked orders by season. Make sure your data is properly formatted. 4. Create a pivot chart that illustrates total booked orders by customer. Make sure the chart titles are complete and the y axis data is properly formatted. 5. Group worksheets. Cell B2 type in: Your Name and Today's Date. Leave them grouped when finished. Save and submit file.Style Number Season Date to Ship Number Quantity Selling Price Extension $102 Fall Target 35.00 24,500100 3103 Winter Belk's 84075 925 32.00 26,400.00 Dillards D320 27.00 3607 Winter Boscov's 700 930 38.00 35,340.00 M500 29.00 17,400.00 4302 Spring Kohls 1804 36.00 17,100.00 4305 Spring 9001 320 35.00 11,200.00 4302 Back to School Target 310 36.00 25,200.00 990 33.50 18,425.00 Dillards D400 625 39.00 24,375.00 7612 Spring Boscov's 751 590 41.00 24,190.00 Belk's 95031 39.00 34,710.00 7812 Spring Kohls 0900 43.50 23,925.00 JC Penney 37.50 3102 Fall Target 304 700 35.00 24,500.00 3103 Winter Belk's BAOTG 32.00 26,400.00 3402 Fall Dillards 900 27.00 13,500.00 3607 Winter 701 38.00 35,340.00 8706 Summer M901 17,400.00 Kohls 475 36.00 17,100.00 4305 Spring Mandee 35.00 11,200.00 320 36.00 25,200.00 4305 Spring M601 990 33.50 18,425.00 7612 Back to School 39.00 24,375.00 7612 Spring Boscov's 752 590 41.00 24,190.00 Belk's 39.00 34,710.00 7812 Spring 590 43.50 23,925.00 JC Penney JCP4321 37.50 3102 Fall 305 700 35.00 24,500.00 3103 Winter Belk's 32.00 26,400.00 3402 Fall Dillards 900 27.00 13,500.00 3607 Winter Boscov's 702 930 38.00 35,340.00 8706 Summer M902 29.00 Kohls 36.00 17,100.00 Mandee 9021 320 35.00 11,200.00 330 36.00 25,200.00 4305 Spring V602 33.50 18,425.00 7612 Spring Dillards 24,375.00 7612 Spring 753 590 41.00 24,190.00 7614 Spring Belk's 39.00 34,710.00 7812 Spring Kohls 902 43.50 23,925.00 JC Penney 37.50 30L 700 35.00 24,500.00 3103 Winter Belk's 32.00 26,400.00 3402 Fall Dillards 900 27.00 13,500.00 3607 Winter 35,340.00 8706 Summer 29.00 17,400.00 4302 Spring 36.00 17,100.00 4305 Spring Mandee 320 35.00 36.00 25,200.00 4305 Spring 990 33.50 18,425.00 7612 Back to School Dillards 625 39.00 24,375.00 Boscov's 754 590 41.00 24,190.00 Belk's 34,710.00 7812 Spring Kohls 390 43.50 23,925.00 7614 Spring 1210 37.50 45,375.00 3102 Fall 307 700 35.00 24,500.00 3103 Winter Belk's 32.00 3402 Fall Dillards 900 13,500.00 3607 Winter Boscov's 930 38.00 35,340.00 8706 Summer M904 29.00 17,400.00 4305 Spring 9041 35.00 11,200.00 4302 Spring 342 36.00 25,200.00 4305 Spring V604 590 33.50 18,425.00 Dillards 24,375.00 7612 Spring 795 590 41.00 24,190.00 Belk's 39.00 34,710.00 7812 Spring Kohls 904 43.50 23,925.00 JC Penney 1210
