Exp19_PowerPoint_Ch03_HOEAssessment_Energy_Saving_Tips Exp19 PowerPoint Ch03 HOEAssessment Energy Saving Tips PowerPoint Chapter 3 Hands-On Exercise – Energy Saving Tips As an employee of Madison Electric, you give several pr esentations a year on home energy waste and how to save money. You want to update your presentation with new charts, a table and SmartArt graphics. Start PowerPoint. Download and open the file named . Grader has automatically added your last name to the beginning of the filename. On Slide 2, insert a Target List SmartArt graphic. Type the following in the Text pane as first level bullet points. Remove any unneeded bullet points in the Text pane. On Slide 4, click the first picture on the left, press and hold CTRL, and then select each of the remaining pictures moving from left to right. Click Picture Layout and insert a Bending Picture Caption List SmartArt graphic. In the SmartArt Text pane type the text as follows (ensure that the text is next to the appropriate image) • (first image) • (second image) • (third image) • (fourth image) Mac users, delete the four images on the slide, and then insert a Bending Picture Caption List SmartArt graphic. Add a shape to the end to ensure there are four shapes included in the SmartArt graphic. Add the following downloaded images, in the order shown: , , , and . Add the text as instructed. On Slide 2, apply the Inset 3D Style to the SmartArt graphic and change the color to Colorful – Accent Colors. On Slide 4, apply the Inset 3D Style to the SmartArt graphic and change the color to Colorful – Accent Colors. On Slide 6, insert a four column, five row table in the content placeholder. Type the following information into the table: Row 1: Col 1: ; Col 2: ; Col 3: ; Col 4: Row
2: Col 1: ; Col 2: ; Col 3: ; Col 4: Row 3: Col 1: ; Col 2: ; Col 3: ; Col 4: Row 4: Col 1: ; Col 2: ; Col 3: ; Col 4: Row 5: Col 1: ; Col 2: ; Col 3: ; Col 4: Note, to add the degrees symbol (°), click the Symbol arrow in the Symbols group on the Insert tab. In the Symbol dialog box, search for the symbol or type in the Character code box. Mac users, add the degree symbol from the LETTERLIKE SYMBOLS category. Apply the Medium Style 2 – Accent 2 table style. Add a new column to the left of column 1 in the table. Merge the cells in the new column. Type in the new column and rotate all text 270°. Set the cell width of the merged cells to 0.9″. Center the text in the cell. Change the cell shading to Dark Red, Accent 1. Set all of the text in the table to Center Vertically. Change the width of columns 2 and 3 to 2.2″ and the width of columns 4 and 5 to 3.3″. Set the table height to 3.4″. On Slide 5, create a Clustered Column chart with the following data: In cell A1, type and in cell B1 type . Then populate A2:B5 with the following values: Change the source data to use the range A1:B5. Make the following changes to the clustered column chart: • Apply Chart Style 10 • Type as the chart title • Remove the legend and y-axis Change the layout of Slide 3 to Title Only. Start Excel. Download and open the file named and save it as . Copy the chart from the Energy Use worksheet and embed the chart using Paste Special on Slide 3. Mac users, paste the chart as a Microsoft Excel Chart Object. Change the chart height to . Position the chart horizontally at ” and vertically at . Insert the image on Slide 3. Position the image horizontally at and vertically at “. Save and close . Exit PowerPoint. Submit the file as directed.