# Chapter Review 5-22b Apply: Case Problem 1 Data File needed for this Case Problem: Shirts.xlsx Go…

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

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.