CGS 2518 EXAM QUESTIONS WITH
COMPLETE ANSWERS
(Ch.5 1) 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? - Answer-Changes in the dataset do not affect the PivotTable until you
refresh the PivotTable.
(Ch.5 2) 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? - Answer-Student Last Name
(default field), College (correct field)
(Ch.5 3) You created an outline within a worksheet. What does the [ - ] button indicate
to the left of a row heading? - Answer-You can click it to collapse the details of that
category.
(Ch.5 4) A worksheet contains a PivotTable placeholder and the PivotTable Fields List.
No fields have been added to the PivotTable yet. If you click the College Major field
check box in the PivotTable Fields List, where does Excel place this field? - Answer-
ROWS area
(Ch.5 5) 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? - Answer-Sum
(Ch.5 6) 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? - Answer-Banded Rows check box and a different PivotTable
style.
(Ch.5 7) You have just created a slicer for the State field in a PivotTable. Which of the
following does not characterize the initial slicer? - Answer-The slicer buttons are set to
filter out all records.
(Ch.5 8) Which PivotTable calculated field is correctly constructed to calculate a 20% tip
on a meal at a restaurant? - Answer-='Meal Cost'*.2
(Ch.5 9) You have created a PivotChart showing sales by quarter by sales rep. Before
presenting it to management, you notice the name of a rep who has since been fired.
How do you remove this rep from the chart without deleting the data? - Answer-Filter
the Sales Rep field in the PivotChart and deselect the employee's check box.
COMPLETE ANSWERS
(Ch.5 1) 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? - Answer-Changes in the dataset do not affect the PivotTable until you
refresh the PivotTable.
(Ch.5 2) 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? - Answer-Student Last Name
(default field), College (correct field)
(Ch.5 3) You created an outline within a worksheet. What does the [ - ] button indicate
to the left of a row heading? - Answer-You can click it to collapse the details of that
category.
(Ch.5 4) A worksheet contains a PivotTable placeholder and the PivotTable Fields List.
No fields have been added to the PivotTable yet. If you click the College Major field
check box in the PivotTable Fields List, where does Excel place this field? - Answer-
ROWS area
(Ch.5 5) 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? - Answer-Sum
(Ch.5 6) 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? - Answer-Banded Rows check box and a different PivotTable
style.
(Ch.5 7) You have just created a slicer for the State field in a PivotTable. Which of the
following does not characterize the initial slicer? - Answer-The slicer buttons are set to
filter out all records.
(Ch.5 8) Which PivotTable calculated field is correctly constructed to calculate a 20% tip
on a meal at a restaurant? - Answer-='Meal Cost'*.2
(Ch.5 9) You have created a PivotChart showing sales by quarter by sales rep. Before
presenting it to management, you notice the name of a rep who has since been fired.
How do you remove this rep from the chart without deleting the data? - Answer-Filter
the Sales Rep field in the PivotChart and deselect the employee's check box.
