7. Create a Line Chart (Line with Markers) using all of the data. 8. Format the Chart Style to be Style 47. 9. Format the Data Labels to be Center; Show the Data Table; Remove the Legend . 10. Display the Chart Title above the chart. Name the chart Attendance. 11. Format the Primary Vertical Axis to be None; Format the Plot Area as None (No Plot Area fill). 12. Change the chart type to Clustered Columns. Save your work as Excel Practice Activity 2.   Practice Activities Lesson 5: Chart Design and Layout Before You Begin: Start Microsoft Excel 2010. You should see a new, blank spreadsheet. Try This: Do the following steps 1. Enter the following information Expense Cost Rent $2,000 Phone $250 Electricity $200 Supplies $350                 2. Create a 3D exploded pie chart with the data.  3. Apply Chart Layout 6 and Chart Style 13 4. Select the Supplies slice of the pie.  Format the Fill Color white. Format the Shape Outline black. 5. Format the Chart Area of the Pie Chart to be Aqua 6. Go to Sheet 2. Enter the following information.   Event Guests Last Year Guests This Year Breakfast 150 200 Brunch 233 175 Lunch 400 500 Weekend 75 50