Answer all questions using the the Excel data and columns provided.

$1.$ Total Population of ID Number $6566($Using VLOOKUP$)$

$2.$ Count of Records in CSA Name Midland$-$Odessa, TX $($Using COUNTIF$)$

$3.$ Count of Records with CSA Numbers Between $148$ and $350($Using COUNTIFS$-$ Do Not Include $148$ or $350)$

$4.$ Sum of High Wage Earners in CSA Name Amarillo$-$Pampa$-$Borger, TX $($Using SUMIF$)$

$5.$ Sum of Total Acreage of CSA Numbers Greater than $484,$ but Less than $544($Using SUMIFS$)$

$6.$Concatenate $1$st Line of Data, CSA Number and CSA Name with a Space $($Use CONCATENATE$)$

$7.$ Use the Index function to return the CSA Name of the $1,216$th Item

$8.$ Use the Index Function to Return the Percentage of Auto Owners That Own $1$ Car for the $1,216$th CSA Name

$9.$ Use the Match Function to Determine the Position of ID Number $1,214-$ Be Sure to Use Exact Match

$10.$ Combine Index and Match to Return the Number of Low Wage Workers for ID Number $1,855$