Case EX 12-1 Jaime loves designing and making hand-made bags and he has started a small business selling his bags over the Internet. To keep track of the orders and their status, he uses a worksheet with the following columns: Order Number, Customer Name, Customer Address, Bag Ordered, and Shipped. Under the Shipped column, Jaime enters "Yes" or "No" based on whether the bag has been shipped or not. If Jaime creates a PivotChart for the data, he can ____ the results so that only the bags that are not shipped yet will be displayed.
A) hide
B) rearrange
C) filter
D) join

Question

Quizplus · Accepted Answer

Jaime can filter the results using the "Shipped" column to only display orders that have not been shipped yet. This will allow him to easily see which orders need to be fulfilled. A pivot table/chart allows you to filter data based on certain criteria.

Case EX 12-1 Jaime Loves Designing and Making Hand-Made Bags