Google Sheets Test Google Sheets Data Validation and Protection 2 — Questions and Answers
Question 1: Which menu path opens the data validation dialog in Google Sheets?
- Format > Data validation
- Data > Data validation (Correct answer)
- Insert > Data validation
- Tools > Data validation
Correct answer: Data > Data validation
Data validation is accessed through the Data menu.
Question 2: What happens by default when a user enters a value that fails a data validation rule?
- The entry is rejected automatically
- A red warning is shown but the entry is accepted (Correct answer)
- The cell is cleared
- The sheet is locked
Correct answer: A red warning is shown but the entry is accepted
By default validation shows a warning but still allows the invalid entry unless 'Reject input' is chosen.
Question 3: Which validation criterion creates a dropdown list from a range of cells?
- Number between
- List from a range (Correct answer)
- Text contains
- Checkbox
Correct answer: List from a range
'List from a range' pulls dropdown options directly from a specified cell range.
Question 4: To require a cell contain only a valid email address, which criterion is used?
- Text is valid email (Correct answer)
- Text contains @
- Number greater than
- Date is valid
Correct answer: Text is valid email
The 'Text is valid email' criterion enforces proper email formatting.
Question 5: Inserting a checkbox via Data validation stores which underlying values by default?
- 1 and 0
- Yes and No
- TRUE and FALSE (Correct answer)
- On and Off
Correct answer: TRUE and FALSE
Checkboxes default to boolean TRUE when checked and FALSE when unchecked.
Question 6: Which option lets validation criteria depend on a formula result?
- Custom formula is (Correct answer)
- Text contains
- Number between
- List of items
Correct answer: Custom formula is
'Custom formula is' evaluates any formula returning TRUE to allow the entry.
Question 7: What does the 'Show validation help text' option do?
- Blocks all input
- Displays a message when the cell is selected (Correct answer)
- Highlights the cell red
- Emails the sheet owner
Correct answer: Displays a message when the cell is selected
Help text appears as a tooltip guiding the user on acceptable input.
Google Sheets Test Google Sheets Data Validation and Protection 2
Which menu path opens the data validation dialog in Google Sheets?