Questions / Problems 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 !) Move the chart to a new worksheet titled ― Chart 1 ‖. Make the title of the chart " Total Sales by Product ". Place each product name and its percentage of sales at or inside its pie slice , with product names off to the right as well . Move the Chart1 pie chart worksheet immediately after the Quest 1 & 2 sheet . Save your work ( CTRL + s ). Formulas , applications and statistical functions ( TCOs 2 , 3 , 6 , and 10 ; 30 points ) Using the ‗ Quest 1 & 2 ‘ worksheet . Draw a box around the table at A22-B25 , with a light shading color for the column labels .