Budget Power Point Presentation

Step

Instructions

Points Possible

1

Start PowerPoint. Download and open the file named pp_ch03_grader_3f_hw_Report.pptx.

0

2

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, 7480, 4154, 2650 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, 8370, 4190, 3970

10

3

Apply Chart Style 7, and then apply the Wipe entrance effect to the chart.

10

4

Including the parentheses, change the Chart Title to (IN THOUSANDS).

10

5

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, enter Flood Control in the first cell and Main Street storm drain replacement in the second cell. In the third row, enter City Buildings in the first cell and Infrastructure upgrades in the second cell. In the fourth row, enter Street Improvements in the first cell and Rio Avenue asphalt, signage, and street lighting in the second cell. In the fifth row, enter City Parks in the first cell and Monterey Park installation of two baseball diamonds in the second cell.

10

6

Change the height of the table to 4.36". Align the table text so that it is centered horizontally and vertically within the cells.

10

7

Apply table style Medium Style 3 - Accent 2, and then apply a Circle Bevel effect to the first row. Change the Font Size of the text in the first row to 24.

10

8

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: 2017, 2018, 2019 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

10

9

Apply Chart Style 4 to the chart, and then remove the Chart Title element.

10

10

Apply the Wipe entrance effect to the chart. Change the Effect Options so that the animation is applied By Series.

10

11

Change the chart animation Timing so that the animation starts After Previous.

8

12

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 Council Report. Display the document properties. As the Tags, type city council report Note, Mac users, instead of Tags, use the Keywords box.

2

13

View the slide show from the beginning. Save and close the presentation. Exit PowerPoint. Submit the file as directed.

0

Total Points

100