Reference no: EM133176984
How do I generate the following ten results using pivot tables on excel? What steps i have to use?
1)Show the sum of Sales for Customer Segment = Small Business and Region = Ontario
2) Show the sum of Sales for Region = West and Province = Alberta, separately for each month from 1/2019 to 5/2019 (use Order Date)
3) Show the 10 customers who have the highest sum of Sales during 2017 (use Ship Date)
4) Show all orders (use Order ID) and the Sales for Product Category is Technology
5) From the Region with the highest sum of Sales, show the five Product Sub-Categories with the highest sum of Sales
6) Show the average Sales value for each combination of Province and Order Priority
7) Show the average Sales value for each combination of Ship Mode and Product Category
8) For each Region, show the sum of Sales separately for each month from 1/2020 to 6/2020 (use Order Date)
9) For the entire year 2019, show each Region's sum of Sales as a percentage of the sum of all Sales during the year (use Ship Date)
10) Show the 10 largest Order Quantities where Product Container = Jumbo Box and Order Priority = Low
|
Case-mehdi department store
: Hassan Moe, the Manager at Mehdi's, understands the importance of a department store's sales force, especially when it comes to the sales force of a premiere, u
|
|
Talent management planning process
: Describe opportunities for improvement in the talent management planning process.
|
|
What are the decision variables
: Expansion Draft sells for $20 per barrel, while Burning River sells for $8 per barrel. What are the decision variables? What is the objective function
|
|
Determining the tax treatment of the distributions
: Pebble Corporation, an accrual basis taxpayer, has struggled to survive since its formation six years ago. Determining the tax treatment of the distributions
|
|
Generate the ten results using pivot tables on excel
: How do I generate the following ten results using pivot tables on excel? What steps i have to use?
|
|
Calculate interest expense for the year on the bonds
: The bonds were issued on January 1 and pay interest on June 30 and December 31. Calculate interest expense for the year on the bonds
|
|
Develop a linear optimization model
: Develop a linear optimization model to determine how many of each type of desk the ABCD company should make next week to maximize profit contribution
|
|
What is the discounted value
: Question - What is the discounted value of $5,800.00 paid every 12 months for 13 years if interest is 2.62% compounded semi-annually
|
|
What is the present value of your tuition
: If you pay your law school tuition at the beginning of each year, what is the present value of your tuition, assuming a discount rate of percent
|