100%(4)4 out of 4 people found this document helpful
This preview shows page 1 - 6 out of 20 pages.
This workbook contains some new data for you to practice what you learned in module 3.Copy SheetThis sheet contains data that you will copy.Paste ValuesPaste the data from the copy sheet using the Paste Values command.Adjust the column widths to fully display the data.Paste LinkPaste 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.ChartsCreate 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 DataCreate 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 aApple DataCreate a xy spatter chart from the data on the Apple sheet. Add a trend line and calculate Beta and Slope for the data.
BALANCE SHEETS (In millions)2010AssetsCurrent assets:Cash and cash equivalents5,505Short-term investments (including securities loaned of $1,181 and $62)31,283Total cash, cash equivalents, and short-term investments36,788Accounts receivable, net of allowance for doubtful accounts of $333 and $37513,014Inventories740Deferred income taxes2,184Other2,950Total current assets55,676Property and equipment, net of accumulated depreciation of $9,829 and $8,6297,630Equity and other investments7,754Goodwill12,394Intangible assets, net1,158Other long-term assets1,501Total assets86,113Liabilities and stockholders’ equityCurrent liabilities:Accounts payable4,025Short-term debt1,000Accrued compensation3,283Income taxes1,074Short-term unearned revenue13,652Securities lending payable182Other2,931Total current liabilities26,147Long-term debt4,939Long-term unearned revenue1,178Deferred income taxes229Other long-term liabilities7,445Total liabilities39,938Commitments and contingenciesStockholders’ equity:Common stock and paid-in capital – shares authorized 24,000; outstanding 8,376 and 8,66862,856Retained deficit, including accumulated other comprehensive income of $1,863 and $1,055-16,681Total stockholders’ equity46,175Total liabilities and stockholders’ equity86,113
2010AssetsCurrent assets:Cash and cash equivalents5505Short-term investments (including securities loaned of $1,181 and $62)31283Total cash, cash equivalents, and short-term investments36788Accounts receivable, net of allowance for doubtful accounts of $333 and $37513014Inventories740Deferred income taxes2184Other2950Total current assets55676Property and equipment, net of accumulated depreciation of $9,829 and $8,6297630Equity and other investments7754Goodwill12394Intangible assets, net1158Other long-term assets1501Total assets86113Liabilities and stockholders’ equityCurrent liabilities:Accounts payable4025Short-term debt1000