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 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. Pivot Data 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. 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. BALANCE SHEETS (In millions) \begin{tabular}{l|l} 3 & \\ \hline & Assets \end{tabular} 20102011 5 Current assets: 21. Current liabilities: 36 Stockholders' equity. 37 Common stock and paid-in capital - shares authonzed 24,000 36. Stockholders' equity: 37. Common stock and paid-in capital - shares authorized 24,000 ; outstanding 8,376 and 8,66862,85663,415 40 Total liabilities and stockholders' equity 41 \begin{tabular}{rr} 46,175 & 57,083 \\ \hline 86,113 & 108,704 \\ \hline \end{tabular} \begin{tabular}{l|lrr|} 38 & 29/01/201 APPLE INCAAPL & -0.0371 & -0.08859 \\ \hline 39 & 26/02/201 APPLE INC AAPL & 0.034775 & 0.06538 \\ \hline 40 & 31/03/201 APPLE INC AAPL & 0.063605 & 0.14847 \\ \hline 41 & 30/04/201 APPLE INC AAPL & 0.020011 & 0.111021 \\ \hline 42 & 28/05/201 APPLE INC AAPL & -0.07914 & -0.01613 \\ \hline 43 & 30/06/201 APPLE INC AAPL & -0.05072 & -0.02083 \\ \hline 44 & 30/07/201 APPLE INC AAPL & 0.071554 & 0.022741 \\ \hline 45 & 31/08/201 APPLE INC AAPL & -0.04282 & -0.05501 \\ \hline 46 & 30/09/201 APPLE INCAAPL & 0.091518 & 0.167215 \\ \hline 47 & 29/10/201 APPLE INCAAPL & 0.038532 & 0.060723 \\ \hline 48 & 30/11/201 APPLE INCAAPL & 0.005165 & 0.03379 \\ \hline 49 & 31/12/201 APPLE INC AAPL & 0.067152 & 0.03667 \\ \hline 50 & 31/01/201 APPLE INC AAPL & 0.019157 & 0.051959 \\ \hline 51 & 28/02/201 APPLE INC AAPL & 0.038164 & 0.040935 \\ \hline 52 & 31/03/201 APPLE INC AAPL & 0.003374 & -0.01331 \\ \hline 53 & 29/04/201 APPLE INC AAPL & 0.028689 & 0.004656 \\ \hline 54 & 31/05/201 APPLE INC AAPL & -0.01493 & -0.00657 \\ \hline 55 & 30/06/201 APPLE INC AAPL & -0.0184 & -0.03496 \\ \hline 56 & 29/07/201 APPLE INC AAPL & -0.02247 & 0.163285 \\ 57 & 31/08/201 APPLE INC AAPL & -0.05747 & -0.01447 \\ 58 & 30/09/201 APPLE INC AAPL & -0.08487 & -0.00912 \\ 59 & 31/10/201 APPLE INC AAPL & 0.113984 & 0.061523 \\ 60 & 30/11/201 APPLE INC AAPL & -0.00623 & -0.05578 \\ 61 & 30/12/201 APPLE INC AAPL & 0.003701 & 0.059655 \\ 62 & & 0.0390 \\ \hline \end{tabular} 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 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. Pivot Data 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. 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. BALANCE SHEETS (In millions) \begin{tabular}{l|l} 3 & \\ \hline & Assets \end{tabular} 20102011 5 Current assets: 21. Current liabilities: 36 Stockholders' equity. 37 Common stock and paid-in capital - shares authonzed 24,000 36. Stockholders' equity: 37. Common stock and paid-in capital - shares authorized 24,000 ; outstanding 8,376 and 8,66862,85663,415 40 Total liabilities and stockholders' equity 41 \begin{tabular}{rr} 46,175 & 57,083 \\ \hline 86,113 & 108,704 \\ \hline \end{tabular} \begin{tabular}{l|lrr|} 38 & 29/01/201 APPLE INCAAPL & -0.0371 & -0.08859 \\ \hline 39 & 26/02/201 APPLE INC AAPL & 0.034775 & 0.06538 \\ \hline 40 & 31/03/201 APPLE INC AAPL & 0.063605 & 0.14847 \\ \hline 41 & 30/04/201 APPLE INC AAPL & 0.020011 & 0.111021 \\ \hline 42 & 28/05/201 APPLE INC AAPL & -0.07914 & -0.01613 \\ \hline 43 & 30/06/201 APPLE INC AAPL & -0.05072 & -0.02083 \\ \hline 44 & 30/07/201 APPLE INC AAPL & 0.071554 & 0.022741 \\ \hline 45 & 31/08/201 APPLE INC AAPL & -0.04282 & -0.05501 \\ \hline 46 & 30/09/201 APPLE INCAAPL & 0.091518 & 0.167215 \\ \hline 47 & 29/10/201 APPLE INCAAPL & 0.038532 & 0.060723 \\ \hline 48 & 30/11/201 APPLE INCAAPL & 0.005165 & 0.03379 \\ \hline 49 & 31/12/201 APPLE INC AAPL & 0.067152 & 0.03667 \\ \hline 50 & 31/01/201 APPLE INC AAPL & 0.019157 & 0.051959 \\ \hline 51 & 28/02/201 APPLE INC AAPL & 0.038164 & 0.040935 \\ \hline 52 & 31/03/201 APPLE INC AAPL & 0.003374 & -0.01331 \\ \hline 53 & 29/04/201 APPLE INC AAPL & 0.028689 & 0.004656 \\ \hline 54 & 31/05/201 APPLE INC AAPL & -0.01493 & -0.00657 \\ \hline 55 & 30/06/201 APPLE INC AAPL & -0.0184 & -0.03496 \\ \hline 56 & 29/07/201 APPLE INC AAPL & -0.02247 & 0.163285 \\ 57 & 31/08/201 APPLE INC AAPL & -0.05747 & -0.01447 \\ 58 & 30/09/201 APPLE INC AAPL & -0.08487 & -0.00912 \\ 59 & 31/10/201 APPLE INC AAPL & 0.113984 & 0.061523 \\ 60 & 30/11/201 APPLE INC AAPL & -0.00623 & -0.05578 \\ 61 & 30/12/201 APPLE INC AAPL & 0.003701 & 0.059655 \\ 62 & & 0.0390 \\ \hline \end{tabular}