Google Sheets Data Validation and Protection Flashcards
7 cards from real Google Sheets Test practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Google Sheets Data Validation and Protection flashcards as text
Which menu path opens the data validation dialog in Google Sheets?
Answer: Data > Data validation
Data validation is accessed through the Data menu.
What happens by default when a user enters a value that fails a data validation rule?
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.
Which validation criterion creates a dropdown list from a range of cells?
Answer: List from a range
'List from a range' pulls dropdown options directly from a specified cell range.
To require a cell contain only a valid email address, which criterion is used?
Answer: Text is valid email
The 'Text is valid email' criterion enforces proper email formatting.
Inserting a checkbox via Data validation stores which underlying values by default?
Answer: TRUE and FALSE
Checkboxes default to boolean TRUE when checked and FALSE when unchecked.
Which option lets validation criteria depend on a formula result?
Answer: Custom formula is
'Custom formula is' evaluates any formula returning TRUE to allow the entry.
What does the 'Show validation help text' option do?
Answer: Displays a message when the cell is selected
Help text appears as a tooltip guiding the user on acceptable input.
How this page was made: written with AI tools. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy