#1: Make two buttons to sort the table by Employee Name or by Client Location. in Excel, name the rst cell of the employee table. in USA, dynamically name the entire table (with labels #2: Make two buttons to highlight table rows with Number of Night values Smaller or Larger than a gil Dynamically name the table {no labels}. Clear previous formatting rules. Select the table and add new for in Excel, name the given number of nights value cell. Highlight rows with smaller costs green and larger ( #3: Make a button to calculate a report of the Min and Max Costs in the table. Dynamically name the table {no labels). in Excel, name the Costs Report column cells. Use Application.Wc #4: Make a button to oalculate the total nights and total costs for a given Employee. Dynamically name the table {no labels). in Excel, name the given Employee name cell as well as the Total Use Application.Worksheeti'unction to calculate sum of nights and sum of costs for given employee. '_ '_ -_ '_ '_ \" \" 0 rim \"1" MWHM-hMmHHmMIil-AmI-AH 4h} $650.00 $250.00 $250.00 $600.00 $400 $800 $625.00 $425.00 $287.50 $487.50 $250 $562.50 $750.00 $350.00 $500.00 $350 $450.00 $400.00 $575.00 $415.00 econ nn Sortby Highlight Nun Min Max 14