Exercise_Datalist-PivotTable-Lookup

Exercise_Datalist-PivotTable-Lookup - MGSC 290(Marshall...

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

View Full Document Right Arrow Icon
MGSC 290 (Marshall) Exam 3, Fall 2004 Revised 11-24-04 4ed6c167af2cfd31f9a9e5f36e1418d170fa46e1.xlsx, Documentation Page 1 of 72 MGSC 290 (Marshall) Exercise on Datalists, PivotTables, and Lookup Name: Section: Stay on Target! General Instructions: (1) Save this workbook to your computer hard drive before starting, and then close Blackboard. (2) Complete the worksheets from left to right starting with the one to the right of this one. After completing the instructions for one worksheet, answer the applicable questions on the handout, and then go to the next one. (3) After completing the handout questions, close the completed file and compare it to the solution to see how you did.
Background image of page 1

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

View Full DocumentRight Arrow Icon
MGSC 290 (Marshall) Exam 3, Fall 2004 Revised 11-24-04 4ed6c167af2cfd31f9a9e5f36e1418d170fa46e1.xlsx, 1. Sort-IF Page 2 of 72 Region Product Date Customer Quantity Revenue Profit Profitability West XYZ 3/26/03 Exxon 100 2178 1156 53% Central DEF 11/5/03 Bank of America 900 21033 12177 East DEF 4/13/03 Ford 100 2457 1473 Central DEF 10/16/03 CitiGroup 500 11430 6510 West XYZ 12/10/03 Wal-Mart 800 18560 10384 Central ABC 12/8/03 Exxon 900 15651 8028 West XYZ 9/23/03 Wal-Mart 500 12760 7650 Central ABC 2/9/03 Wal-Mart 500 10385 6150 East XYZ 2/21/03 General Electric 400 8620 4532 Central XYZ 7/5/03 Ford 700 15876 8722 Central XYZ 2/17/03 Phillip Morris 200 4614 2570 West ABC 2/7/03 General Motors 200 3876 2182 Central XYZ 3/16/03 Ford 1000 23090 12870 Central ABC 8/11/03 Ford 300 6156 3615 West ABC 4/12/03 Wal-Mart 400 7376 3988 East DEF 10/12/03 General Electric 700 13797 6909 East DEF 11/25/03 Phillip Morris 500 10760 5840 East DEF 3/15/03 General Motors 1000 20090 10250 Central DEF 12/23/02 Verizon 100 2257 1273 West XYZ 4/23/03 Bank of America 800 19288 11112 West DEF 300 6522 3570 West XYZ 11/19/03 General Electric 300 7569 4503 Central ABC 10/10/03 Ford 1000 21010 12540 East XYZ 2/18/03 Verizon 1000 20490 10270 Central DEF 6/9/03 SBC Communica 1000 22140 12300 Central DEF 10/6/03 IBM 500 11530 6610 Central XYZ 8/16/03 Ford 900 19593 10395 East DEF 6/28/03 Exxon 900 21168 12312 East XYZ 12/25/02 Texaco 400 9152 5064 Central XYZ 2/23/03 Wal-Mart 200 4262 2218 West ABC 11/10/03 General Electric 200 3672 1978 West DEF 4/27/03 Bank of America 400 8052 4116 Central ABC 12/19/03 General Motors 600 10290 5208 Central DEF 5/24/03 IBM 1000 20480 10640 Central DEF 9/29/03 Bank of America 1000 23970 14130 West ABC 1/28/03 IBM 1000 19890 11420 Central XYZ 2/16/03 Wal-Mart 1000 25140 14920 East XYZ 6/23/03 Wal-Mart 900 22716 13518 East DEF 5/20/03 General Motors 700 16408 9520 Central ABC 2/10/03 Exxon 600 11124 6042 West ABC 3/18/03 General Motors 500 9855 5620 West ABC 11/10/03 Wal-Mart 400 6880 3492 Central XYZ 7/24/03 Exxon 900 21159 11961 Desired Profitability Instructions: 1. Sort the list by Region, Product, then Customer, all in ascending order. 2. At H2 enter a formula that will result in the text
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/25/2011 for the course MGSC 290 taught by Professor Johnston during the Fall '09 term at South Carolina.

Page1 / 72

Exercise_Datalist-PivotTable-Lookup - MGSC 290(Marshall...

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

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