answer fully

Seasons Customer Fall Macys NOTE: Winte The data listed here is for the pull down Spring Target lists in the table for Seasons and Customers. Order Style Number Season Date to Ship| Customer Number Quantity , Selling Price Extension Summer 1 Belk's Target 303 35.00 24,500.00 Back to School Dillards Normally these cells would be locked and password 3103 Winter Belk's 84075 32.00 $ 25,400.00 Boscov's protected. Some companies would even hide these cells 3402 Fall Dillard D320 27.00 $ 13,500.00 to keep access limited to specific employees for editing. 3607 Winter 700 930 5 39.00 3 35,340.00 8706 Summer Macys MSO 600 $ 29.00 $ 17,400.00 Things to do: 4302 Spring 1804 17,100.00 Mande 9001 11,200.00 . Create a lookup table to determine the Date to Ship for each orller. The shipping 310 7001 4305 Spring Macy's MGOL 19,425.00 Spring needs to ship by 10/1/2019, Winter needed to have shipped by 9/15/2019 Dillard 5400 39.00 5 24,375.00 Summer needs to ship by 3/1/2019 and Back to School need to ship by 7/1/2019. 7612 Spring Boscov's 751 41.00 S 24,190.00 Belk's 85031 34,710.00 2. Copy the Style Information to another worksheet. Label it Belk's Orders. 7812 Spring Kohls x900 43.50 3 23,925.00 Using the filter tool find all of the Belk orders worth more than 308. C Penney 2101 $ 37.50 $ 45,375.00 Make sure you use the number filter for the Extension field. Do not hand pick the results. farge 304 24,500.00 3103 Winter Belk's 84076 26,400.00 3. Create a pivot table in this worksheet that shows the sum of booked orders by season Dillard's D321 27.00 3607 Winter 701 930 $ Make sure your data is properly formatted. Boscov's 38.00 35,340.00 Macy's M901 29.00 . Create a pivot chart that illustrates total booked orders by customer. Make sure the 4302 Spring Kohls 1805 17,100.00 320 chart titles are complete and the y axis data is properly formatted.I Mande 9003 Target 320 700 5. Group worksheets. Cell 82 type in: Your Name and Today's Dage. Leave them grouped when finished. Save and submit file. MGO1 sSO 25,200.00 Macy's 18,425.00 7612 Back to School Dillards 3401 625 1 33.50 5 24,375.00 Boscov 752 24,190.00 Belk's 85032 34,710.00 Kohls 1901 43.50 $ 23,925.00 7614 Spring CP4321 45,375.00 3102 Fall Target 24,500.00 Belk's 84077 26,400.00 Dillards D322 27.00 $ 13,500.00 702 38.00 8706 Summer Macy's MSO GOO ! $ 475 17,400.00 1806 Mande 9021 35.00 5 11,200.00 Target 700 36.00 Macys SSO 25,200.0 18,425.00 Dillard D402 24,375.00 7612 Spring Boscov's 590 $ 24,190.00 Belk's 85083 590 1 39.00 $ 34,710.00 7812 Spring Kohls 1902 23,925.00 7614 Spring JCP4322 210 5 45,375.00 Target 35.00 $ 24,500.00 3103 Winter Belk's 84078 26,400.00 Dillards D323 27.00 3607 Winter Boscov's 103 35,340.00 M503 Kohls 1807 36.00 $ 17,100.00 Mande 9035 35.00 11,200.00 4302 Spring Target 340 700 25,200.00 Macy's MGO3 7612 Back to School Dillards 3403 625 33.50 18,425.00 24,375.00 7612 Spring Boscov's 754 590 S 24,190.00 7614 Spring Belk's 8503 890 1 34,710.00 Kohls 1903 23,925.00 JCP4323 45,375.00 3102 Fall Target 307 24,500.00 3103 Winter Belk's 94079 Dillard D324 SOO I S 26,400.00 13,500.00 8706 Summer Macys M504 600 S 29.00 $ 17,400.00 808 475 1 Mande 9041 11,200.00 342 700 1 SSO ! $ Dillard D404 625 5 18,425.00 24,375.00 Boscov's 24,190.00 Belk's 85035 890 ! $ 34,710.00 7812 Spring Kohls 1904 43.50 $ 23,925.00 JC Penney 1210 1 $ 45,375.00