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:

Refused to Obey

The act of deliberately not following a command or instruction, indicating autonomy or disagreement with the directive.

Torture

The act of inflicting severe physical or psychological pain on someone as a form of punishment, to extract information or confession, or for the pleasure of the torturer.

Deindividuation

A psychological state of decreased self-evaluation and decreased evaluation apprehension causing antisocial behavior, often occurring in group situations.

Twitter

A social media platform that allows users to post, interact with messages known as "tweets", and follow other users' activities.