$1\mathrm{.}1$ Calculate "Risk Level" $($cell E$4)$ using the VLOOKUP function.

a$.$ The lookup$\_$value is the "Credit Score" $($cell C$4).$

b$.$ Table$\_$array refers to the "Car Loan Interest Rates" table $($range $15$:K$12).$

c$.$ The col$\_$index$\_$num is $2($the second column of the reference table$).$

d$.$ Finally, $[$range $[$ookup$]$ is "TRUE" $($an approximate match is $OK).$

e$.$ Copy your formula down to complete the "Risk Level" column. Be careful to use correct relative and absolute ell references.