You want to add a column to the PivotTable below that shows a 5% bonus for each sales rep. That data does not exists in the original data table. How can you do this without adding more data to the table?

  • Add a new PivotTable field.
  • Add a calculated item
  • Add a new Summarize Value By field.
  • Add a calculated field.

The correct answer is:

  • Add a calculated field.

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