This workbook contains some new data for you to practice what you learned in module 3. Copy Sheet This sheet contains data that you will copy. Paste Values Paste the data from the copy sheet using the Paste Values command. Adjust the column widths to fully display the data. Paste Link Paste the data from the copy sheet using the Paste Link command. Clean up the worksheet to remove any formulas that reference blank cells. Adjust the column widths to fully display the data. Charts Create two meaningful charts from the data displayed on the charts sheet. Make sure the chart is of an appropriate type for the data you selected. Add a meaningful chart title. Place the charts next to the data at the top of the worksheet. Pivot Data Create a meaningful Pivot table from the data in the Pivot Data worksheet. Use the filter to reduce the amount of information displayed in the Pivot table. Create a meaningful Pivot chart from the data. If you can't make a recommendation or decision from the Pivot table information you need to try again. Apple Data Create a xy spatter chart from the data on the Apple sheet. Add a trend line and calculate Beta and Slope for the data. n you need to try again. BALANCE SHEETS (In millions) 2010 Assets Current assets: Cash and cash equivalents Short-term investments (including securities loaned of $1,181 and $62) Total cash, cash equivalents, and short-term investments Accounts receivable, net of allowance for doubtful accounts of $333 and $375 Inventories Deferred income taxes Other Total current assets Property and equipment, net of accumulated depreciation of $9,829 and $8,629 Equity and other investments Goodwill Intangible assets, net Other long-term assets Total assets Liabilities and stockholders’ equity Current liabilities: Accounts payable Short-term debt Accrued compensation Income taxes Short-term unearned revenue Securities lending payable Other Total current liabilities Long-term debt Long-term unearned revenue Deferred income taxes Other long-term liabilities Total liabilities 5,505 31,283 36,788 13,014 740 2,184 2,950 55,676 7,630 7,754 12,394 1,158 1,501 86,113 4,025 1,000 3,283 1,074 13,652 182 2,931 26,147 4,939 1,178 229 7,445 39,938 Commitments and contingencies Stockholders’ equity: Common stock and paid-in capital – shares authorized 24,000; outstanding 8,376 and 8,668 62,856 Retained deficit, including accumulated other comprehensive income of $1,863 and $1,055 -16,681 46,175 86,113 Total stockholders’ equity Total liabilities and stockholders’ equity 2011 9,610 43,162 52,772 14,987 1,372 2,467 3,320 74,918 8,162 10,865 12,581 744 1,434 108,704 4,197 0 3,575 580 15,722 1,208 3,492 28,774 11,921 1,398 1,456 8,072 51,621 63,415 -6,332 57,083 108,704 BALANCE SHEETS (In millions) 2010 Assets Current assets: Cash and cash equivalents Short-term investments (including securities loaned of $1,181 and $62) Total cash, cash equivalents, and short-term investments Accounts receivable, net of allowance for doubtful accounts of $333 and $375 Inventories Deferred income taxes Other Total current assets Property and equipment, net of accumulated depreciation of $9,829 and $8,629 Equity and other investments Goodwill Intangible assets, net Other long-term assets Total assets Liabilities and stockholders’ equity Current liabilities: Accounts payable Short-term debt Accrued compensation Income taxes Short-term unearned revenue Securities lending payable Other Total current liabilities Long-term debt Long-term unearned revenue Deferred income taxes Other long-term liabilities Total liabilities 5,505 31,283 36,788 13,014 740 2,184 2,950 55,676 7,630 7,754 12,394 1,158 1,501 86,113 4,025 1,000 3,283 1,074 13,652 182 2,931 26,147 4,939 1,178 229 7,445 39,938 Commitments and contingencies Stockholders’ equity: Common stock and paid-in capital – shares authorized 24,000; outstanding 8,376 and 8,668 Retained deficit, including accumulated other comprehensive income of $1,863 and $1,055 Total stockholders’ equity Total liabilities and stockholders’ equity 62,856 -16,681 46,175 86,113 2011 9,610 43,162 52,772 14,987 1,372 2,467 3,320 74,918 8,162 10,865 12,581 744 1,434 108,704 4,197 0 3,575 580 15,722 1,208 3,492 28,774 11,921 1,398 1,456 8,072 51,621 63,415 -6,332 57,083 108,704 CategoryID CategoryName 6 Meat/Poultry 2 Condiments 8 Seafood 4 Dairy Products 8 Seafood 1 Beverages 1 Beverages 1 Beverages 2 Condiments 2 Condiments 3 Confections 1 Beverages 8 Seafood 5 Grains/Cereals 4 Dairy Products 4 Dairy Products 2 Condiments 5 Grains/Cereals 4 Dairy Products 2 Condiments 8 Seafood 1 Beverages 4 Dairy Products 2 Condiments 3 Confections 5 Grains/Cereals 8 Seafood 8 Seafood 1 Beverages 8 Seafood 8 Seafood 1 Beverages 1 Beverages 7 Produce 2 Condiments 2 Condiments 7 Produce 4 Dairy Products 3 Confections 6 Meat/Poultry 4 Dairy Products 8 Seafood 2 Condiments 3 Confections 2 Condiments 1 Beverages ProductName Alice Mutton Aniseed Syrup Boston Crab Meat Camembert Pierrot Carnarvon Tigers Chai Chang Chartreuse verte Chef Anton's Cajun Seasoning Chef Anton's Gumbo Mix Chocolade Côte de Blaye Escargots de Bourgogne Filo Mix Fløtemysost Geitost Genen Shouyu Gnocchi di nonna Alice Gorgonzola Telino Grandma's Boysenberry Spread Gravad lax Guaraná Fantástica Gudbrandsdalsost Gula Malacca Gumbär Gummibärchen Gustaf's Knäckebröd Ikura Inlagd Sill Ipoh Coffee Jack's New England Clam Chowder Konbu Lakkalikööri Laughing Lumberjack Lager Longlife Tofu Louisiana Fiery Hot Pepper Sauce Louisiana Hot Spiced Okra Manjimup Dried Apples Mascarpone Fabioli Maxilaku Mishi Kobe Niku Mozzarella di Giovanni Nord-Ost Matjeshering Northwoods Cranberry Sauce NuNuCa Nuß-Nougat-Creme Original Frankfurter grüne Soße Outback Lager ProductSales 14,123.85 1,544.00 9,796.33 22,413.48 14,525.00 5,070.60 5,817.80 2,295.90 5,214.88 917.62 1,282.01 51,569.58 2,913.68 2,058.00 10,433.94 906.00 1,474.82 30,088.40 7,188.49 2,500.00 629.20 1,571.62 14,041.80 6,543.43 11,225.65 4,023.60 8,720.30 6,397.11 10,034.90 4,322.72 941.34 7,883.10 868.00 1,186.00 8,117.88 2,108.00 16,024.02 2,668.80 3,060.60 6,935.50 12,427.38 5,573.62 3,300.00 1,058.40 4,711.98 5,663.40 6 3 6 4 4 4 5 1 8 8 7 1 3 3 5 3 3 2 8 1 3 3 6 7 6 5 7 3 2 5 3 Meat/Poultry Confections Meat/Poultry Dairy Products Dairy Products Dairy Products Grains/Cereals Beverages Seafood Seafood Produce Beverages Confections Confections Grains/Cereals Confections Confections Condiments Seafood Beverages Confections Confections Meat/Poultry Produce Meat/Poultry Grains/Cereals Produce Confections Condiments Grains/Cereals Confections Pâté chinois Pavlova Perth Pasties Queso Cabrales Queso Manchego La Pastora Raclette Courdavault Ravioli Angelo Rhönbräu Klosterbier Röd Kaviar Røgede sild Rössle Sauerkraut Sasquatch Ale Schoggi Schokolade Scottish Longbreads Singaporean Hokkien Fried Mee Sir Rodney's Marmalade Sir Rodney's Scones Sirop d'érable Spegesild Steeleye Stout Tarte au sucre Teatime Chocolate Biscuits Thüringer Rostbratwurst Tofu Tourtière Tunnbröd Uncle Bob's Organic Dried Pears Valkoinen suklaa Vegie-spread Wimmers gute Semmelknödel Zaanse koeken 9,114.48 7,180.15 13,832.13 5,310.69 8,335.30 32,769.55 2,156.70 3,670.24 3,517.50 3,203.40 13,691.48 2,079.00 9,218.00 3,909.00 4,996.60 9,711.90 4,941.00 8,521.50 3,655.32 5,955.30 20,811.32 2,339.99 30,038.43 6,820.38 3,120.36 2,576.70 8,251.80 2,368.44 6,087.69 7,923.47 2,645.75 DATE COMNAM 31/01/2007APPLE INC 28/02/2007APPLE INC 30/03/2007APPLE INC 30/04/2007APPLE INC 31/05/2007APPLE INC 29/06/2007APPLE INC 31/07/2007APPLE INC 31/08/2007APPLE INC 28/09/2007APPLE INC 31/10/2007APPLE INC 30/11/2007APPLE INC 31/12/2007APPLE INC 31/01/2008APPLE INC 29/02/2008APPLE INC 31/03/2008APPLE INC 30/04/2008APPLE INC 30/05/2008APPLE INC 30/06/2008APPLE INC 31/07/2008APPLE INC 29/08/2008APPLE INC 30/09/2008APPLE INC 31/10/2008APPLE INC 28/11/2008APPLE INC 31/12/2008APPLE INC 30/01/2009APPLE INC 27/02/2009APPLE INC 31/03/2009APPLE INC 30/04/2009APPLE INC 29/05/2009APPLE INC 30/06/2009APPLE INC 31/07/2009APPLE INC 31/08/2009APPLE INC 30/09/2009APPLE INC 30/10/2009APPLE INC 30/11/2009APPLE INC 31/12/2009APPLE INC 29/01/2010APPLE INC 26/02/2010APPLE INC 31/03/2010APPLE INC 30/04/2010APPLE INC 28/05/2010APPLE INC 30/06/2010APPLE INC 30/07/2010APPLE INC 31/08/2010APPLE INC 30/09/2010APPLE INC 29/10/2010APPLE INC TICKER AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL vwretd 0.019428 -0.01396 0.012949 0.039821 0.038932 -0.01476 -0.03176 0.011656 0.04086 0.025835 -0.04922 -0.00442 -0.06215 -0.02165 -0.01042 0.051105 0.023843 -0.07843 -0.01333 0.010564 -0.09801 -0.1846 -0.08462 0.022149 -0.07733 -0.10018 0.086693 0.109359 0.067789 -0.0031 0.081718 0.031466 0.045235 -0.028 0.057099 0.028419 -0.0371 0.034775 0.063605 0.020011 -0.07914 -0.05072 0.071554 -0.04282 0.091518 0.038532 RET 0.01049 -0.01306 0.098097 0.074158 0.214339 0.007005 0.079646 0.051002 0.108247 0.237701 -0.0407 0.087038 -0.31664 -0.07639 0.147816 0.212195 0.085082 -0.1129 -0.05071 0.066562 -0.32956 -0.05341 -0.13868 -0.07899 0.056005 -0.0091 0.177024 0.197013 0.079313 0.048745 0.14716 0.0295 0.101896 0.016995 0.060531 0.054134 -0.08859 0.06538 0.14847 0.111021 -0.01613 -0.02083 0.022741 -0.05501 0.167215 0.060723 30/11/2010APPLE INC 31/12/2010APPLE INC 31/01/2011APPLE INC 28/02/2011APPLE INC 31/03/2011APPLE INC 29/04/2011APPLE INC 31/05/2011APPLE INC 30/06/2011APPLE INC 29/07/2011APPLE INC 31/08/2011APPLE INC 30/09/2011APPLE INC 31/10/2011APPLE INC 30/11/2011APPLE INC 30/12/2011APPLE INC AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL AAPL 0.005165 0.067152 0.019157 0.038164 0.003374 0.028689 -0.01493 -0.0184 -0.02247 -0.05747 -0.08487 0.113984 -0.00623 0.003701 0.03379 0.03667 0.051959 0.040935 -0.01331 0.004656 -0.00657 -0.03496 0.163285 -0.01447 -0.00912 0.061523 -0.05578 0.059655
Purchase answer to see full attachment