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
Q2: Horatio wants to hide field headers in
Q3: Ricki wants to apply a particular chart
Q6: How can one filter a PivotTable using
Q7: Ingrid wants to change the name associated
Q8: Which of these is the default layout
Q10: Nolan wants to group data in a
Q10: Alejandro wants to change the color of
Q11: Izzy wants to move a pivot table
Q14: Chastity wants to rename her pivot table
Q15: In which of these boxes will you
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents