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

Supporting image for quiz question

Answer 1

Dogs or Frogs

Answer 2

Cats or Raccoons

Answer 3

gerbils or snakes

Answer 4

Don’t know

Answer 5

$A$17:$A$20

Answer 6

The values shown in cells A17 through A20

Answer 7

The values A17, A18, A19, A20

Answer 8

Don’t know

Answer 9

The dropdown list will show the value “DValList_Drinks”.

Answer 10

DValList_Drinks will have more than one item.

Answer 11

DValList_Drinks is pointed at an Excel Table.

Answer 12

Don’t know

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