WEEK 5

Hide Assignment InformationInstructions

The Scenario:

Frederick Jackson, one of the owners of Sports Gear, believes it is important to stress sports safety. He wants his sales associates to emphasize sports protective gear—such as helmets, padding, and cups—that is available in the retail store.

For this assignment, you will need the following files:

  • Sports_Gear protection
  • Gear_Presentation

You will save your files as:

  • Lastname_Firstname_Sports_Gear
  • Lastname_Firstname_Gear_Presentation
  1. Open the Sports_Gear_Protection file, and save it as Lastname_Firstname_Sports_Gear
  2. In the worksheet, adjust column widths so that all data displays.
  3. Apply a style to the titles
  4. Set the titles to repeat on all printed pages.
  5. Create a chart on a new sheet.
  6. Format the chart, using a chart layout and chart style.
  7. Rename the sheets containing data.
  8. Insert the your name in the footer of all worksheets.
  9. Open the file Gear_Presentation, and save the presentation as Lastname_Firstname_Gear_Presentation
  10. Apply a design theme and variant, and then add appropriate titles to the slides.
  11. On Slide 2, convert the bulleted list to a SmartArt object, and apply formatting.
  12. Insert a blank slide after Slide 2, and paste the Excel chart as a link.
  13. Insert a shape on one of the slides and modify the shape with at least two effects.
  14. Insert appropriate text in the shape and create a hyperlink to the Excel workbook.
  15. Add a slide transition to all slides.
  16. In the Excel worksheet, add a hyperlink to the presentation.
  17. In both files, add your name in the footer.
Get a 10% discount on an order above $50
Use the following coupon code :DUE