Question
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)
Change Data Source
Convert to Range
Show Values As…
Value Field Settings
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)
Change Data Source
Convert to Range
Show Values As…
Value Field Settings
Answers
GPT-4o mini
To see where the data came from for the PivotTable, Ben should click **"Change Data Source."** This option allows him to view the original data range or table that was used to create the PivotTable.
Related Questions
What two new tabs appear in the ribbon when a PivotTable is selected?
(1 point)
PivotTable Design...
Tabitha wants to count up values automatically as she turns data into a PivotTable. What Table group...
Joseph accidentally closed the PivotTable Fields panel before he was ready. What can he do
to get i...