5
AssignmentMultiple Choice

Visualizing Data with Charts

Question 5 • 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.