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

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