In this PivotTable, the continuous variable weight is shown in the Row field. Another continuous variable is in the Sum Values field. It is important to reduce a long list of body weights to a smaller set of weight categories. How do you do this?

• Use weight as a filter field as well as a row field in the PivotTable.
• Use IF() to show weight by categories instead of by pounds.
• Click the Row Labels arrow and select Group.
• Right-click any row field value in the PivotTable and select Group.

The correct answer is:

• Right-click any row field value in the PivotTable and select Group.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers