a. Open e03_exam_chap_data and save the file as e03_exam_chap_LastFirst.

b. Create a 2D pie chart under the data for the number of shares for each investment. Set the chart style to Style 3.

c. Make the following design changes to the chart:

Remove data labels.

Change the Title to Shares Breakdown.

Move the legend to the left side of the pie chart.

Set the legend border to a solid line with the border color set to black.

Explode the Small Cap portion of the chart to 25%. Change the fill color to Standard Red.

d. Create a line chart for the price of Small Cap over the 12-month period. Set the chart style to Style 7 Place the chart to the right of the existing pie chart.

e. Make the following design changes to the chart:

a. Remove the legend.

b. Add a linear trend line.

c. Change the color of trend line to Gold, Accent 4.

f. Insert a new column to the left of Investment named Sparkline.

g. Insert a line style sparkline for each investment over the 12-month period in the Sparkline column.

h. Create a 3D line chart for the price of all three stocks over the 12-month period. Set chart style to Style 1. Place the chart below the existing pie chart.

i. Make the following design changes to the chart:

a. Change horizontal axis labels to the months in row 1.

b. Change chart title to Stocks.

c. Change title of horizontal axis to Months.

d. Change title of vertical axis to Price.

j. Correct the spelling on Small Cap investment. All legends and labels should be automatically updated.

K. Save and close the file. Based on your instructor's directions, submit e03_exam_chap_LastFirst.