Pivot Tables and Pivot Charts

Question 1

What command activates the Analyze contextual tab to appear?

Revolt · Accepted Answer

inserting a PivotTable

Question 2

Select the correct navigational path to create a PivotTable.

Revolt · Accepted Answer

✔ Insert; Click the tab on the ribbon and look in the group.: Insert; Click the tab on the ribbon and look in the group.: Tables

Question 3

✔ TablesIllustrationsAdd-insCharts

Revolt · Accepted Answer

✔ Tables

Question 4

What steps will add slicers to a PivotTable? Use the drop-down menu to complete the steps.

Revolt · Accepted Answer

✔ Options; Click the PivotTable Tools tab.: Options; In the group, click .: Filter; In the group, click .: Insert Slicer

Question 5

✔ FilterSlicerTimelineData

Revolt · Accepted Answer

✔ Filter

Question 6

Insert Timeline✔ Insert SlicerActive FieldGroup

Revolt · Accepted Answer

✔ Insert Slicer

Question 7

What steps can display data in a PivotTable?

Revolt · Accepted Answer

Click and drag a field to one of the four areas in the PivotTable Field List pane.

Question 8

How do you activate the Slicer Tools contextual tab?

Revolt · Accepted Answer

Select a slicer and it will appear.

Question 9

What steps will add slicers to a PivotTable? Use the drop-down menu to complete the steps.

Revolt · Accepted Answer

Click the PivotTable Tools tab.: Options; In the group, click .: Filter; In the group, click .: Insert Slicer

Pivot Tables and Pivot Charts Answers