Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Convert the two below Proper Data Sets to Excel Tables and name the tables smartly, names like Revenue Table and Sales RepLookupTable. Using the Relationship

image text in transcribedimage text in transcribed

Convert the two below Proper Data Sets to Excel Tables and name the tables smartly, names like Revenue Table and Sales RepLookupTable. Using the Relationship feature in the Data Ribbon Tab, create a relationship between the two columns using the Sales Rep Column. Then make a Cross Tabulated PivotTable Report that counts How Many Sales there were for each Product in each Region. Put the PivotTable on a New Sheet. Revenue Customer Amazon.com 7448 4908 4427 4344 Date Sales Rep 10/7/2018 Luke 10/26/2017 Jeri 5/20/2018 Sheliadawn 9/24/2017 Jon 1/14/2018 Steven 4/3/2017 Sheliadawn 1/20/2018 Jeri 2/26/2017 Jeri 12/16/2018 Jeri 4/5/2017 Jeri 6/24/2018 Jeri 8/22/2017 Chin 11/9/2018 Luke Costco Home Depot Whole Foods McLendon's Hardware Whole Foods Nature Company Home Depot Amazon.com Costco Yahoo Sherman Williams Google Product ILP Item XOU Item JHF Item XOU Item MEB Item AIM Item MFB Item ILP Item XOU Item XOU Item MFB Item LXS Item 5826 5231 4234 6687 4857 7715 1702 8739 2639 AIM Item Please be sure to have a proper Data set. A proper Data set contain: i)Column Headers / Field Names in First Row, ii) Each row contains a record or transaction, iii)Leave empty cells or Excel column/row headers around the entire Proper Data Set Sales Rep Luke Jeri Sheliadawn Jon Steven Chin Rhonda Troung Start Date Pension Plan 4/22/2011 TIAA-CREF 3/16/2003 Hawthorne 9/13/2011 TIAA-CREF 9/20/2003 Hawthorne 9/11/2016 TIAA-CREF 12/8/2008 TIAA-CREF 7/26/2015 Hawthorne 4/24/2000 TIAA-CREF Region South East West North MidWest North East West North MidWest Das

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

Performance Auditing Measuring Inputs, Outputs, And Outcomes

Authors: Stephen L. Morgan, Ronell B. Raaum, Colleen G. Waring

3rd Edition

0894139762, 9780894139765

More Books

Students also viewed these Accounting questions