Multiple Choice
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.
Correct Answer:
Verified
Correct Answer:
Verified
Q8: The score of a student in two
Q9: Alejandro wants to change the color of
Q10: To add fields to a PivotTable,one can
Q11: The score of a student inserted in
Q12: Chastity wants to rename her pivot table
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