Question

Q Explain the steps to create Pivot Table

Answer 1

Answer:

Creating a Pivot Table

Select any cell in the source data table.

On the Ribbon, click the Insert tab.

In the Tables group, click Recommended PivotTables.

In the Recommended PivotTables window, scroll down the list, to see the suggested layouts. ...

Click on the layout that you want to use, then click OK.

Answer 2

$\: \huge\sf\underline \pink{\underline{❥αnѕwєr_♡}}$

Creating a Pivot Table

1. Select any cell in the source data table
2. On the Ribbon, click the Insert tab
3. In the Tables group, click Recommended PivotTables.
4. In the Recommended PivotTables window, scroll down the list, to see the suggested layouts. ...
5. Click on the layout that you want to use, then click OK.