Machine-translated by Google. Questions are authored in English.
Top

Discussion

Which Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data has changed?

  • A.Format Report
  • B.Pivot Table
  • C.Refresh Data
  • D.Show Detail

Answer: C

Correct answer: Refresh Data

A pivot table holds a snapshot of its source, so changes to the source do not appear until Refresh Data is pressed. That is deliberate: recalculating a large pivot table on every edit would be slow.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.