Copy of 304 Quiz 2 to submit

Copy of 304 Quiz 2 to submit - This Quiz has 2 parts. The...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
The second part is to work up 3 pivot tables based on the instructions on the Pivot table problem worksheet, usin the data from the Pivot table data worksheet. Be sure to format and label, as well as make it as professional and presentable as possible. Please turn in one workbook containing the 4 solutions to the digital drop box. This Quiz has 2 parts. The first is to complete a data table using the information provided on the next worksheet.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
g t.
Background image of page 2
Section: Finan 304 - 001 QUIZ 2 Smith Family's Car Loan Payment Loan amount $20,000.00 Loan term 24 (number of months) Annual Percentage Rate 6% Monthly payment $941.47 (prototype formula) Interest Rates: 5%, 6%, 8%, 10%, 12% Loan Terms (in months): 24, 30, 36, 42, 48, 60, 72 Rates $941.47 5% 6% 8% 10% 12% 24 $941.47 $941.47 $941.47 $941.47 $941.47 30 $941.47 $941.47 $941.47 $941.47 $941.47 Months 36 $941.47 $941.47 $941.47 $941.47 $941.47 42 $941.47 $941.47 $941.47 $941.47 $941.47 48 $941.47 $941.47 $941.47 $941.47 $941.47 60 $941.47 $941.47 $941.47 $941.47 $941.47 72 $941.47 $941.47 $941.47 $941.47 $941.47 Name: Hannah (Hong) Nguyen
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Create pivot tables to do the following: Part One Part Two Part Three Your manager wants to investigate ordering information for the North sales region for May, 2003. Specifically she wants to know the total number of orders (count of Order Size) for each product for each sales person. Your manager wants to investigate shipment information for the Mace product in the 3rd Quarter of 2003. Specifically she wants to know the total number of units shipped (Shipment size) to each sales region from each plant. Be sure to name fields approprately. Your manager wants to investigate shipment information for the West sales region during March of 2004. Specifically she wants to know the total number of units of each product that were shipped (shipment size) by each plant. Be sure to name fields appropriately. Create a Pivot Chart, and make sure to label!!!
Background image of page 4
Section: Finan 304 - 001 Micron Technology INC Count of Order Size for Each Product Each Sales Person in North Region by May 2 Order Year 2003 Order Date May Sales Region North Count of Order Size Product Sales Person Ace Mace Tace Grand Total Brown 1 1 Lopez 1 1 2 Miller 1 1 Smith 1 1 Grand Total 2 2 1 5 Name: Hannah (Hong) Nguyen
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2003
Background image of page 6
Micron Technology INC Shipment Year 2003 Shipment Quarter Qtr3 Product Mace Sum of Shipment Size Plant Sales Region Cleveland Miami Seattle Grand Total East 90 90 North 132 153 115 400 South 129 129 West 129 117 246 Grand Total 480 270 115 865 Number of Units Shipped to Each Sales Region from Each Plant for Mace Product in 3rd Quarter of 2003
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Micron Technology INC Number of Units Shipped for Each Plant in West Region by Product during March, 2004 Shipment Year 2004 Shipment Date Mar Sales Region West Sum of Shipment Size Product Plant Ace Mace Pace Tace Grand Total Miami 108 146 136 108 498 Seattle 132 132 Grand Total 240 146 136 108 630
Background image of page 8
Order Date Product Order Size Shipment Date Shipment Size Sales Person
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 22

Copy of 304 Quiz 2 to submit - This Quiz has 2 parts. The...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online