Instructions

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. 

Upload the complete midterm project in Assignment area.