Google Sheets Data Validation Quiz
Interactive Video
•
Computers
•
6th - 7th Grade
•
Practice Problem
•
Hard
Jennifer Brown
FREE Resource
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which menu option do you use to access data validation in Google Sheets?
View
Data
Edit
File
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
