Back to lesson
1. Which of the following options will the user be able to type into the cell if it has the following data validation rule?
Dogs or Frogs
Cats or Raccoons
gerbils or snakes
2. Based on the data validation rule below, what will show up in the drop down list in the cell?
The values A17, A18, A19, A20
The values shown in cells A17 through A20
3. Given this data validation rule, which of the following statements is incorrect?
DValList_Drinks will have more than one item.
The dropdown list will show the value “DValList_Drinks”.
DValList_Drinks is pointed at an Excel Table.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement