To see where the data came from in a PivotTable, Ben should click on Change Data Source. This option allows him to view and modify the data range that the PivotTable is based on.
Ben needs to find the original data that was used to create a PivotTable, since the numbers he’s seeing in the table don’t seem like they could be correct. What should he click to see where the data came from?
(1 point)
Responses
Change Data Source
Change Data Source
Convert to Range
Convert to Range
Show Values As…
Show Values As…
Value Field Settings
1 answer
1 answer