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

Pivot Tables and Pivot Charts Answers