Nolan wants to group data in a Pivot table to analyze a subset of data.Which of these series of clicks/ selections/ entries should he follow to do so?
A) Ctrl + values > Group
B) Group > Analyze > Field Settings > Change Custom Name > OK
C) Right-click an item in the group > Ungroup
D) Right-click value > Group > Grouping box > Edit values in Starting at and Ending at checkboxes > Under By,select a time period > OK
Correct Answer:
Verified
Q5: In which of these boxes will you
Q6: How can one filter a PivotTable using
Q7: A student creates data for trees in
Q8: Which of these steps will you choose
Q9: Gregory creates data for different colors of
Q11: Marcos wants to refresh the data in
Q12: Which of the following series of clicks
Q13: After drilling down,Esteban wants to drill up
Q14: Which of the following will you select
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