Click here for more: Scholars nexus
Excel Chapter 7 Intro To Business Questions with
Detailed Verified Answers
The data for a PivotTable should be in the format of a:
A. chart B. file C. list
Ans: C
PivotTable field names are formed from the source data's:
A. column titles B. row titles C. sheet tab names
Ans: 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
Ans: 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
Ans: C
Slicers are used to:
A. apply labels to data B. filter data C. sort data
© Get it right 2025 Getaway - Stuvia US All rights reserved
Excel Chapter 7 Intro To Business Questions with
Detailed Verified Answers
The data for a PivotTable should be in the format of a:
A. chart B. file C. list
Ans: C
PivotTable field names are formed from the source data's:
A. column titles B. row titles C. sheet tab names
Ans: 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
Ans: 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
Ans: C
Slicers are used to:
A. apply labels to data B. filter data C. sort data
© Get it right 2025 Getaway - Stuvia US All rights reserved