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 gearsuch as helmets, padding, and cupsthat 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
Open the Sports_Gear_Protection file, and save it as Lastname_Firstname_Sports_Gear
In the worksheet, adjust column widths so that all data displays.
Apply a style to the titles
Set the titles to repeat on all printed pages.
Create a chart on a new sheet.
Format the chart, using a chart layout and chart style.
Rename the sheets containing data.
Insert the your name in the footer of all worksheets.
Open the file Gear_Presentation, and save the presentation as Lastname_Firstname_Gear_Presentation
Apply a design theme and variant, and then add appropriate titles to the slides.
On Slide 2, convert the bulleted list to a SmartArt object, and apply formatting.
Insert a blank slide after Slide 2, and paste the Excel chart as a link.
Insert a shape on one of the slides and modify the shape with at least two effects.
Insert appropriate text in the shape and create a hyperlink to the Excel workbook.
Add a slide transition to all slides.
In the Excel worksheet, add a hyperlink to the presentation.
In both files, add your name in the footer.
Protective Gear
Skateboard Helmets
Mouth Guard
Safety Pads
Protection
FIRST! Sheet1
Inventory of Protective Sports Gear
Gear Number Available Number on Order
Skateboard Helmets 7 3
Mouth Guards 5 5
Safety Pads 6 4
Safety Guards 9 1
Football Helmet 8 2
FootballChin Straps 5 5
Athletic Cups 8 2
Athletic Suporters 8 2
Football Arm Sleeves 7 3
Football Elbow Pads 9 1
Football Back Plates 10 0
Football Rib Protection 8 2
Football Facemasks 2 8
Football Girdles 4 6
Football Visors 11 9
Football Shoulder Pads 8 12
Football Mouthguards 15 5
Football Neck Rolls 9 11
Hip Pads 5 15
Tail Pads 8 12
Batting Helmets 7 13
Batter’s Protection 8 12
Chest Protection 20 0
Fielder’s Face Guards 5 15
Batting Helmet Facemasks 2 18
Umpire Gear 6 14
Mouthguards 11 9
