PowerPoint_3F_Advertising_Report
Open the file named Student_PowerPoint_3F_Advertising_Report.pptx downloaded with this project.
On Slide 3, in the content placeholder, insert a Line with Markers chart. In the worksheet, in the first row, enter the following data:
In row 1, beginning in cell B1: 2020, 2021, 2022
In row 2, beginning in cell A2: 18-30, 12, 10, 11
In row 3, beginning in cell A3:31-45, 40, 45, 38
In row 4, beginning in cell A4: 46-55, 16, 19, 26
In row 5, beginning in cell A5: 56+, 32, 26, 25
Apply Chart Style 6, and then apply the Wipe entrance animation to the chart.
Change the Chart Title to (Percentages)
On Slide 4, in the content placeholder, insert a Table with 2 columns and 4 rows.
In the first row, enter Demographic in the first cell and Description in the second cell.
In the second row, enter Gender in the first cell and 65% Female in the second cell.
In the third row, enter Median Household Income in the first cell and $87,200 in the second cell.
In the fourth row, enter Education in the first cell and 46.9% hold a college degree in the second cell.
Change the height of the table to 4.77″. Align the table text so that it is centered horizontally and vertically within the cells and then change the Font Size of all of the text in the table to 24.
Apply table style Medium Style 3 – Accent 2, and then apply a Round Bevel effect to the first row.
Note, depending on the version of Office used, the bevel effect may be named Circle.
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: 2020, 2021, 2022
In row 2, beginning in cell A2: Quarter 1, 182534, 165823, 201653
In row 3, beginning in cell A3: Quarter 2, 175746, 195920, 197812
In row 4, beginning in cell A4: Quarter 3, 195042, 203465, 189767
In row 5, beginning in cell A5: Quarter 4, 201586, 221860, 245873
Apply Chart Style 8 to the chart, and then remove the Chart Title element.
Apply the Wipe entrance animation 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_Advertising_Report Display the document properties. As the Tags, type advertising report
Save and close the file, and then submit for grading.