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

Formatting and charts (TCOs 1, 2, and 3; 30 points) Using the
Documentation sheet:
a. Enter your name and today's date.
Using the ‘Quest 1 & 2’ worksheet:
Adjust the widths of the columns so all data is visible.
Center the title "Music on Demand - Sales by Product" across
columns A-D.
Increase the font size to 16, and change the font color to red.
Bold the column headings "Product", "Unit Price", "Quantity", and
"Total Sales".
Add formulas to the Total Sales column to calculate the total sales
for each product.
Add a grand total at the bottom of the Total Sales and Quantity
columns.
Format grand totals so that they are easily read.
Format the numbers in the Unit Price and Total Sales columns as
accounting or currency format with a dollar sign and two decimal
places. Format appropriately.
Correct spelling by using the Spell Check feature.
Create a 3-D pie chart on a separate sheet (Chart1) that displays the
total sales for each product. (Do not include the grand total in the pie
chart!)