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 . b . Enter formulas in cells B6 , B7 , and B8 to calculate the total sales , total cost , and net income for a new product line , based on the projected unit sales , unit price and unit cost provided . c . Adjust column widths as needed and format all values except unit sales as currency with no decimal places . d . Complete the one-variable data table under the heading ― Effect of Varying Unit Sales on Total Sales , Total Cost , and Net Income ‖ to calculate the total sales , total cost and net income for projected sales of 80 , 90 , 100 , 110 , and 120 units . e . Complete the two-variable data table under the heading ― Effect on Net Income of Varying Unit Sales and Unit Price ‖ to calculate the