BIS 155 Course Great Wisdom / tutorialrank.com BIS 155 Course Great Wisdom / tutorialrank.com | Page 10

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.