To complete the Excel Assignment, follow the instructions below:

$1.$ Merge and Center the title from Cell A$1$ to G$1$: Click on cell A$1,$ then click on the "Merge & Center" button in the "Alignment" group on the "Home" tab. This will merge the cells from A$1$ to G$1$ and center the title.

$2.$ Increase the width of columns B and C to $16$ characters: Click on column B$,$ then click on the "Format" button in the "Cells" group on the "Home" tab. Select "Column Width" and enter $16.$ Repeat the process for column C$.$

$3.$ Format the title in cells B$3$ & C$3$ as bold and $12$ point Times New Roman: Select cells B$3$ and C$3,$ then click on the "Bold" button in the "Font" group on the "Home" tab. Click on the dropdown arrow next to the "Font" box and select "Times New Roman". Click on the dropdown arrow next to the "Font Size" box and select $"12".$

$4.$ Apply a thick bottom border to cells B$3$ and C$3$: Select cells B$3$ and C$3,$ then click on the "Border" button in the "Font" group on the "Home" tab. Select "Thick Bottom Border" from the dropdown menu.

$5.$ Format the numbers with commas and remove all decimal places: Select the range of cells with numbers, then click on the "Number Format" dropdown arrow in the "Number" group on the "Home" tab. Select "Number" and adjust the number of decimal places to $"0".$

$6.$ Apply cell style Accent $1$ to title in cell A$1$: Select cell A$1,$ then click on the "Cell Styles" button in the "Cells" group on the "Home" tab. Select "Accent $1"$ from the dropdown menu.

$7.$ Use wrap text for cells B$3$ & C$3$: Select cells B$3$ and C$3,$ then click on the "Wrap Text" button in the "Alignment" group on the "Home" tab.

$8.$ Name the sheet as Surnames: Click on the sheet tab at the bottom of the Excel window, then click on the "Sheet Name" box and enter "Surnames".

$9.$ In cell B$19$ type "Total:" and right align the text: Click on cell B$19,$ then type "Total:". Click on the "Horizontal Alignment" dropdown arrow in the "Alignment" group on the "Home" tab and select "Right".

$10.$ Create a formula or function in Cell C$19$ to add all the numbers: Click on cell C$19,$ then enter the formula $"=$SUM$($C$3$:C$18)".$

$11.$ Create a clustered chart for the data. Do NOT include the totals in your chart!: Select the range of cells with the data, then click on the "Insert" tab. Click on the "Column" button in the "Charts" group and select "Clustered Column". Exclude the totals from the chart.

$12.$ Chart should include surnames, number of occurrences and a chart title: Customize the chart as needed, including adding a chart title.

$13.$ Position the chart below these instructions: Move the chart to the desired location below the instructions.

$14.$ Change the Page Layout Orientation to Landscape: Click on the "Page Layout" tab, then click on the "Orientation" dropdown arrow and select "Landscape".

$15.$ Save your worksheet $-$ use your lastname as the file name: Click on the "File" tab, then click on "Save As$".$ Enter your last name as the file name and save the worksheet in the desired location.

By following these instructions, you will have completed the Excel Assignment.