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

BIS 155 iLab 8 (Week 7) Descriptive statistics, formatting, graphs, and
regression analysis
=========================================

BIS 155 Final Exam Guide (Cool Clocks, Inc.)
For more course tutorials visit

www.tutorialrank.com

BIS155 Practical Final Exam Instructions 1 for Cool Clocks, Inc. (v2)
Complete the tasks below using Microsoft Excel. You may refer to
your notes, the textbook, or other resources (for example, you may
search the Web for information). You may not get interactive help
from any other person (either in person or via email, text messaging,
IM, or other communications channels). I strongly recommend that
you save your work frequently.
1.

Formatting and charts (TCOs 1 & 3; 40 points)

a.

Enter your name and today's date on the Documentation sheet

b. Select the Q1&Q2 sheet, and adjust the widths of the columns
as needed
c.
Center the title "Cool Clock, Inc. Sales by Product" across
columns A-D, increase the font size to 20, and change the font color
to red.
d. Bold the column headings "Product", "Unit Price", "Quantity"
and "Total Sales".