11
AssignmentMultiple Choice

Pivot Tables and Pivot Charts

Question 11 • Computer Applications - Office 2016 - EL3520 A

What is the first step needed before you can add a timeline to a PivotTable?

Answer
A
Click Insert Timeline.
B
Select the PivotTable.
C
Click Insert on the ribbon.
D
Click the Design contextual tab.

Explanation

First, select the PivotTable so Excel knows which PivotTable the timeline should filter. Then you can use the Insert Timeline command. The correct choice is “Select the PivotTable.”

AI-written and checked against the verified answer.