Latest:
LinkedIn Microsoft Excel Certification 

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?

Editorial Staff
  • 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

You May Also Like

The last two digits of the Representative ID Number is the Office ID. Which function, when entered into cell B2 and then dragged to cell B6, returns the Office ID for each representative?

Editorial Staff 0

The NOW() function returns the current date and time as 43740.665218. Which part of this value indicates the time?

Editorial Staff 0

From which field list was the pivotTalble created?

Editorial Staff 0