SOLUTION: Review the following tutorials before completing the listed tasks. You can also find tutorials on YouTube.

Top Fifteen Surnames in the United States
SurnameNumber of Occurrences
Smith
2376000
Johnson 1857000
Tasks
Williams 1534000
1. Increase the width of Column B to be able to see all surnames (no more than 13
Brown
1380000
2. Merge and Center the title from Cell B1 to G1, format as bold and 14 point Aria
Jones
1362000
3. Format the numbers with commas and no decimal places – 1 pt
Miller
1127000
4. Bold and center the column titles in cell B3 and C3 and wrap text – 1 pt
Davis
1072000
5. Sort Surnames in Ascending Order. Do not sort the column headings. – 1 pt
Garcia
858000
6. Name the sheet as Surnames – 1 pt
Rodriguez 804000
7. Add a Header, type your full name in the right section – 1 pt
Wilson
783000
8. In cell B19 type “Total:” and in cell B20 type “Average” right align both – 1 pt
Martinez 775000
9. Using the SUM function, total the number of occurrences in Cell C19 – 2 pts
Anderson 762000
10. Using the AVERAGE function, find the average of occurrences in Cell C20 – 2 p
Taylor
720000
11. Delete Column A – 1 pt
Thomas
710000
12. Apply all borders in the table – 1 pt
Hernandez 706000
13. Change the Page Layout Orientation to Landscape – 2 pts (Make sure it fits on
14. Create a column chart, update title and and position it below the instructions
15. Save your workbook- use your lastname as the file name – 1 pt
16. Upload your Excel file and submit as an attachment in Bb – 1 pt
rnames (no more than 13) – 1 pt
as bold and 14 point Arial – 1 pt
urrences in Cell C20 – 2 pts
2 pts (Make sure it fits on 1 page)
it below the instructions – 2 pts
Top Fifteen Surnames in the United States
Number of
Occurrences
762,000
1,380,000
1,072,000
858,000
706,000
1,857,000
1,362,000
775,000
1,127,000
804,000
2,376,000
720,000
710,000
1,534,000
783,000
16,826,000
1,121,733
Surname
Anderson
Brown
Davis
Garcia
Hernandez
Johnson
Jones
Martinez
Miller
Rodriguez
Smith
Taylor
Thomas
Williams
Wilson
Total
Average
Tasks
1. Increase the width of Column B to be able to see all surnames (no more than 13) – 1 pt
2. Merge and Center the title from Cell B1 to G1, format as bold and 14 point Arial   – 1 pt
3. Format the numbers with commas and no decimal places  – 1 pt
4. Bold and center the column titles in cell B3 and C3 and wrap text   – 1 pt
5. Sort Surnames in Ascending Order. Do not sort the column headings.  – 1 pt
6. Name the sheet as Surnames  – 1 pt
7. Add a Header, type your full name in the right section  – 1 pt    
8. In cell B19 type “Total:” and in cell B20 type “Average” right align both  – 1 pt
9. Using the SUM function, total the number of occurrences in Cell C19   – 2 pts
10.  Using the AVERAGE function, find the average of occurrences in Cell C20  – 2 pts
11. Delete Column A – 1 pt
12. Apply all borders in the table  – 1 pt
13. Change the Page Layout Orientation to Landscape  – 2 pts (Make sure it fits on 1 page)
14. Create a column chart, update title and and position it below the instructions  – 2 pts
15. Save your workbook- use your lastname as the file name  – 1 pt
16. Upload your Excel file and submit as an attachment in Bb  – 1 pt
Surnames in the United States
2,500,000
2,000,000
1,500,000
1,000,000
500,000
–
Student Student

Purchase answer to see full
attachment