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 .
Add comments to cells F9 , F10 , and F11 . In your comments , explain briefly in your own words what is displayed in each cell .
Add gridlines and cell formatting and color formatting to cells A10 : B13 .
Add a top and double bottom border to cell D8 .
Protect the worksheet so the contents cannot be accidentally changed by a user . Do not use a password .
Save your work ( CTRL + s ) - ( but leave it open to continue ).
3 . Data cleansing , lists , sorting , conditional formatting , and pivot tables ( TCOs 4 & 8 ; 40 points ).
On the Q3 sheet , adjust the widths of the columns as needed .
Column C contains each customer ’ s combined first and last name . Insert two empty columns to the right of column C , and use an Excel feature to separate the customers ’ first names and last names into