To filter a PivotTable to show expenses for only Chicago and Seattle in the City field, press _____ then click the Chicago and Seattle buttons in the City slicer.
A) Tab
B) Alt
C) Ctrl
D) Shift

Question

Quizplus · Accepted Answer

Pressing Ctrl allows multiple options to be selected in the slicer. Therefore, the Ctrl key should be used to select both Chicago and Seattle in the City slicer.

To Filter a PivotTable to Show Expenses for Only Chicago