Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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_2

Step: 3

blur-text-image_3

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

Operational Assessment Of IT Internal Audit And IT Audit

Authors: Steve Katzman

1st Edition

0367567946, 978-0367567941

More Books

Students also viewed these Accounting questions

Question

Describe the different types of hospitals and their missions

Answered: 1 week ago

Question

What teacher supports and services are needed? (D2, D7, D8)

Answered: 1 week ago