Exp19_PowerPoint_Ch03_HOEAssessment_Energy_Saving_Tips Project Description: As an employee of Madison Electric, you give several presentations 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 Exp19_PPT_Ch03_HOEAssessment_Energy.pptx. 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. Saves you money Increases the comfort level indoors Reduces our impact on climate change Reduces pollution 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) • Seal and insulate your home (first image) • Buy energy saving appliances (second image) • Install a programmable thermostat (third image) • Replace incandescent lights (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: SmartArtPicture1.png, SmartArtPicture2.png, SmartArtPicture3.png, and SmartArtPicture4.png. 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: Setting; Col 2: Time; Col 3: Setpoint Temperature (Heat); Col 4: Setpoint Temperature (Cool) Row 2: Col 1: Wake; Col 2: 6:00 a.m.; Col 3: 78° F Row 3: Col 1: Day; Col 2: 8:00 a.m.; Col 3: Setback at least 8° F; Col 4: Setup at least 7° F Row 4: Col 1: Evening; Col 2: 6:00 p.m.; Col 3: 78° F Row 5: Col 1: Sleep; Col 2: 10:00 p.m.; Col 3: Setback at least 8° F; Col 4: Setup at least 4° F 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 00B0 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 Recommended Settings 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 Location and in cell B1 type % of Heat Loss. Then populate A2:B5 with the following values: Roof/Attic 25% Walls 35% Windows/Doors 25% Floor 15% Change the source data to use the range A1:B5. Make the following changes to the clustered column chart: • Apply Chart Style 10 • Type Heat Loss 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 HomeEnergyData.xlsx and save it as HomeEnergyData_LastFirst.xlsx. 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 5.2". Position the chart horizontally at 3.35" and vertically at 2.2". Insert the HomeEnergy.png image on Slide 3. Position the image horizontally at 5.9" and vertically at 3.85". Save and close Exp19_PPT_Ch03_HOEAssessment_Energy.pptx. Exit PowerPoint. Submit the file as directed.