Create formulae in the correct cell locations $($based on the diagram$)$ to locate the row with a student ID that is equal to the value typed into the B$2$ search cell.

$3.$

Display the value of the student$$s full name $($in the format: $$Lastname Firstname$)$ in cell C$2$ as well as the corresponding userID in cell D$2,$ as shown in the next figure $($Hint: Do an internet search to find MS Excel functions that can do a lookup of values in a table based

$11$

on an initial column key value and then another function to concatenate multiple text strings

together$).$