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

b. While the sheets are grouped, bold the labels in row 1 and
column A, and format the values in cells B2:E5 as currency with no
decimal places. Resize all columns.
c.

Ungroup the sheets (very important!).

d. On the Q4 Summary sheet, use 3D formulas to create a
summary that displays the totals for each product and quarter over
all 3 regions (East, Central, and West).
e.
Create a clustered column chart that shows total sales of each
product in each quarter. Each cluster should represent a quarter, and
each individual column should represent sales of a product within
that quarter. Place your chart on the Q4 Summary sheet to the right
of the data. Give the chart an appropriate title.
f.
Add a trend line to the chart to show how sales of alarm clocks
are changing over time.
g. In the space provided on the Q4 Summary sheet, write a brief
(2-3 paragraph) analysis report to the manager of the Cool Clocks
business. In your report, explain your findings on the trend in sales of
alarm clocks, and any other patterns you observed in sales of the
product categories; and recommend at least one specific action that
Cool Clocks should take regarding the alarm clocks product line.
Save your work (CTRL+s) - (but leave it open to continue).
5.

What-if analysis (TCO 6; 40 points)

a.
On the Q5 sheet, please format the Title row at the top of the
worksheet stating “Detailed Sales What-if Analysis”. Make sure it is
centered across columns A – G and has a heading format.