Pivot Tables and Pivot Charts

Question 1

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 2

✔ TablesIllustrations Add-ins Charts

Revolt · Accepted Answer

✔ Tables

Question 3

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

Question 4

✔ FilterSlicer Timeline Data

Revolt · Accepted Answer

✔ Filter

Question 5

Insert Timeline ✔ Insert SlicerActive Field Group

Revolt · Accepted Answer

✔ Insert Slicer

Question 6

What are the two contextual tabs that appear when working with PivotTables?

Revolt · Accepted Answer

Analyze and Design

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

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

Pivot Tables and Pivot Charts Answers