Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
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