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?
gerbils or snakes
Cats or Raccoons
Dogs or Frogs
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?
The dropdown list will show the value “DValList_Drinks”.
DValList_Drinks will have more than one item.
DValList_Drinks is pointed at an Excel Table.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement