Data Validation in Google Sheets Quiz

What is the main purpose of Data Validation in Google Sheets?

• To change cell color automatically

• To restrict user input to specific values

• To calculate totals automatically

• To remove duplicate entries

Which menu path is used to apply Data Validation?

• Format → Conditional Formatting

• Tools → Protect Sheet

• Data → Data validation

• Insert → Function

When you want to allow users to select from a fixed list, which option should you choose?

• Checkbox

• Text contains

• Dropdown

• Custom formula

To create a dependent dropdown, what Google Sheets function is most commonly used?

• FILTER()

• INDIRECT()

• ARRAYFORMULA()

• IMPORTRANGE()

What is a named range used for in dependent dropdowns?

• To protect cells

• To give a readable name to a range for formula use

• To count items automatically

• To filter values

Which of the following is an advantage of using Data Validation?

• Allows any value

• Reduces data entry errors

• Slows down form entry

• Deletes invalid entries automatically

What happens when an invalid entry is made in a data-validated cell?

• The cell turns red

• An error message appears

• The sheet crashes

• Nothing happens

Which type of data validation ensures that users enter only dates?

• Text contains

• Is valid date

• Dropdown (from a range)

• Custom formula

To make the second dropdown depend on the first, the range name must:

• Match the value selected in the first dropdown

• Contain numbers only

• Be written in uppercase

• Include all possible options

Which of the following is a custom formula that can be used in data validation?

• =A1+B1

• =ISNUMBER(A1)

• =FILTER(A1:A10,B1:B10="Yes")

• =SUM(A1:A10)