Solution for QID #97566: 8 Insert a new row 6 with the row title Midwest and the foll | StudyHelpMe

8 Insert a new row 6 with the row title Midwest and the following sales figures for each quarter : 6 110985.45 and 118674.91 and 100548.50 and 120621.17 Copy the formula in cell F5 down to cell F6 to sum the new row. 9 Using absolute cell references as necessary so that you can copy the formula , in cell G4 10 construct a formula to calculate the Percent of Total Sales for the first region . Copy the formula down for the remaining regions 10 To the computed percentages, apply Percent Style with two decimal places, and then center 8 the percentages 11 Insert Line sparklines in the range H4:H7 that compare the quarterly data . Do not include the 8 totals . Show the sparkline Markers and apply a style to the sparklines using the second style in the second row.