$1.$ Open file IL$\_$EX$\_4\_5$ from where you keep your files.

a$.$ Save as IL$\_$EX$\_4\_$Insurance

b$.$ Using a formula add January through March total Personal$$

c$.$ Using a formula add January through March total Business

d$.$ In F$5-$F$7$ create line sparklines representing January through March with Markers

e$.$ In F$9-11$ create column sparklines representing January through March

f$.$ Create a Pie chart for the totals in Personal section. Remember when choosing non adjacent cells use Ctrl$.$Use Personal for the title.$$ For the title use Word Art fill Orange accent color $4$ Soft Bevel.$$ Use quick Layout $2$ with the legend on the right.$$ The life data point should be exploded $30\%.$

g$.$ Create a clustered column chart for the Business Section.$$ For the title use Word Art fill Turquoise Accent color $1$ Shadow Put the legend on the horizonal axis under the chart. Label the Y axis Revenue as well as the title

h$.$ Put your name in the center footer

i$.$ Save