Katrin has created a new table with only data for sale of products in the East region of her company.She wants to change the pivot table showing the sale of products in both East and West regions of the country to use that source,so that it can be sent to a manager in the West region,without revealing the East region's data.To do so,she can follow the following series of clicks/ entries/ selections: Cell PivotTable Tools tab Data group Top section of the Change Data Source command Change PivotTable Data Source dialog box Select a new data source range OK.

Question

Katrin has created a new table with only data for sale of products in the East region of her company.She wants to change the pivot table showing the sale of products in both East and West regions of the country to use that source,so that it can be sent to a manager in the West region,without revealing the East region's data.To do so,she can follow the following series of clicks/ entries/ selections: Cell > PivotTable Tools tab > Data group > Top section of the Change Data Source command > Change PivotTable Data Source dialog box > Select a new data source range > OK.

Quizplus · Accepted Answer

The steps mentioned describe the correct process of changing the data source of a pivot table.

Katrin Has Created a New Table with Only Data for Sale