Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please provide logical business questions that can be asked about the Data set above. How would you rearrange this pivot table for ordering columns and

image text in transcribed

Please provide logical business questions that can be asked about the Data set above. How would you rearrange this pivot table for ordering columns and rows to answer those questions about the data set you came up with. Please describe with maximum detail and please indicate any excel function to elaborate your explanations.

G E Sales 32098 F Profit Region 1926 W 65987 23091 7821 Product ABC DEF GHI JKL MNO PQR ABC DEF GHI JKL 83017 45678 35009 58113 99867 4530 MNO City 2 Los Angeles 3 Los Angeles 4 Los Angeles 5 Los Angeles 6 Los Angeles 7 Los Angeles 8 Los Angeles 9 Los Angeles 10 Los Angeles 11 Los Angeles 12 Los Angeles 13 Los Angeles 14 Los Angeles 15 Los Angeles 16 Los Angeles 17 Los Angeles 18 Los Angeles 19 Los Angeles 20 Los Angeles 21 Los Angeles 22 Los Angeles 23 Los Angeles 24 Los Angeles 25 Los Angeles 26 Los Angeles 27 Los Angeles 28 Los Angeles 29 Los Angeles 30 Los Angeles 31 Los Angeles 32 Los Angeles 33 Los Angeles PQR ABC DEF GHI JKL MNO PQR ABC DEF GHI JKL MNO PQR ABC D Year 2015 2016 2017 2018 2019 2020 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 56023 6748 9821 58342 46009 32098 65987 23091 7821 83017 45678 35009 58113 99867 4530 56023 6748 9821 58342 46009 77864 6745 6599 4156 -156 9132 9136 -1050 9298 1997 408 2241 1350 187 5251 4601 4173 7259 4849 1408 6641 3197 -2101 3487 9987 815 -1120 742 1964 -1750 7361 9344 607 DEF GHI JKL MNO PQR ABC DEF G E Sales 32098 F Profit Region 1926 W 65987 23091 7821 Product ABC DEF GHI JKL MNO PQR ABC DEF GHI JKL 83017 45678 35009 58113 99867 4530 MNO City 2 Los Angeles 3 Los Angeles 4 Los Angeles 5 Los Angeles 6 Los Angeles 7 Los Angeles 8 Los Angeles 9 Los Angeles 10 Los Angeles 11 Los Angeles 12 Los Angeles 13 Los Angeles 14 Los Angeles 15 Los Angeles 16 Los Angeles 17 Los Angeles 18 Los Angeles 19 Los Angeles 20 Los Angeles 21 Los Angeles 22 Los Angeles 23 Los Angeles 24 Los Angeles 25 Los Angeles 26 Los Angeles 27 Los Angeles 28 Los Angeles 29 Los Angeles 30 Los Angeles 31 Los Angeles 32 Los Angeles 33 Los Angeles PQR ABC DEF GHI JKL MNO PQR ABC DEF GHI JKL MNO PQR ABC D Year 2015 2016 2017 2018 2019 2020 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 2017 2018 2019 2015 2016 56023 6748 9821 58342 46009 32098 65987 23091 7821 83017 45678 35009 58113 99867 4530 56023 6748 9821 58342 46009 77864 6745 6599 4156 -156 9132 9136 -1050 9298 1997 408 2241 1350 187 5251 4601 4173 7259 4849 1408 6641 3197 -2101 3487 9987 815 -1120 742 1964 -1750 7361 9344 607 DEF GHI JKL MNO PQR ABC DEF

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

Frauds Of The Past Lessons For The Future A Student Led Journey Through The World Of Auditing

Authors: Dr. Manjari Sharma, Mr. Pragadeesh SP, Mr. Sivanaresh A

1st Edition

B0CGKRP289, 978-6206753247

More Books

Students also viewed these Accounting questions

Question

Write formal and informal proposals.

Answered: 1 week ago

Question

Describe the components of a formal report.

Answered: 1 week ago

Question

Write formal and informal reports.

Answered: 1 week ago