Asked by jessica tudosa on Jul 16, 2024
Verified
What can you do when you have two levels of data in PivotTable rows?
A) Add a calculated row to the PivotTable.
B) Use the Collapse and Expand buttons to drill down and up in the data.
C) Filter the PivotTable on two columns.
D) Create a 3-D PivotChart.
PivotTable Rows
Rows in a PivotTable that organize and summarize selected columns of data from a larger dataset for analysis.
Collapse and Expand
A feature in software that allows users to hide (collapse) or display (expand) portions of content for better navigation.
Drill Down
A data analysis process that allows users to view more detailed information by clicking on a summary item.
- Absorb the techniques involved in customizing data visualization by adjusting PivotTable and PivotChart elements.
- Identify and put into practice different tactics for encapsulating and adjusting data placements in PivotTables.
Verified Answer
AN
Allie NicoleJul 17, 2024
Final Answer :
B
Explanation :
Using the Collapse and Expand buttons allows you to drill down and up in the data to see the two levels of data in the PivotTable rows. This is the most efficient and user-friendly option. Adding a calculated row or creating a 3-D PivotChart may not necessarily help with displaying the two levels of data, and filtering the PivotTable on two columns may not provide the desired level of detail.
Learning Objectives
- Absorb the techniques involved in customizing data visualization by adjusting PivotTable and PivotChart elements.
- Identify and put into practice different tactics for encapsulating and adjusting data placements in PivotTables.