Management Help

Using Excel to Pivot Sales Positive Analyze the order transaction data of Play Around Toys Inc. over the past six months to answer the following the questions:

· What is the distribution of sales by region?

· Do customers prefer shopping online or going to the local store? Is this preference region specific?

· Which regions have the higher average of sales?

Click  here  to download the spreadsheet with the list of transactions. Tasks:

· Create pivot tables to answer the above questions.

· Prepare a report of your findings and describe how the company can use this information to increase revenue.

Submission Requirements:

· Submit your answers in a one-page MS Word document.

· Submit the updated spreadsheet.

· Font: Arial; 12-point

· Line Spacing: Double