Google Sheets Test Google Sheets Data Validation and Protection 4

Question 1

A custom formula validation of =ISNUMBER(A2) on cell A2 will allow which entry?

Accepted Answer

42

Answer

ISNUMBER returns TRUE only for numeric values, so 42 passes.

Question 2

To limit a date cell to no earlier than today, which validation approach works?

Accepted Answer

Date is on or after =TODAY()

Answer

Using the date criterion 'on or after' with =TODAY() enforces a minimum date.

Question 3

Which custom formula prevents duplicate entries in column A?

Accepted Answer

=COUNTIF(A:A,A2)=1

Answer

COUNTIF checking that a value appears only once blocks duplicates.

Question 4

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?

Accepted Answer

They automatically include newly added values

Answer

An open-ended column reference lets the dropdown pick up new values automatically.

Question 5

What is a reliable way to build dependent (cascading) dropdowns in Google Sheets?

Accepted Answer

Use a custom formula with INDIRECT referencing named ranges

Answer

INDIRECT combined with named ranges lets a second dropdown depend on the first selection.

Google Sheets Test Practice Test