Exp22_PowerPoint_Ch03_Cumulative_Bryce_Adventure_Camp

Step

Instructions

Points Possible

1

Start PowerPoint. Download and open the file named Exp22_PPT_Ch03_Cumulative_BryceAdventureCamp.pptx. Grader has automatically added your last name to the beginning of the filename.

0

2

Insert a Title and Content layout slide after Slide 1. Type Agenda in the Title Placeholder. Insert a Vertical Box List SmartArt graphic in the content placeholder. Type the following in the Text pane: Highlights and Activities Lodging Income Revenue Balance Sheet Assets Stock Performance Change the SmartArt graphic to Lined List.

12

3

On Slide 4, convert the bulleted list to a Horizontal Bullet List SmartArt graphic . Apply the Intense Effect style to the SmartArt graphic and change the color to Colored Fill – Accent 6. Change the width to 10.5".

11

4

Create a new slide following Slide 4 using the Title and Content layout. Type Adventure Prices: $10 per voucher in the title placeholder.

5

5

On Slide 5, create a table with four columns and seven rows in the content placeholder. Type the following into the table: Row 1, Col 1: Adventure; Col 2: Duration; Col 3: Vouchers Required Private; Col 4: Vouchers Required Group (min 3 people) Row 2, Col 1: Guided hike; Col 2: 1 hour; Col 3: 3; Col 4: 1 Row 3, Col 1: Rappelling; Col 2: 2 hours; Col 3: 8; Col 4: 4 Row 4, Col 1: ATV tours; Col 2: 2 hours; Col 3: 10; Col 4: 4 Row 5, Col 1: Fitness classes; Col 2: 1 hour; Col 3: 3; Col 4: 1 Row 6, Col 1: Horseback riding; Col 2: 2 hours; Col 3: 6; Col 4: 2 Row 7, Col 1: Zip line; Col 2: 1 ride; Col 3: 1 Note: the last entry in the last column is intentionally left blank.

13

6

On Slide 5, add a new row at the bottom of the table. Merge the cells in the new row. Type Camp Package: 10 Adventure Vouchers/$90 (All vouchers are non-refundable) in the new row. Set the table height to 4.7" and the width to 11.7". Apply the Medium Style 3 - Accent 6 table style to the table.

13

7

Make the following changes to the text in the table on Slide 5: • Select the table and Center Vertically the text. • Select the column headings and change the font size to 20 pt. • Select the text in rows 2-7 of the third and fourth columns, and align Center. • Select the text in the last row, and apply Italic.

8

8

Create a new slide following Slide 5 using the Title Only layout. Add the title Increase by Camp. Start Excel. Download, open, and save the file named Campprofits.xlsx. Copy the chart from the Increase by Camp worksheet. Embed the chart using Paste Options - Use Destination Theme & Embed Workbook on Slide 6. Change the chart colors to Colorful Palette 1. Apply the Layout 10 Quick Layout to the chart.

9

9

Size the chart to a height of 4.8" and width of 7.8". Position the chart horizontally at 2.3" and vertically at 1.9". Apply a Black, Text 1 outline to the chart with a weight of 3 pt.

8

10

Create a new Slide 7 using the Title and Content layout. Type Top Five Reasons For Visiting Camp as the title. Create a Clustered Bar chart with the following data: In cell A1, type Reason, then populate A2:B6 with the following values: Location/Sight-seeing 52% Adventure Opportunities 22% Relaxation 13% Children's Activities 8% Spa and Fitness Facilities 5% Change the source data to use the range A1:B6.

13

11

Make the following changes to the clustered bar chart: • Apply Chart Style 12 • Change the colors to Monochromatic Palette 2 • Remove the title, legend, and x-axis • Increase the font size of the Y-axis to 16 pt and apply Bold • Add Outside End Data Labels • Change the font size of data labels to 16 pt and apply Bold Note, Mac users apply Chart Style 13.

8

12

Save and close Exp22_PPT_Ch03_Cumulative_BryceAdventureCamp.pptx. Submit the file as directed.

0

Total Points

100