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