Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the cell contents (not the value, what shows in the formula bar) of cell A2 on the Paste Link tab? Be specific, include
What is the cell contents (not the value, what shows in the formula bar) of cell A2 on the Paste Link tab? Be specific, include all punctuation, if applicable. BALANCE SHEETS (In millions) 20102011 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 recelvable, 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 Commitments and contingencies \begin{tabular}{rr} 5,505 & 9,610 \\ 31,283 & 43,162 \\ \hline 36,788 & 52,772 \\ 13,014 & 14,987 \\ 740 & 1,372 \\ 2,184 & 2,467 \\ 2,950 & 3,320 \\ \hline 55,676 & 74,918 \\ 7,630 & 8,162 \\ 7,754 & 10,865 \\ 12,394 & 12,581 \\ 1,158 & 744 \\ 1,501 & 1,434 \\ \hline 86,113 & 108,704 \\ \hline \hline \end{tabular} 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 \begin{tabular}{rr} 4,025 & 4,197 \\ 1,000 & 0 \\ 3,283 & 3,575 \\ 1,074 & 580 \\ 13,652 & 15,722 \\ 182 & 1,208 \\ 2,931 & 3,492 \\ \hline 26,147 & 28,774 \\ 4,939 & 11,921 \\ 1,178 & 1,398 \\ 229 & 1,456 \\ 7,445 & 8,072 \\ \hline 39,938 & 51,621 \\ \hline \hline \end{tabular} \begin{tabular}{rr} 62,856 & 63,415 \\ 16,681 & 6,332 \\ 46,175 & 57,083 \\ \hline 86,113 & 108,704 \\ \hline \hline \end{tabular} This workbook contains some new data for you to practice what you learned in module 3 . This sheet contains data that you will copy. Paste the data from the copy sheet using the Paste Values command. Adjust the column widths to fully display the data. 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. Create a 2D Clustered bar chart of the individual Assets for 2010 and 2011. Create a 3D Clustered column chart of the individual 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. Insert a pivot table and column 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. Create 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 What is the cell contents (not the value, what shows in the formula bar) of cell A2 on the Paste Link tab? Be specific, include all punctuation, if applicable. BALANCE SHEETS (In millions) 20102011 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 recelvable, 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 Commitments and contingencies \begin{tabular}{rr} 5,505 & 9,610 \\ 31,283 & 43,162 \\ \hline 36,788 & 52,772 \\ 13,014 & 14,987 \\ 740 & 1,372 \\ 2,184 & 2,467 \\ 2,950 & 3,320 \\ \hline 55,676 & 74,918 \\ 7,630 & 8,162 \\ 7,754 & 10,865 \\ 12,394 & 12,581 \\ 1,158 & 744 \\ 1,501 & 1,434 \\ \hline 86,113 & 108,704 \\ \hline \hline \end{tabular} 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 \begin{tabular}{rr} 4,025 & 4,197 \\ 1,000 & 0 \\ 3,283 & 3,575 \\ 1,074 & 580 \\ 13,652 & 15,722 \\ 182 & 1,208 \\ 2,931 & 3,492 \\ \hline 26,147 & 28,774 \\ 4,939 & 11,921 \\ 1,178 & 1,398 \\ 229 & 1,456 \\ 7,445 & 8,072 \\ \hline 39,938 & 51,621 \\ \hline \hline \end{tabular} \begin{tabular}{rr} 62,856 & 63,415 \\ 16,681 & 6,332 \\ 46,175 & 57,083 \\ \hline 86,113 & 108,704 \\ \hline \hline \end{tabular} This workbook contains some new data for you to practice what you learned in module 3 . This sheet contains data that you will copy. Paste the data from the copy sheet using the Paste Values command. Adjust the column widths to fully display the data. 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. Create a 2D Clustered bar chart of the individual Assets for 2010 and 2011. Create a 3D Clustered column chart of the individual 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. Insert a pivot table and column 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. Create 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started