Jin wants to insert a recommended pivot table.He clicks 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 should be to click on "Recommended PivotTables" on the Insert tab in the Tables group, as this is the option for inserting a recommended pivot table. Option A is for inserting a pivot chart, not a pivot table. Option B is for inserting a regular pivot table, not a recommended one. Option D is not a valid option, as there is no "Pivot Chart" option under the Charts group on the Charts tab.

Jin Wants to Insert a Recommended Pivot Table