Task 1:

Create an excel worksheet,name it as4aClasswork.Rename Sheet 1 as Task 1 .Enter below data

Name	Genre	Number of Songs
J Smith	Blues	50
B Doe	Country	110
S Spade	Country	200
F Zappa	Blues	1400
F Zappa	Alternative	2300
J Smith	Alternative	150
B Doe	Blues	75
Carol	Blues	800

Add a row after J smith- alternative-150 -----Enter this data into new row- Ben-Country-70)

Add new column after Genre called Notes ...

Resize the column width(10 ) and row width(20)

Write a heading for column 1-5 as Arts assignment.

Fill the blue color on Column heading , Green on Main Heading..

Submit your work

Task 2:

You will do these tasks:

1) Rename Sheet2 as Task 2

2) enter data

Month	Rent	Gas	Water	Total
Jan	100	80	100
Feb	150	85	80
Mar	200	90	90
Apr	150	95	120
May	200	100	110
Jun	220	105	152
Jul	240	110	125

Use Auto Sum to add your data

3) Create a simple formula- Insert a new column Revised Rent between rent and Gas...Revised rent is 5 percent added to Rent ( = Rent +(Rent*5)/100)

4) Show your data in a chart

Task 1:

Create an excel worksheet,name it as4aClasswork.Rename Sheet 1 as Task 1 .Enter below data

Name	Genre	Number of Songs
J Smith	Blues	50
B Doe	Country	110
S Spade	Country	200
F Zappa	Blues	1400
F Zappa	Alternative	2300
J Smith	Alternative	150
B Doe	Blues	75
Carol	Blues	800

Add a row after J smith- alternative-150 -----Enter this data into new row- Ben-Country-70)

Add new column after Genre called Notes ...

Resize the column width(10 ) and row width(20)

Write a heading for column 1-5 as Arts assignment.

Fill the blue color on Column heading , Green on Main Heading..

Submit your work

Task 2:

You will do these tasks:

1) Rename Sheet2 as Task 2

2) enter data

Month	Rent	Gas	Water	Total
Jan	100	80	100
Feb	150	85	80
Mar	200	90	90
Apr	150	95	120
May	200	100	110
Jun	220	105	152
Jul	240	110	125

Use Auto Sum to add your data

3) Create a simple formula- Insert a new column Revised Rent between rent and Gas...Revised rent is 5 percent added to Rent ( = Rent +(Rent*5)/100)

4) Show your data in a chart

Task 1:

Create an excel worksheet,name it as4aClasswork.Rename Sheet 1 as Task 1 .Enter below data

Name	Genre	Number of Songs
J Smith	Blues	50
B Doe	Country	110
S Spade	Country	200
F Zappa	Blues	1400
F Zappa	Alternative	2300
J Smith	Alternative	150
B Doe	Blues	75
Carol	Blues	800

Add a row after J smith- alternative-150 -----Enter this data into new row- Ben-Country-70)

Add new column after Genre called Notes ...

Resize the column width(10 ) and row width(20)

Write a heading for column 1-5 as Arts assignment.

Fill the blue color on Column heading , Green on Main Heading..

Submit your work

Task 2:

You will do these tasks:

1) Rename Sheet2 as Task 2

2) enter data

Month	Rent	Gas	Water	Total
Jan	100	80	100
Feb	150	85	80
Mar	200	90	90
Apr	150	95	120
May	200	100	110
Jun	220	105	152
Jul	240	110	125

Use Auto Sum to add your data

3) Create a simple formula- Insert a new column Revised Rent between rent and Gas...Revised rent is 5 percent added to Rent ( = Rent +(Rent*5)/100)

4) Show your data in a chart

Task 1:

Create an excel worksheet,name it as4aClasswork.Rename Sheet 1 as Task 1 .Enter below data

Name	Genre	Number of Songs
J Smith	Blues	50
B Doe	Country	110
S Spade	Country	200
F Zappa	Blues	1400
F Zappa	Alternative	2300
J Smith	Alternative	150
B Doe	Blues	75
Carol	Blues	800

Add a row after J smith- alternative-150 -----Enter this data into new row- Ben-Country-70)

Add new column after Genre called Notes ...

Resize the column width(10 ) and row width(20)

Write a heading for column 1-5 as Arts assignment.

Fill the blue color on Column heading , Green on Main Heading..

Submit your work

Task 2:

You will do these tasks:

1) Rename Sheet2 as Task 2

2) enter data

Month	Rent	Gas	Water	Total
Jan	100	80	100
Feb	150	85	80
Mar	200	90	90
Apr	150	95	120
May	200	100	110
Jun	220	105	152
Jul	240	110	125

Use Auto Sum to add your data

3) Create a simple formula- Insert a new column Revised Rent between rent and Gas...Revised rent is 5 percent added to Rent ( = Rent +(Rent*5)/100)

4) Show your data in a chart