CGS 2518 Chapter 5 questions and
answers already passed
Student Last Name (default field), College (correct field) - correct answer ✔✔A worksheet
contains a list of graduates at your university. The worksheet contains these columns in this
sequence: Student Last Name, Student First Name, College, Major, and GPA. Data are sorted by
College, then by Major, and then by Student Last Name. What is the default At a change in
setting within the Subtotal dialog box, and what would be a more appropriate setting?
You can click it to collapse the details of that category - correct answer ✔✔You created an
outline within a worksheet. What does the - button indicate to the left of a row heading?
ROWS area - correct answer ✔✔A worksheet contains a PivotTable placeholder and the Field
List. No fields have been added to the PivotTable yet. If you click the College Major field check
box in the Field List, where does Excel place this field?
Sum - correct answer ✔✔You created a PivotTable to summarize commissions earned by
employees in each department. What is the default summary statistic for the commissions field
when you add it to the PivotTable?
Changes in the dataset do not affect the PivotTable until you refresh the PivotTable. - correct
answer ✔✔You have created a PivotTable and made some changes to values in the original
dataset from which the PivotTable was created. How does this affect the PivotTable?
Banded Rows and Banded Columns check boxes - correct answer ✔✔What settings should you
select for a PivotTable if you want to apply a different color scheme and display different fill
colors for main category rows and horizontal lines within the PivotTable?
d.
answers already passed
Student Last Name (default field), College (correct field) - correct answer ✔✔A worksheet
contains a list of graduates at your university. The worksheet contains these columns in this
sequence: Student Last Name, Student First Name, College, Major, and GPA. Data are sorted by
College, then by Major, and then by Student Last Name. What is the default At a change in
setting within the Subtotal dialog box, and what would be a more appropriate setting?
You can click it to collapse the details of that category - correct answer ✔✔You created an
outline within a worksheet. What does the - button indicate to the left of a row heading?
ROWS area - correct answer ✔✔A worksheet contains a PivotTable placeholder and the Field
List. No fields have been added to the PivotTable yet. If you click the College Major field check
box in the Field List, where does Excel place this field?
Sum - correct answer ✔✔You created a PivotTable to summarize commissions earned by
employees in each department. What is the default summary statistic for the commissions field
when you add it to the PivotTable?
Changes in the dataset do not affect the PivotTable until you refresh the PivotTable. - correct
answer ✔✔You have created a PivotTable and made some changes to values in the original
dataset from which the PivotTable was created. How does this affect the PivotTable?
Banded Rows and Banded Columns check boxes - correct answer ✔✔What settings should you
select for a PivotTable if you want to apply a different color scheme and display different fill
colors for main category rows and horizontal lines within the PivotTable?
d.
