Widen each column to an appropriate width so that all information can be viewed. Use the AutoFit feature.

$2.$ Bold the column headings of the table.

$3.$ Center the x$\text{'}$s in the columns.

$4.$ Move the column, "Email Address" and its data from column B to the last column in the table. Make sure the the second column is not blank; if so$,$ delete that column.

$5.$ Insert a new row anywhere in the table to contain a new employee's name, department, the date of training attendance, and the person's company email address. Enter this data and highlight the row with a new color $($so I can find it$).$

$6.$ For the title of the table, "Training Workshop Attendance", in cell A$8,$ enlarge and bold the font. Then merge columns A to F$,$ and center this title. Format the merged cells with a fill color of your choice.

$7.$ Add a border so that all cells in the table have been enclosed with a border.

$8.$ Sort the data according to "Last Name". To do this, highlight the data and the table headers. Choose "Sort & Filter", then "Custom Sort". In the box that pops up$,$ next to "Sort By$",$ click on the arrow to reveal a drop down menu that contains the column headers. Choose "Last Name". Radha Abdul should be the in the top row.

$9.$ The department, "New Customers" has been renamed to "New Accounts". Use the "Find and Replace" feature to find the phrase, "New Customers" and replace it with "Accounts".

$10.$ Use the Spell Check feature to check the spelling. Assume that all employee names are spelled correctly.

$11.$ Rename this first worksheet as "Attendance". Save this file.

$12.$ Right$-$click on the worksheet tab at the bottom and use the "Move or Copy" feature to copy this worksheet and all of its changes to the second sheet.

Instructions for the Second Worksheet:

$1.$ Rename the second worksheet as "Payment".

$2.$ Add $3$ new columns in this order: Cost of Course, Amount Paid, and Amount Due. Format the new column headers to match the formatting style of the existing column headers.

$3.$ The cost of this training course is $$125.$ Enter this cost for the first person in the table. Format as currency. Then copy$/$paste this value in the column for each person.

$4.$ Some employees have fully paid for the course, while others have not. Enter various amounts in the "Amount Paid" column. Format as currency.

$5.$ For the first employee in the "Amount Due" column, enter an Excel formula that calculates any remaining balance. Copy$/$paste this formula for all employees in the table.

$6.$ Save.