Back to lesson
1. Which of the following is not an example of data validation?
2. If a cell is data validated to allow only inputs between two and four characters in length, why are blank cells allowed (i.e. text of zero length)?
On the ‘Settings’ tab in the ‘Data Validation’ dialog box, the default setting is always set to ignore blanks.
The data validation was set up while the underlying cell was blank.
Blank cells are deemed empty and therefore the text length is held as indeterminate
3. Which of the ‘Allow’ options shown in the image should be used to validate a cell to show an even number only?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement