Mark the steps as checked when you complete them.

Open the LASTemplate$-07$ workbook and click the Enable Editing button. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it$.$

Click the Lists sheet tab and select cell A$1.$ Use Smart Lookup to determine the county in which Bemidji is located. Type the county name in cell C$1.$ Repeat these steps for the remaining cities in cells A$2$:A$7.$ For a city that does not display quickly in the Smart Lookup pane, enter the city name with the state $($Minnesota$)$ in an empty cell and try again using that cell. Delete the cell contents after you determine the county names.

Select the Adoptions sheet tab and select cells C$5$:C$29.$ Set list data validation for the "Species" column; the animal types are located on the Lists worksheet. Do not use an input or an error message.

Select cells F$5$:F$29.$ Set list data validation for the "City" column to use city names on the Lists worksheet without input or error messages.

Select cell G$5$ and press Delete. Build a VLOOKUP formula in cell G$5$ to lookup the city name in cell F$5$ in the array on the Lists worksheet and display the ZIP code. Use the sample data to verify that your formula is correct and then copy the formula $($Figure $7-76).$ #NA appears in rows with no data.

Build another VLOOKUP formula in column $H$ to display the county name for the city.

Format the cells in column $A$ to show the Short Date format. Verify that the data in row $29$ has a solid bottom border.

Build a custom number format for the "Animal ID$"$ column to display the ID with five digits. This format displays leading zeros when necessary.

Draw an Option Button $($Form Control$)$ to cover

Figure $7-76$ VLOOKUP to display ZIP code