Question: You want to create a PivotTable based on the source data below Sales 15 26 4 Profit 10 18 Category 105 106 Notebook Office 107

 You want to create a PivotTable based on the source data

You want to create a PivotTable based on the source data below Sales 15 26 4 Profit 10 18 Category 105 106 Notebook Office 107 Whiteboard Office 108 Coffee Cup Kitchen 109 Silverware Kitchen 110 Pen 111 Wine Glass Kitchen 112 Pillow 113 Cork Board Office 114 Calendar 115 Pencil 1.5 2 10 Office 14 Home Office Office 21 24 15 17 1.5 What should you do beforehand? SELECT ONLY ONE Create a new column summing Sales and Profit Delete the negative numbers in the Profit column Delete the Home category Insert an empty row below Row 105 Insert a title for Column B

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!