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

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

Top Fifteen Surnames in the United States
Smith
2376000
Johnson 1857000
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
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
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
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

attachment

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

Pages (275 words)
Standard price: \$0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
All your data is secure and will never be disclosed to third parties. Your essay or assignment is treated as your intellectual property and can never be shared or provided as a sample to aspiring customers.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
You will never have to worry about deadlines – 98% of our assignments are completed on time.
Money Back
We give refunds anytime you feel the work did not meet your expectations. However, we have not refunded any papers in the last 6 months as our team keeps improving their quality and customer service.

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00