Add a column with a title Population of State Calculate in that column using a function to combine the name of the state, the words "has a population of" and the Population. The first record result should appear as: Hawaii has a population of 1278635 . Notice there are spaces and a period at the end. Autofit the column. As a single sort, sort "Price (\$ per million BTUs)" largest to smallest and Population smallest to largest. Apply a filter for Population greater than 10,000,000. act 11 - Final Tasks riew ire the workbook for distribution to the Executive Team. Add a footer to every sheet: Left side: Created by: your name Right side footer: file name on the top line; sheet name on the second line. Make the entire footer font bold with color Orange, Accent 2 Change the orientation of the American, British, Japanese and Data Gathering sheets to landscape and center them horizontally. Leave all worksheets in Normal view. Add the Document Properties: Title: Car Sales and Pollution Company Name: ASR \begin{tabular}{l} 1 \\ 2 \\ Car Energy Consumption \\ \hline \end{tabular} 3