Excel 3-Activity 2 - Imbedded Pie Charts 1. Open the Excel 3 Activity 2 Weekly Sales Pie Chart file from the shared drive. 2. Save the file as 21_Activity Activity2 3. to your student drive in your Excel 3 folder. 4. Upciate the header and footer in class format. 5. Update your document properties. 6. Highlight the cells A3:A7 and using the CTRL key, highlight 13:17. 7. Insert a 30 pie chart from the insert menu and move and resize it so it goes from the top of A10 to the bottom of 125. 8. Remove the legend by going to the Layout tab, click on the Legend button and choose none. 9. Add data labels to the outside of each pie piece, and category names by a. Click on the Layout tab b. Click on Data Labels c. Choose More Data Label Options at the bottom of the menu. d. Click on Category Name e. Remove the check from Value 1. Click on Percentage & Leave the check on Leader Lines h. Click on Outside End in Label Position 1. Click on Close 10. Select cells 83:H3 go to insert tab, Sparklines group, click Line 11. The Data Range should be already completed for you. In the Location Range, type cell 3. Click OK. 12. Highlight 84 H4 and add a column Sparkline to cell 14. 13. Select cell 34 in the Design tab Sparkline color-choose Red, Accent 2, Darker 25% 14. Highlight B5:HS and add a Win/Loss Sparkline to cell 15. 15. Select cell J5 in the Design tab Sparkline color-choose Olive Green, Accent 3, Darker 2596 16. Go to print preview and compare with the key below. Make any corrections as needed. Re save. Save the sheet in pdf format. 17. Using this chart, answer question #2 on the Chart Analysis Worksheet of your listening guide. Weekly Sales Report May 5-11 KEY