Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PivotTable EXCEL worksheet The PivotTable worksheet has 30 observations and four variables: Company name, Industry (whether the company is in the Agriculture, Hardware, or Office

PivotTable EXCEL worksheet

The PivotTable worksheet has 30 observations and four variables: Company name, Industry (whether the company is in the Agriculture, Hardware, or Office Supplies industry), Month (from January to March), and Sales (sales amounts in $USD from each of the three months). Use the data set and the Pivot Table function in Excel to create a cross tabulation between the industries and months and show the average sales in the Pivot Table. Use an appropriate format for the sales amounts

Company name Industry Month Sales
Best Vegetable Company Agriculture Jan 2976
Bright Eggbeater Corporation Agriculture Jan 3079
Bright Company Office Jan 2637
Compelling Office Company Office Jan 3324
Exclusive Shovel Traders Hardware Jan 3489
Matchless Vise Inc. Hardware Jan 4233
Reliable Tripod Company Hardware Jan 2049
Remarkable Notebook Supply Office Jan 2887
Safe Flagpole Supply Hardware Jan 4863
Safe Trading Partners Office Jan 3281
Secure Office Corporation Office Jan 3157
Succulent Supplies Inc. Office Jan 2752
Superior Vegetable Corporation Agriculture Jan 1509
Supreme Eggbeater Corporation Agriculture Jan 4011
Unsurpassed Banister Corporation Hardware Jan 4748
Wonderful Writing Inc. Office Jan 4998
Best Organic Company Agriculture Jan 3021
OK Food Corporation Agriculture Jan 4127
Ready Go Corporation Hardware Jan 4845
Peerless Food Agriculture Jan 4790
TriCounty Company Hardware Jan 3906
Safety First Corporation Hardware Jan 4030
SRC Supplies Inc. Hardware Jan 3658

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

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Finance questions