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
A custom formula validation of =ISNUMBER(A2) on cell A2 will allow which entry?
Answer: 42
ISNUMBER returns TRUE only for numeric values, so 42 passes.
To limit a date cell to no earlier than today, which validation approach works?
Answer: Date is on or after =TODAY()
Using the date criterion 'on or after' with =TODAY() enforces a minimum date.
Which custom formula prevents duplicate entries in column A?
Answer: =COUNTIF(A:A,A2)=1
COUNTIF checking that a value appears only once blocks duplicates.
If a dropdown's source range grows, how do dependent dropdowns behave when using 'List from a range' with an open-ended reference like A2:A?
Answer: They automatically include newly added values
An open-ended column reference lets the dropdown pick up new values automatically.
What is a reliable way to build dependent (cascading) dropdowns in Google Sheets?
Answer: Use a custom formula with INDIRECT referencing named ranges
INDIRECT combined with named ranges lets a second dropdown depend on the first selection.
A validation rule set to 'Reject input' with criterion 'Number between 1 and 10' does what when 15 is entered?
Answer: Rejects the entry and keeps the old value
'Reject input' blocks any value outside the range and preserves the prior contents.
Which function inside a custom formula validation ensures a cell is not left blank?
Answer: =NOT(ISBLANK(A2))
NOT(ISBLANK(A2)) requires the cell to contain a value.
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