You Have a PivotTable with 2 Fields in the ROWS

question 97

Multiple Choice

You have a PivotTable with 2 fields in the ROWS area and you want to see only the top level of categories.How do you hide the entire second level without removing it from the ROWS area?

• A)Click Expand Field in the Active Field Group on the Analyze tab.
• B)Select a field in the row headers and click Collapse Field in the Active Field Group on the Analyze tab.
• C)Click the - button to the left of the first category.
• D)You must move the second level out of the ROWS area.

---

Definitions:

Acquiring Self-control

The process of developing the ability to regulate one's thoughts, emotions, and actions in the pursuit of long-term goals.

Active Planning Process

A strategic approach to setting goals, identifying resources, and implementing steps to achieve desired outcomes.

Constructive Coping

Approaches and strategies used to deal with stress in a positive manner, focusing on problem-solving and emotional regulation.

Healthful Strategies

Approaches or tactics designed to promote or maintain health and well-being through lifestyle choices and preventative measures.