Question

In excel, What is the first step to creating a PivotTable?

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.

Answer 1

Create or select data that needs to be analysed is the answer for this given question