PowerPoint_3F_Report
Open the file named Student_PowerPoint_3F_Report.pptx downloaded with this project.
On Slide 3, in the content placeholder, insert a Line with Markers chart.
In the worksheet, enter the following data:
In row 1, beginning in cell B1, enter Taxes, City Fees, Capital Grants
In row 2, beginning in cell A2, enter Quarter 1, 8074, 4154, 3525
In row 3, beginning in cell A3, enter Quarter 2, 6380, 3092, 3785
In row 4, beginning in cell A4, enter Quarter 3, 6695, 3260, 4150
In row 5, beginning in cell A5, enter Quarter 4, 7382, 6958, 2795
Apply Chart Style 7, and then apply the Wipe entrance effect to the chart.
Including the parentheses, change the Chart Title to (IN THOUSANDS).
On Slide 4, in the content placeholder, insert a Table with 2 columns and 5 rows.
In the first row enter Item in the first cell and Description in the second cell.
In the second row, in the first cell type Street Improvements and in the second cell, type Monroe Avenue asphalt, signage, and street lighting
In the third row, in the first cell type City Buildings and in the second cell, type Infrastructure upgrades
In the fourth row, in the first cell type Flood Control and in the second cell, type Main Street storm drain replacement
In the fifth row, in the first cell type City Parks and in the second cell, type Monterey Park installation of two baseball diamonds
Change the height of the table to 4.36″. Align the table text so that it is centered horizontally and vertically within the cells.
Apply table style Medium Style 3 – Accent 2, and then apply a Round Bevel effect to the first row. NoteDepending on your version of PowerPoint, this may be named Circle Bevel. Change the Font Size of the text in the first row to 24.
On Slide 5, in the content placeholder, insert a Clustered Column chart. In the worksheet, enter the following data:
In row 1, beginning in cell B1: Year 1, Year 2, Year 3
In row 2, beginning in cell A2: Land, 71534, 72823, 83653
In row 3, beginning in cell A3: Structures, 95746, 95920, 97812
In row 4, beginning in cell A4: Equipment, 35042, 33465, 39767
In row 5, beginning in cell A5: Infrastructure, 111586, 121860, 125873
Apply Chart Style 4 to the chart, and then remove the Chart Title element.
Apply the Wipe entrance effect to the chart. Change the Effect Options so that the animation is applied By Series.
Change the chart animation Timing so that the animation starts After Previous.
Insert a Header & Footer on the Notes and Handouts. Include the Date and time updated automatically, the Page number, and a Footer with the text 3F_Report. Display the document properties. As the Tags, type city council report
Save and close the file, and then submit for grading.
Recent Comments