Pivot Table
Download the file sales.xlsx and open it with MS Excel. This file is a sample of 1000 sales transactions for the Expeditioner. For each sale, there is a row recording when it was sold, where it was sold, what was sold, how it was sold, the quantity sold, and the sales revenue.
There will be a sheet called Original Data. This is the data to use for all the pivot tables.
Continue to make Pivot Tables to answer the following questions: One pivot table for each question.
Question
1 What was the value of Phone sales for London in the first quarter?
2 What percent of the total annual sales were Tokyo Web sales in the fourth quarter?
3 What percent of Sydney's annual sales was its Phone sales?
4 What was the value of Phone sales for London in January and give details of the transactions?
5 What was the value of Camel saddle sales for Paris in 2012 by quarter?
6 How many Elephant polo sticks were sold in New York in each month of 2012?
7 What are the five best-selling products based on quantity sold in 2012?
8 What are bottom 5 months that have generated the least sales?
9 What percent of total annual sales was Phone, Web and Store(How it was Sold)?
10 What are the running qty totals per quarter for Hammock?
Attachment:- sales.rar