Excel homework

This assignment will use the grade book you created in the Unit 4 Individual Project. Click

here

if you need the original template. Open the spreadsheet, and add a column bar chart showing your grades. To complete this, do the following steps:

• Step 1: Open your Unit 4 Individual Project assignment (grade book).
• Step 2: Using your cursor, highlight the course names and the data that is next to them.
• Step 3: Click on Insert > Charts, and select “Column Chart.”
• Step 4: Click on the chart, and select “Cut.”
• Step 5: Go to the bottom of your spreadsheet, and select Sheet 2. Click on a cell within that sheet.
• Step 6: On Sheet 2, paste the chart you just copied.
• Step 7: On the tabs at the bottom, label Sheet 1, as “Data” and Sheet 2 as “Grade Chart.”
• Step 8: Add a title to the Grade Chart.
• Step 9: Revise the chart as needed to make it look more presentable.
• Step 10. Save your work as “First Name_Last Name_StudentGradebookIP5.”
• Step 11: Turn in the assignment to your instructor for grading.

U4IP_StudentGradebook_Template.xlsx

Sheet1

My Grades at AIU

Date

Student Name

Course
Date
U1IP
U1DB
U2IP
U2DB
U3IP
U3DB
U4IP
U4DB
U5IP
U5DB
Total
Percent

Score->
125
65
150
65
125
65
125
65
150
65
1000
100%

COMP101

0
0
0
0
0
0
0
0
0
0
0

COMP102

0
0
0
0
0
0
0
0
0
0
0

Grades

Sheet2

Sheet3