Module 3 Excel Assessment -.xls - This workbook contains...

This preview shows page 1 - 5 out of 16 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 a 2D Clustered bar chart of the Assets for 2010 and 2011.Create a 3D Clustered column chart of the Liabilities for 2010 and 2011.Add chart titles (Assets and Liabilities, respectively) and include legends for 2010 and 2011.Place the charts next to the data at the top of the worksheet.Pivot DataInsert a pivot table and pivot chart showing the total sales by category name.Change the pivot table headers to Category and Total Sales.Format the Total Sales as Currency.Make your pivot chart title "Total Sales by Category" and have no legend.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)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
20119,61043,16252,77214,9871,3722,4673,32074,9188,16210,86512,5817441,434108,7044,19703,57558015,7221,2083,49228,77411,9211,3981,4568,07251,62163,415-6,33257,083108,704
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,184

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture