Critical Thinking Case-Based Questions
Case 5-3
As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.
Which of the following is a true statement Carter can make to Ted about PivotTables?
A) To remove a field from a PivotTable, you click the field's check box in the PivotTable Field list.
B) You cannot rename a value label by typing the new text directly in any cell where the value label appears in the PivotTable.
C) Removing a field from the PivotTable changes the underlying Excel table.
D) To remove a field from a PivotTable, you click the field's check box in the PivotChart list.

Question

Quizplus · Accepted Answer

To remove a field from a PivotTable, you click the field's check box in the PivotTable Field list. Option B is incorrect because you can rename a value label by typing the new text directly in any cell where the value label appears in the PivotTable. Option C is incorrect because removing a field from the PivotTable does not change the underlying Excel table. Option D is incorrect because to remove a field from a PivotTable, you click the field's check box in the PivotTable Field list, not the PivotChart list.