9. The imported contact name data separates the first and last names, but Carla wants to list the full name in one cell. List the first and last names of each contact in a single cell using worksheet references as follows: a. In cell K7, enter a formula using the CONCAT function that displays the first name shown in cell C3 of the New Clients worksheet followed by a space (" "), and then the last name shown in cell D3 of the New Clients worksheet. b. Fill the range K8:K11 with the formula in cell K7 to list the full names of the remaining contacts. 10. List the number of years in business and the state where the client is located using worksheet references as follows: a. In cell L7, enter a formula using the LEFT function to insert the first 2 characters on the left of cell E3 of the New Clients worksheet. b. Fill the range L8:L11 with the formula in cell L7. c. In cell M7, enter a formula using the RIGHT function to insert the last 2 characters on the right of cell F3 of the New Clients worksheet. d. Fill the range M8:M11 with the formula in cell M7. 11. Carla asks you to calculate the total project amounts for both types of projects. Go to the Summary worksheet. In cell B5, create a formula using the SUM function and 3-D references to total cell H17 on the SEO Projects worksheet and cell H16 on the Social Media Projects worksheet