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 2b 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 20 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. 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 2b 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 20 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
