Suong Nguyen works in the Accounting Department of Home Project Supply, a growing chain of hardware stores in the Midwest. She is developing an Excel workbook to track the company's inventory stored in warehouses in Chicago, Illinois and Toledo, Ohio. She asks for your help in managing and analyzing the inventory data.

Go to the Chicago worksheet. Suong wants to review the data on the worksheet, which lists the Chicago warehouse inventory data.

Suong wants to analyze the inventory data on power tools separate from the complete inventory list. In cell K$4,$ she has already entered "Power" as the condition to use in an advanced filter. Create an advanced filter that copies the results to another location, using the table of inventory data $($range A$3$:I$60)$ as the List range. Use the information in the range K$3$:K$4$ as the Criteria range. Copy the results to the range starting in cell K$6.$ Resize column L to a width of $21\mathrm{.}00.$ Resize columns M:S to a width of $9\mathrm{.}00.$