Formatting and charts ( TCOs 1 , 2 , and 3 ; 30 points ) Using the Documentation sheet :
a . Enter your name and today ' s date . Using the ‘ Quest 1 & 2 ’ worksheet : Adjust the widths of the columns so all data is visible .
Center the title " Music on Demand - Sales by Product " across columns A-D .
Increase the font size to 16 , and change the font color to red .
Bold the column headings " Product ", " Unit Price ", " Quantity ", and " Total Sales ".
Add formulas to the Total Sales column to calculate the total sales for each product .
Add a grand total at the bottom of the Total Sales and Quantity columns .
Format grand totals so that they are easily read .
Format the numbers in the Unit Price and Total Sales columns as accounting or currency format with a dollar sign and two decimal places . Format appropriately .
Correct spelling by using the Spell Check feature .
Create a 3-D pie chart on a separate sheet ( Chart1 ) that displays the total sales for each product . ( Do not include the grand total in the pie chart !)