CIS Module

Shelley2395
Module3HomeworkFile.xlsx
Home>Computer Science homework help>CIS Module

Instructions

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.

Copy

BALANCE SHEETS
(In millions)
2010 2011
Assets
Current assets:
Cash and cash equivalents 5,505 9,610
Short-term investments (including securities loaned of $1,181 and $62) 31,283 43,162
Total cash, cash equivalents, and short-term investments 36,788 52,772
Accounts receivable, net of allowance for doubtful accounts of $333 and $375 13,014 14,987
Inventories 740 1,372
Deferred income taxes 2,184 2,467
Other 2,950 3,320
Total current assets 55,676 74,918
Property and equipment, net of accumulated depreciation of $9,829 and $8,629 7,630 8,162
Equity and other investments 7,754 10,865
Goodwill 12,394 12,581
Intangible assets, net 1,158 744
Other long-term assets 1,501 1,434
Total assets 86,113 108,704
Liabilities and stockholders’ equity
Current liabilities:
Accounts payable 4,025 4,197
Short-term debt 1,000 0
Accrued compensation 3,283 3,575
Income taxes 1,074 580
Short-term unearned revenue 13,652 15,722
Securities lending payable 182 1,208
Other 2,931 3,492
Total current liabilities 26,147 28,774
Long-term debt 4,939 11,921
Long-term unearned revenue 1,178 1,398
Deferred income taxes 229 1,456
Other long-term liabilities 7,445 8,072
Total liabilities 39,938 51,621
Commitments and contingencies
Stockholders’ equity:
Common stock and paid-in capital – shares authorized 24,000; outstanding 8,376 and 8,668 62,856 63,415
Retained deficit, including accumulated other comprehensive income of $1,863 and $1,055 -16,681 -6,332
Total stockholders’ equity 46,175 57,083
Total liabilities and stockholders’ equity 86,113 108,704

Paste Values

Paste Link

Charts

BALANCE SHEETS
(In millions)
2010 2011
Assets
Current assets:
Cash and cash equivalents 5,505 9,610
Short-term investments (including securities loaned of $1,181 and $62) 31,283 43,162
Total cash, cash equivalents, and short-term investments 36,788 52,772
Accounts receivable, net of allowance for doubtful accounts of $333 and $375 13,014 14,987
Inventories 740 1,372
Deferred income taxes 2,184 2,467
Other 2,950 3,320
Total current assets 55,676 74,918
Property and equipment, net of accumulated depreciation of $9,829 and $8,629 7,630 8,162
Equity and other investments 7,754 10,865
Goodwill 12,394 12,581
Intangible assets, net 1,158 744
Other long-term assets 1,501 1,434
Total assets 86,113 108,704
Liabilities and stockholders’ equity
Current liabilities:
Accounts payable 4,025 4,197
Short-term debt 1,000 0
Accrued compensation 3,283 3,575
Income taxes 1,074 580
Short-term unearned revenue 13,652 15,722
Securities lending payable 182 1,208
Other 2,931 3,492
Total current liabilities 26,147 28,774
Long-term debt 4,939 11,921
Long-term unearned revenue 1,178 1,398
Deferred income taxes 229 1,456
Other long-term liabilities 7,445 8,072
Total liabilities 39,938 51,621
Commitments and contingencies
Stockholders’ equity:
Common stock and paid-in capital – shares authorized 24,000; outstanding 8,376 and 8,668 62,856 63,415
Retained deficit, including accumulated other comprehensive income of $1,863 and $1,055 -16,681 -6,332
Total stockholders’ equity 46,175 57,083
Total liabilities and stockholders’ equity 86,113 108,704

Pivot Data

CategoryID CategoryName ProductName ProductSales
6 Meat/Poultry Alice Mutton 14,123.85
2 Condiments Aniseed Syrup 1,544.00
8 Seafood Boston Crab Meat 9,796.33
4 Dairy Products Camembert Pierrot 22,413.48
8 Seafood Carnarvon Tigers 14,525.00
1 Beverages Chai 5,070.60
1 Beverages Chang 5,817.80
1 Beverages Chartreuse verte 2,295.90
2 Condiments Chef Anton's Cajun Seasoning 5,214.88
2 Condiments Chef Anton's Gumbo Mix 917.62
3 Confections Chocolade 1,282.01
1 Beverages Côte de Blaye 51,569.58
8 Seafood Escargots de Bourgogne 2,913.68
5 Grains/Cereals Filo Mix 2,058.00
4 Dairy Products Fløtemysost 10,433.94
4 Dairy Products Geitost 906.00
2 Condiments Genen Shouyu 1,474.82
5 Grains/Cereals Gnocchi di nonna Alice 30,088.40
4 Dairy Products Gorgonzola Telino 7,188.49
2 Condiments Grandma's Boysenberry Spread 2,500.00
8 Seafood Gravad lax 629.20
1 Beverages Guaraná Fantástica 1,571.62
4 Dairy Products Gudbrandsdalsost 14,041.80
2 Condiments Gula Malacca 6,543.43
3 Confections Gumbär Gummibärchen 11,225.65
5 Grains/Cereals Gustaf's Knäckebröd 4,023.60
8 Seafood Ikura 8,720.30
8 Seafood Inlagd Sill 6,397.11
1 Beverages Ipoh Coffee 10,034.90
8 Seafood Jack's New England Clam Chowder 4,322.72
8 Seafood Konbu 941.34
1 Beverages Lakkalikööri 7,883.10
1 Beverages Laughing Lumberjack Lager 868.00
7 Produce Longlife Tofu 1,186.00
2 Condiments Louisiana Fiery Hot Pepper Sauce 8,117.88
2 Condiments Louisiana Hot Spiced Okra 2,108.00
7 Produce Manjimup Dried Apples 16,024.02
4 Dairy Products Mascarpone Fabioli 2,668.80
3 Confections Maxilaku 3,060.60
6 Meat/Poultry Mishi Kobe Niku 6,935.50
4 Dairy Products Mozzarella di Giovanni 12,427.38
8 Seafood Nord-Ost Matjeshering 5,573.62
2 Condiments Northwoods Cranberry Sauce 3,300.00
3 Confections NuNuCa Nuß-Nougat-Creme 1,058.40
2 Condiments Original Frankfurter grüne Soße 4,711.98
1 Beverages Outback Lager 5,663.40
6 Meat/Poultry Pâté chinois 9,114.48
3 Confections Pavlova 7,180.15
6 Meat/Poultry Perth Pasties 13,832.13
4 Dairy Products Queso Cabrales 5,310.69
4 Dairy Products Queso Manchego La Pastora 8,335.30
4 Dairy Products Raclette Courdavault 32,769.55
5 Grains/Cereals Ravioli Angelo 2,156.70
1 Beverages Rhönbräu Klosterbier 3,670.24
8 Seafood Röd Kaviar 3,517.50
8 Seafood Røgede sild 3,203.40
7 Produce Rössle Sauerkraut 13,691.48
1 Beverages Sasquatch Ale 2,079.00
3 Confections Schoggi Schokolade 9,218.00
3 Confections Scottish Longbreads 3,909.00
5 Grains/Cereals Singaporean Hokkien Fried Mee 4,996.60
3 Confections Sir Rodney's Marmalade 9,711.90
3 Confections Sir Rodney's Scones 4,941.00
2 Condiments Sirop d'érable 8,521.50
8 Seafood Spegesild 3,655.32
1 Beverages Steeleye Stout 5,955.30
3 Confections Tarte au sucre 20,811.32
3 Confections Teatime Chocolate Biscuits 2,339.99
6 Meat/Poultry Thüringer Rostbratwurst 30,038.43
7 Produce Tofu 6,820.38
6 Meat/Poultry Tourtière 3,120.36
5 Grains/Cereals Tunnbröd 2,576.70
7 Produce Uncle Bob's Organic Dried Pears 8,251.80
3 Confections Valkoinen suklaa 2,368.44
2 Condiments Vegie-spread 6,087.69
5 Grains/Cereals Wimmers gute Semmelknödel 7,923.47
3 Confections Zaanse koeken 2,645.75

Apple Data

DATE COMNAM TICKER vwretd RET
31/01/2007 APPLE INC AAPL 0.019428 0.01049
28/02/2007 APPLE INC AAPL -0.013957 -0.013064
30/03/2007 APPLE INC AAPL 0.012949 0.098097
30/04/2007 APPLE INC AAPL 0.039821 0.074158
31/05/2007 APPLE INC AAPL 0.038932 0.214339
29/06/2007 APPLE INC AAPL -0.014756 0.007005
31/07/2007 APPLE INC AAPL -0.031756 0.079646
31/08/2007 APPLE INC AAPL 0.011656 0.051002
28/09/2007 APPLE INC AAPL 0.04086 0.108247
31/10/2007 APPLE INC AAPL 0.025835 0.237701
30/11/2007 APPLE INC AAPL -0.049222 -0.040695
31/12/2007 APPLE INC AAPL -0.004419 0.087038
31/01/2008 APPLE INC AAPL -0.062151 -0.31664
29/02/2008 APPLE INC AAPL -0.021653 -0.076389
31/03/2008 APPLE INC AAPL -0.01042 0.147816
30/04/2008 APPLE INC AAPL 0.051105 0.212195
30/05/2008 APPLE INC AAPL 0.023843 0.085082
30/06/2008 APPLE INC AAPL -0.078434 -0.112901
31/07/2008 APPLE INC AAPL -0.01333 -0.050705
29/08/2008 APPLE INC AAPL 0.010564 0.066562
30/09/2008 APPLE INC AAPL -0.098005 -0.329558
31/10/2008 APPLE INC AAPL -0.184603 -0.053405
28/11/2008 APPLE INC AAPL -0.084615 -0.138675
31/12/2008 APPLE INC AAPL 0.022149 -0.07899
30/01/2009 APPLE INC AAPL -0.077332 0.056005
27/02/2009 APPLE INC AAPL -0.100184 -0.009098
31/03/2009 APPLE INC AAPL 0.086693 0.177024
30/04/2009 APPLE INC AAPL 0.109359 0.197013
29/05/2009 APPLE INC AAPL 0.067789 0.079313
30/06/2009 APPLE INC AAPL -0.003098 0.048745
31/07/2009 APPLE INC AAPL 0.081718 0.14716
31/08/2009 APPLE INC AAPL 0.031466 0.0295
30/09/2009 APPLE INC AAPL 0.045235 0.101896
30/10/2009 APPLE INC AAPL -0.027998 0.016995
30/11/2009 APPLE INC AAPL 0.057099 0.060531
31/12/2009 APPLE INC AAPL 0.028419 0.054134
29/01/2010 APPLE INC AAPL -0.037098 -0.088591
26/02/2010 APPLE INC AAPL 0.034775 0.06538
31/03/2010 APPLE INC AAPL 0.063605 0.14847
30/04/2010 APPLE INC AAPL 0.020011 0.111021
28/05/2010 APPLE INC AAPL -0.079141 -0.016125
30/06/2010 APPLE INC AAPL -0.050721 -0.020827
30/07/2010 APPLE INC AAPL 0.071554 0.022741
31/08/2010 APPLE INC AAPL -0.042818 -0.055005
30/09/2010 APPLE INC AAPL 0.091518 0.167215
29/10/2010 APPLE INC AAPL 0.038532 0.060723
30/11/2010 APPLE INC AAPL 0.005165 0.03379
31/12/2010 APPLE INC AAPL 0.067152 0.03667
31/01/2011 APPLE INC AAPL 0.019157 0.051959
28/02/2011 APPLE INC AAPL 0.038164 0.040935
31/03/2011 APPLE INC AAPL 0.003374 -0.013314
29/04/2011 APPLE INC AAPL 0.028689 0.004656
31/05/2011 APPLE INC AAPL -0.014933 -0.006569
30/06/2011 APPLE INC AAPL -0.018395 -0.03496
29/07/2011 APPLE INC AAPL -0.02247 0.163285
31/08/2011 APPLE INC AAPL -0.057471 -0.014469
30/09/2011 APPLE INC AAPL -0.084873 -0.009121
31/10/2011 APPLE INC AAPL 0.113984 0.061523
30/11/2011 APPLE INC AAPL -0.006225 -0.055783
30/12/2011 APPLE INC AAPL 0.003701 0.059655