Question: This is the link to the files. Please Provide Screenshots and explain how to get to the solutions. https://drive.google.com/open?id=1ePAX5C1yU3jEKonD3pP11mlDShJlLVUC Download and open the file named
This is the link to the files. Please Provide Screenshots and explain how to get to the solutions.
https://drive.google.com/open?id=1ePAX5C1yU3jEKonD3pP11mlDShJlLVUC
| Download and open the file named exploring_p05_grader_h1_Camp.pptx. Save it as exploring_p05_grader_h1_Camp_LastFirst.pptx. |
| On Slide 1, type Gardenia Room, 9 a.m. in a new text box. Apply the Fill: White; Outline: Brown, Accent color 5; Shadow WordArt style and change the font size to 40 pt. Note, depending on the version of Office you are using, the style name may be Fill - White, Outline - Accent 1, Shadow. Position the top left edge of the text box at 1 horizontal and 1 vertical from the top left corner. |
| Create a new slide following Slide 4 using the Title and Content layout. Add ADVENTURE PRICES: $10 PER VOUCHER as the title. Create a four-column, seven-row table in the content placeholder with Adventure, Duration, Vouchers Required Private, and Vouchers Required Group (min 3 people) as headings. Download and open the file p05h1CampPackages.docx. Copy the information into the table on the slide. |
| Change the table structure by adding an additional 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 5.5 and the width to 9 (column widths will resize automatically). Apply Medium Style 3 Accent 1 table style. Center the column headings horizontally and vertically. Center the text in columns 2, 3, and 4 horizontally. Center the table horizontally on the slide and ensure it does not block the slide title. |
| Create a new Slide 6 using Title Only layout. Type SALES HAVE INCREASED AT EACH CAMP as the title. |
| Start Excel. Download and open the file named p05h1Campprofits.xlsx and save it as p05h1Campprofits_LastFirst.xlsx. Copy the previous years data from the Previous Year worksheet. Paste using Keep Source Formatting on Slide 6. Copy the current years data from the Current Year worksheet. Paste using Keep Source Formatting on Slide 6. |
| Size the two worksheets on Slide 6 to 2.5 high and a width of 8. Reposition the Profits for Previous Year table so that the top border aligns with the 2-inch mark above 0 on the vertical ruler and the left border aligns with the 4-inch mark to the left of 0 on the horizontal ruler. Reposition the Profits for Current Year table so that the top border aligns with the 1-inch mark below 0 on the vertical ruler and the left border aligns with the 4-inch mark to the left of 0 on the horizontal ruler. |
| Create a new Slide 7 using Title Only layout. Type ALL CAMPS SHOW AN INCREASE as the title. Link the Increase by Camp Excel chart to the slide using Keep Source Formating and Link Data. Size the chart to a height of 4.5 and a width of 7.5. Format the chart so that its horizontal position is 1.25 and its vertical position is 2.25 from the top left corner. Align the chart in the center of the slide. Change the font size for the X-axis, Y-axis, and legend to 16 pt. |
| Create a new Slide 8 using Title Only layout. Type ALL QUARTERS SHOW AN INCREASE as the title. Link the Increase by Quarter Excel chart to the slide as Microsoft Excel Chart Object. Size the chart to height of 4.5 and width of 7.5. Align Center the chart. |
| Create a new Slide 9 using Title and Content layout. Type TOP FIVE REASONS FOR VISITING CAMP as the title. Create a Clustered Column chart with the following data. In cell B1, 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. Size the chart to a height of 5 and width of 8.5. Align Center the chart. |
| Apply Quick Layout 2 to the chart. Apply Style 7 to the chart. Remove the title and the legend. |
| Click Add Chart Elements in the Chart Layouts group, select Gridlines, and ensure that Primary Major Horizontal is selected. |
| Change the colors of the chart to Colorful Palette 3. Change the data labels to Outside End. |
| Save the presentation. Close the presentation, and then exit PowerPoint. Submit the presentation as directed.
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
