Which of the following options will the user be able to type into the cell if it has the following data validation rule?

Answer 1

Cats or Raccoons

Answer 2

gerbils or snakes

Answer 3

Dogs or Frogs

Answer 4

Don’t know

Answer 5

The values shown in cells A17 through A20

Answer 6

$A$17:$A$20

Answer 7

The values A17, A18, A19, A20

Answer 8

Don’t know

Answer 9

DValList_Drinks is pointed at an Excel Table.

Answer 10

DValList_Drinks will have more than one item.

Answer 11

The dropdown list will show the value “DValList_Drinks”.

Answer 12

Don’t know

Based on the data validation rule below, what will show up in the drop down list in the cell?