Google Sheets Test Google Sheets Data Validation and Protection 2

Question 1

Which menu path opens the data validation dialog in Google Sheets?

Accepted Answer

Data > Data validation

Answer

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?

Accepted Answer

A red warning is shown but the entry is accepted

Answer

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?

Accepted Answer

List from a range

Answer

'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?

Accepted Answer

Text is valid email

Answer

The 'Text is valid email' criterion enforces proper email formatting.

Question 5

Inserting a checkbox via Data validation stores which underlying values by default?

Accepted Answer

TRUE and FALSE

Answer

Checkboxes default to boolean TRUE when checked and FALSE when unchecked.

Google Sheets Test Practice Test