Excel module three - This workbook contains some new data...

This preview shows page 1 - 4 out of 7 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 again.Apple 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)20102011AssetsCurrent assets:Cash and cash equivalents5,5059,610Short-term investments (including securities loaned of $1,181 and $62)31,28343,162Total cash, cash equivalents, and short-term investments36,78852,772Accounts receivable, net of allowance for doubtful accounts of $333 and $37513,01414,987Inventories7401,372Deferred income taxes2,1842,467Other2,9503,320Total current assets55,67674,918Property and equipment, net of accumulated depreciation of $9,829 and $8,6297,6308,162Equity and other investments7,75410,865Goodwill12,39412,581Intangible assets, net1,158744Other long-term assets1,5011,434Total assets86,113108,704Liabilities and stockholders’ equityCurrent liabilities:Accounts payable4,0254,197Short-term debt1,0000Accrued compensation3,2833,575Income taxes1,074580Short-term unearned revenue13,65215,722Securities lending payable1821,208Other2,9313,492Total current liabilities26,14728,774Long-term debt4,93911,921Long-term unearned revenue1,1781,398Deferred income taxes2291,456Other long-term liabilities7,4458,072Total liabilities39,93851,621Commitments and contingenciesStockholders’ equity:Common stock and paid-in capital – shares authorized 24,000; outstanding 8,376 and 8,66862,85663,415Retained deficit, including accumulated other comprehensive income of $1,863 and $1,055-16,681-6,332Total stockholders’ equity46,17557,083Total liabilities and stockholders’ equity86,113108,704
BALANCE SHEETS (In millions)20102011AssetsCurrent assets:Cash and cash equivalents55059610Short-term investments (including securities loaned of $1,181 and $62)3128343162Total cash, cash equivalents, and short-term investments3678852772Accounts receivable, net of allowance for doubtful accounts of $333 and $3751301414987Inventories7401372

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture