d . Bold the column headings " Product ", " Unit Price ", " Quantity " and " Total Sales ". e . Add formulas to the Total Sales column to calculate the total sales for each product . f . Add a grand total at the bottom of the Total Sales column , in cell D8 . g . Format the numbers in the Unit Price and Total Sales columns as accounting or currency format with a dollar sign and two decimal places . h . Create a 3-D pie chart on a separate sheet that displays the percentage of total sales for each product & the product name . ( Do not include the grand total in the pie chart !). i . Make the title of the chart & the worksheet tab " Total Sales by Product ". j . Place each product percentage of sales inside its pie slice . k . Place a legend for all products on the right side of the chart . l . Move the sheet named ― Total Sales by Product ‖ with the pie chart immediately after the Q1 & Q2 sheet . m . Save your work ( CTRL + s ) - ( but leave it open to continue ).
2 . Formulas and applications ( TCOs 2 & 7 ; 40 points ). On the Q1 & Q2 sheet , in cell E8 , add a formula using a lookup function that will look up the grand total in cell D8 in the table of sales and assessments in A11 : B13 , and display the corresponding assessment . Use a range lookup . ( For example , if the grand total of $ 12,500 is displayed in cell D8 , " Good " should be displayed in cell E8 .) In cell E9 enter the label Highest Sales . In F9 enter a formula using a function to display the highest total sales value for any product . In cell E10 enter the label Lowest Sales . In F10 enter a formula using a function to display the lowest total sales value for any product . In cell E11 enter the label Average Sales . In F11 enter a formula using a function to display the average total sales value for all products . Format the labels and statistics ( Highest Sales , Lowest Sales , and Average Sales ) to display an outline ( exterior border ) around these cells for readability . Resize all columns for visibility .