Asked by Ja'Lisa Hicks on Jun 17, 2024
Verified
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
Chicago and Seattle
Two major cities in the United States, with Chicago located in Illinois and Seattle in Washington state.
Filter PivotTable
A feature in spreadsheet software that allows users to refine and display only relevant data in a PivotTable by applying specific criteria.
- Employ slicers efficiently for data filtration in PivotTables and PivotCharts.
- Identify the effect of data filtering in PivotTables and PivotCharts on how data is presented.
Verified Answer
CT
Cristina TianelaJun 23, 2024
Final Answer :
C
Explanation :
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.
Learning Objectives
- Employ slicers efficiently for data filtration in PivotTables and PivotCharts.
- Identify the effect of data filtering in PivotTables and PivotCharts on how data is presented.