Questions: 7) Format columns G - K as currency with no decimals. 8) Sort the table on Last Name (column D). 9) Change the table style to one you like. 10) In cell L22, create an IF formula that puts "NYC" in column L if column F is "New York", if not put "Other." Copy this formula to the remaining rows in column L. 11) Filter the table for any employee hired between 1/1/2013 and 12/31/2013. In Cell G40, type (do not use a formula) the results for count of employees. 12) Clear the filter. 13) Filter the table for any employee with a last name that begins with M. In cell G42, type (do not use a formula) the results for the total Annual Compensation. Clear the filter. 14) Insert a comment in cell H26 that includes your name and "This salary seems high." 15) Rename the tab (sheet name) to Payroll Data and change the tab color to Blue 16) Enter your name as a center header, save the file, and submit your file.

The question appears to be a set of instructions for formatting and analyzing data in a spreadsheet, likely using software like Microsoft Excel. Here are the steps to address the first three tasks:

1. Format columns G - K as currency with no decimals:

   • Select columns G through K.
   • Right-click and choose "Format Cells."
   • In the "Number" tab, select "Currency."
   • Set the decimal places to 0.
   • Click "OK" to apply the changes.

2. Sort the table on Last Name (column D):

   • Click on any cell in column D.
   • Go to the "Data" tab in the ribbon.
   • Click on "Sort A to Z" or "Sort Z to A" depending on the desired order.
   • Ensure that the entire table is selected to maintain data integrity.

3. Change the table style to one you like:

   • Click anywhere in the table.
   • Go to the "Table Design" tab (or "Design" tab in some versions).
   • Choose a style from the "Table Styles" gallery that you prefer.
   • Click on the style to apply it to the table.

These steps should help you complete the first three tasks in the spreadsheet.