Luca wants to insert a pivot table.He clicks on a single cell inside the data set,then proceeds to step X,and finally clicks OK in the dialog box that appears after step 2.What can step 2 be?
A) Select a pivot table under Pivot Chart & Pivot Tables in the Charts group on the Charts tab.
B) Click PivotTable on the Insert tab,in the Tables group.
C) Click Recommended PivotTables on the Insert tab,in the Tables group.
D) Select a pivot table under Pivot Chart in the Charts group on the Charts tab.

Question

Quizplus · Accepted Answer

Step 2 is to click on the PivotTable button in the Tables group under the Insert tab, which will open the Create PivotTable dialog box.

Luca Wants to Insert a Pivot Table