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 .
In cell E18 , add a formula using a lookup function that will look up the grand total in cell D18 in the table of sales and assessments in A22 : B25 , and display the corresponding assessment . ( For example , if the grand total of $ 505 is displayed in cell D18 , " Good " should be displayed in cell E18 .)
In cell E19 add the label Highest Sales . In F19 add the function formula for Maximum based on the Total Sales column .
In cell E20 add the label Lowest Sales . In F20 add the function formula for Minimum based on the Total Sales column .
In cell E21 add the label Average Sales . In F21 add the function formula for Average based on the Total Sales column .