Multiple Choice
Edwin wants to insert a Pivot Chart to summarize raw data.Which of the following combination of clicks/selections/entries should he use to do this?
A) Select Cell > Insert > PivotChart > OK
B) Select Cell > Insert > Recommended PIvotTables > OK
C) Select Cell > PivotTable Tools > Analyze > PivotChart > Select a chart > OK
D) Select Cell > Insert > Table > Create Table dialog box > Fill data in Where is the data for your table? box > OK
Correct Answer:

Verified
Correct Answer:
Verified
Q15: Right-click the pivot item,then click Collapse to
Q17: One can use the areas section (at
Q18: Which of these steps will you choose
Q23: Which of the following will you select
Q26: Alejandro wants to change the color of
Q28: To add a calculated field to a
Q29: Which of these functions will you use
Q34: To clear all the data from a
Q46: Leigh-Ann wants to filter data in a
Q48: Which of these tabs will you select