EXCEL CHAPTER 7 INTRO TO
BUSINESS WITH QUESTIONS
AND 100% CORRECT ANSWERS
GRADE A+ 2026
The data for a PivotTable should be in the format of a:
A. chart B. file C. list - answer-C
PivotTable field names are formed from the source data's:
A. column titles B. row titles C. sheet tab names - answer-A
The area in the layout section of the PivotTable Fields pane where you position fields by
which you want to filter the PivotTable report, thus enabling you to display a subset of
data in the PivotTable report is the:
A. FILTERS area B. ROWS area C. VALUES area - answer-A
The area in the layout section of the PivotTable Fields pane where data is summarized is
the:
A. COLUMNS area B. ROWS area C. VALUES area - answer-C
Slicers are used to:
A. apply labels to data B. filter data C. sort data - answer-B
The ____________ button removes a filter from a slicer.
A. Clear Filter B. Remove Slicer C. Slicer Header - answer-A
The ____________ is a report in a workbook that is graphically represented in a
PivotChart.
A. Associated PivotTable B. PivotChart Report C. Report Filter - answer-A
BUSINESS WITH QUESTIONS
AND 100% CORRECT ANSWERS
GRADE A+ 2026
The data for a PivotTable should be in the format of a:
A. chart B. file C. list - answer-C
PivotTable field names are formed from the source data's:
A. column titles B. row titles C. sheet tab names - answer-A
The area in the layout section of the PivotTable Fields pane where you position fields by
which you want to filter the PivotTable report, thus enabling you to display a subset of
data in the PivotTable report is the:
A. FILTERS area B. ROWS area C. VALUES area - answer-A
The area in the layout section of the PivotTable Fields pane where data is summarized is
the:
A. COLUMNS area B. ROWS area C. VALUES area - answer-C
Slicers are used to:
A. apply labels to data B. filter data C. sort data - answer-B
The ____________ button removes a filter from a slicer.
A. Clear Filter B. Remove Slicer C. Slicer Header - answer-A
The ____________ is a report in a workbook that is graphically represented in a
PivotChart.
A. Associated PivotTable B. PivotChart Report C. Report Filter - answer-A
