The PivotTable below has one row field and two column fields. How can you pivot this table to show the column fields as subtotals of each value in the row field?

  • On the PivotTable itself, drag each Average field into the row fields area.
  • Right-click a cel in the PivotTable and select PivotTable Options > Classic PivotTable layout.
  • In the PivotTable Fields pane, drag Sum Values from the Columns section to a location below the field in the Rows section.
  • In the PivotTable Fields pane, drag each field from the Sum Values section to the Rows section.

The correct answer is:

  • In the PivotTable Fields pane, drag Sum Values from the Columns section to a location below the field in the Rows section.

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

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
100% Free SEO Tools - Tool Kits PRO