Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

  1. 3.

On the ribbon, click theInserttab, and then in the Tables group, click thePivotTablebutton. The Create PivotTable dialog box opens.

  1. 4.

Verify thatMediaappears in the Table/Range box. This specifies the Media table as the source for the PivotTable.

  1. 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.

  1. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management A Practical Introduction

Authors: Angelo Kinicki, Brian Williams

9th Edition

1260075117, 978-1260075113

More Books

Students also viewed these General Management questions