Page 480 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

3 A dialog box will appear. Select the desired field. In our example, we’ll select Salesperson, then click OK.

4 The slicer will appear next to the PivotTable. Each selected item will be highlighted in blue. In the example
below, the slicer contains a list of all salespeople, and six of them are currently selected.

5 Just like filters, only selected items are used in the PivotTable. When you select or deselect items, the PivotTable
will instantly reflect the changes. Try selecting different items to see how they affect the PivotTable. Press and
hold the Ctrl key on your keyboard to select multiple items from a slicer.

465
CITS : IT & ITES - Computer Software Application - Exercise 75