Google Sheets Data Validation Quiz

Why is it beneficial to use a drop-down list in Google Sheets?

• To allow users to type any answer they want.

• To make the sheet look more colorful.

• To provide a controlled set of options for users to choose from.

• To automatically calculate values.

What is the first step in creating a drop-down list in Google Sheets?

• Open a new Google Doc.

• Type the question in a cell.

• Enlarge the first column.

• Share the sheet with others.

Which menu option do you use to access data validation in Google Sheets?

• View

• Data

• Edit

• File

What should you do to ensure the drop-down list appears in the cell?

• Leave the cell blank.

• Tick the box to show a drop-down list in the cell.

• Type the options directly into the cell.

• Use a different sheet for options.

How can you apply the same data validation to an entire column?

• Manually type the options in each cell.

• Copy and paste the cell.

• Use the fill handle to drag down the validation.

• Create a new sheet for each column.