Chapter Review 5-22b Apply: Case Problem 1 Data File needed for this Case Problem: Shirts.xlsx Go Sports Anton Aliyev is the store manager for Go Sports, a sports clothing store in Middletown, Ohio. In addition to its clothing inventory, the store will print logos provided by local sports teams on T-shirts, jerseys, or sweatshirts purchased at the store. Anton uses Excel for a variety of tasks, including pricing and Inventory. He wants you to create an Excel table from Information about current products and then analyze this data. Complete the following: MACAO 9:117 fojacksonnews.files.wordpress.com APPLY Case Problem 1 Data File needed for this case Problem: Shirts.xlsx Ohio. In addition to its clothing inventory, the store will print logos provided by local sports teams Go Sports Anton Aliyev is the store manager for Go Sports, a sports clothing store in Middletown, on T-shirts, jerseys, or sweatshirts purchased at the store. Anton uses Excel for a variety of tasks, including pricing and inventory. He wants you to create an Excel table from information about current products and then analyze this data. Complete the following: 1. Open the Shirts workbook located in the Excel5 > Case folder included with your Data Files and then save the workbook as Shirts Inventory in the location specified by your instructor. 2. In the Documentation worksheet, enter your name and the date. 3. In the Shirts worksheet, create an Excel table using all of the data in the worksheet. Rename the table as Shirts Th. Format the table with Table Style Medium 9. Change the Price data to the Currency format showing no decimal places. Change the In Stock data to the Number format with no decimals | 4. Make a copy of the Shirts worksheet and then rename the copied worksheet as Sort by Style (Hint: Press the Ctrl key as you drag and drop the Shirts sheet tab to the right of the Shirts sheet tab to make a copy of the worksheet) /S. In the Sort by Style worksheet, sort the data in ascending order by Style, and then in descending order by In Stock 6. Filter the Shirts Tbl table by Size to remove the youth extra small lyxsm) and ladies extra small (bom) sizes. Insert a Total row that shows the total shirts In Stock Change the Total row label to Total Shirts Split the worksheet window into two horizontal panes. Place the split bar two rows above the bottom row of the worksheet. In the top pane, display the shirt data. In the bottom pane, display only the Total row. Make a copy of the Shirts worksheet, and then rename the copied worksheet as Filter by Color In the Filter by Color worksheet, filter the Shirts Tbl table to display only T-shirt style. 10. Insert a slicer for Color position the slicer so its upper-left comer is in cell G1, resize the slicer’s height to 1.8* and its width to 1.2″, and then format the slicer with Slicer Style Dark 1 V 11. Use the Color slicer to further filter the Shirts Tbl table to display only blue T-shirts and white T-shirts