Pivot Tables and Pivot Charts

Question 3 • Computer Applications I - A

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

Answer

Click Insert Timeline.

Select the PivotTable.

Click Insert on the ribbon.

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.

Back to All Questions

More from this Course

Assignment

9 verified answers

Pivot Tables and Pivot Charts

Working with Lists

Analyzing Data