Question
Go to the Media Log worksheet and click cell B4 to select a cell in the Media table. 3. On the ribbon, click the Insert
Go to theMedia Logworksheet and click cellB4to select a cell in the Media table.
- 3.
On the ribbon, click theInserttab, and then in the Tables group, click thePivotTablebutton. The Create PivotTable dialog box opens.
- 4.
Verify thatMediaappears in the Table/Range box. This specifies the Media table as the source for the PivotTable.
- 5.
Click theExisting Worksheetoption button, and then pressTABto move the insertion point into the Location box. You want to insert the PivotTable into the Data Explore worksheet starting at cell B6.
- 6.
Click theData Exploresheet tab, and then in the Data Explore worksheet, click cellB6. The 3-D reference 'Data Explore'!$B$6 is entered into the Location box. SeeFigure 7-22.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started