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. Jaime wants to be able to easily rearrange and summarize the data and view it in different ways. He needs to use a ____.
A) Cluster chart
B) PivotTable
C) slicer
D) Watch Window

Question

Quizplus · Accepted Answer

PivotTable allows Jaime to easily rearrange and summarize the data in different ways, such as by bag type or by customer location. It also allows him to filter the data based on the shipped status or other criteria. Cluster chart is not applicable in this case as it is a visual tool used to display data in groups or clusters. Slicer is also not applicable as it is a filtering tool used in PivotTables and PivotCharts. Watch Window is not applicable as it is a tool used to monitor specific cells or formulas in a workbook.

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