$2$ On the Net Sales worksheet, calculate totals in the ranges F$4$:F$8$ and B$9$:F$9.$ Apply the Lotal cell style to the range B$9$:F$9.$

$3$ Using absolute cell references as necessary, in cell G$4,$ construct a formula to calculate the

$5$

percent that the Texas Total is of Total Sales, and then apply Percent Style. Fill the formula down through the range $G5$:$G.$

$4$ In the range $H4$:$H8,$ insert Line sparklines to represent the trend of each state across the four quarters. Do not include the totals. Add Markers and then in the first row, apply the first Sparkline style.

$5$ Select the range $A3$:$E8,$ and then use the Recommended Charts command to suggest an

$10$

appropriate chart. Click the first Clustered Column chart that uses the state names as the category axis. Align the upper left corner of the chart inside the upper left comer of cell A$11,$ and then size the chart so that its lower right corner is slightly inside cell $H24.$ Apply chart Style $6.$ As the chart title, type Quarterly Net Sales by State