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
