ITCC 200 Business Management Worksheet
Description
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õch as helmets, padding, and cups(at 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.
Upload the complete midterm project in Assignment area.
Unformatted Attachment Preview
Number Available
Gear
Skateboard Helmets
Mouth Guards
Safety Pads
Safety Guards
Football Helmet
FootballChin Straps
Athletic Cups
Athletic Suporters
Football Arm Sleeves
Football Elbow Pads
Football Back Plates
Football Rib Protection
Football Facemasks
Football Girdles
Football Visors
Football Shoulder Pads
Football Mouthguards
Football Neck Rolls
Hip Pads
Tail Pads
Batting Helmets
Batter’s Protection
Chest Protection
Fielder’s Face Guards
Batting Helmet Facemasks
Umpire Gear
Mouthguards
7
5
6
9
8
5
8
8
7
9
10
8
2
4
11
8
15
9
5
8
7
8
20
5
2
6
11
Number on Order
3
5
4
1
2
5
2
2
3
1
0
2
8
6
9
12
5
11
15
12
13
12
0
15
18
14
9
Protective Gear
kateboard Helmets
outh Guard
afety Pads
Purchase answer to see full
attachment
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."