Multiple Choice
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.
Correct Answer:

Verified
Correct Answer:
Verified
Q14: Katrin has created a new table with
Q15: Right-click the pivot item,then click Collapse to
Q16: Which of these is the default layout
Q17: One can use the areas section (at
Q18: To remove a field,in the PivotTable Field
Q20: Horatio wants to hide field headers in
Q21: One can rearrange fields in the PivotTable
Q22: To filter data in a PivotTable,follow the
Q23: Ingrid wants to change the name associated
Q24: Izzy wants to move a pivot table