11
QuizMultiple Choice

Pivot Tables and Pivot Charts — Unit test

Question 11 • Computer Applications - Office 2016 - EL3520 A

What is the first step to creating a PivotTable?

Answer
A
Click the Insert Tab and insert a PivotTable.
B
Create or select data that needs to be analyzed.
C
Decide on which fields (column and row labels) to use to analyze the data.
D
Format the worksheet and click Insert Table.

Explanation

First, create or select the data you want to analyze. A PivotTable needs a data source before you can insert it or choose which fields to arrange. Therefore, the correct choice is “Create or select data that needs to be analyzed.”

AI-written and checked against the verified answer.

Previous
Next