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