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

Pivot Tables and Pivot Charts Answers