$1.$ Set the following data validation on the column of cities, G$5$:G$30$:

o$$ Validation Criteria: List with a source of $=$Input!$A$$2$:$A$$14$

o$$ Input Message Title: City

o$$ Input Message: Select a city from the drop$-$down list.

o$$ Error Alert Style: Information

o$$ Error Title: City Error

o$$ Error message: That city is not on the list.

$2.$ Enter Hotlanta in cell G$8,$ and then select Enter.

$3.$ Observe the information error message. $($Confirm it works$)$

$4.$ Set the following data validation on the column of Num: A$5$:A$30$:

o$$ Validation Criteria: Whole numbers between $1$ and $26$

o$$ Input Message Title: Number

o$$ Input Message: Enter a number between $1$ and $26.$

o$$ Error Alert Style: Warning

o$$ Error Title: Number Error

o$$ Error message: The number must be between $1$ and $26.$

$4.$ Enter $30$ in cell A$5$ and then select Enter.

$5.$ Observe the warning error message. $($Confirm it works$)$