Google Certification - Level 2 (Units 4-7)
Answered Correctly!!!2025
With conditional formatting, teachers can alter the cell color based on the value for:
(Select all that apply)
Text
Images
Dates
Numbers CORRECT ANSWERS Text
Dates
Numbers
Which advanced Google Sheets function gives you a list that removes all duplicate
values?
Filter
Average
Data Validation
Unique CORRECT ANSWERS Unique
Which criteria could a pivot table be applied to: (Select all that apply.)
Student Names
Assignment Dates
Assignment Scores
Shared Collaborators CORRECT ANSWERS Student Names
Assignment Dates
Assignment Scores
The 25 students in your class have used a Google Form to give peer feedback on
presentations that they are doing. The questions are based on a rubric that you created.
The first question asks, "Who is presenting?" and there is a dropdown list of all students
in the class. The other questions are based on the rubric.
After the class you want to see all the feedback that was given for Jimmy Wong. The
responses for "Who is presenting?" are listed in column C on the Form Responses
sheet. Columns D, E, and F have the peer feedback.
Select the formula that could be used to show only the peer feedback from columns D,
E, and F for Jimmy Wong.
, =filter(D:F,C:C="Jimmy Wong")
=sum(D:E,F:D)
=sum(D:F,C:C="Jimmy Wong")
=filter(D:E,F:D) CORRECT ANSWERS =filter(D:F,C:C="Jimmy Wong")
What is one (efficient) way to format data on a sheet using color?
Use the bucket to manually change each cell
Use the =colorif formula
Print the sheet and use a highlighter
Use conditional formatting CORRECT ANSWERS Use conditional formatting
Why would you use URL shortener with a Google Sites URL?
-It makes your Google Site look nicer
-It creates a short URL that is easy for students to type into the address bar
-It allows you to give edit access to your Google Site to many different people
-It allows you to purchase a domain name and create a custom domain for your Google
Site CORRECT ANSWERS It creates a short URL that is easy for students to type into
the address bar
What age students are able to create blog posts to share their learning?
7 year olds
12 year olds
18 year olds
All of the above CORRECT ANSWERS All of the above
Which of the following is a way to set up Blogger in your classroom?
(Select all that apply.)
-Teacher is the sole author. Students can leave comments
-Teacher and students can all be authors
-Students are authors each with his or her own blog
-A team of teachers that are all authors on one shared blog CORRECT ANSWERS
Teacher is the sole author. Students can leave comments
Teacher and students can all be authors
Students are authors each with his or her own blog
A team of teachers that are all authors on one shared blog
Which of the following is true about using a Google Doc as a class syllabus?
(Select all that apply.)
Answered Correctly!!!2025
With conditional formatting, teachers can alter the cell color based on the value for:
(Select all that apply)
Text
Images
Dates
Numbers CORRECT ANSWERS Text
Dates
Numbers
Which advanced Google Sheets function gives you a list that removes all duplicate
values?
Filter
Average
Data Validation
Unique CORRECT ANSWERS Unique
Which criteria could a pivot table be applied to: (Select all that apply.)
Student Names
Assignment Dates
Assignment Scores
Shared Collaborators CORRECT ANSWERS Student Names
Assignment Dates
Assignment Scores
The 25 students in your class have used a Google Form to give peer feedback on
presentations that they are doing. The questions are based on a rubric that you created.
The first question asks, "Who is presenting?" and there is a dropdown list of all students
in the class. The other questions are based on the rubric.
After the class you want to see all the feedback that was given for Jimmy Wong. The
responses for "Who is presenting?" are listed in column C on the Form Responses
sheet. Columns D, E, and F have the peer feedback.
Select the formula that could be used to show only the peer feedback from columns D,
E, and F for Jimmy Wong.
, =filter(D:F,C:C="Jimmy Wong")
=sum(D:E,F:D)
=sum(D:F,C:C="Jimmy Wong")
=filter(D:E,F:D) CORRECT ANSWERS =filter(D:F,C:C="Jimmy Wong")
What is one (efficient) way to format data on a sheet using color?
Use the bucket to manually change each cell
Use the =colorif formula
Print the sheet and use a highlighter
Use conditional formatting CORRECT ANSWERS Use conditional formatting
Why would you use URL shortener with a Google Sites URL?
-It makes your Google Site look nicer
-It creates a short URL that is easy for students to type into the address bar
-It allows you to give edit access to your Google Site to many different people
-It allows you to purchase a domain name and create a custom domain for your Google
Site CORRECT ANSWERS It creates a short URL that is easy for students to type into
the address bar
What age students are able to create blog posts to share their learning?
7 year olds
12 year olds
18 year olds
All of the above CORRECT ANSWERS All of the above
Which of the following is a way to set up Blogger in your classroom?
(Select all that apply.)
-Teacher is the sole author. Students can leave comments
-Teacher and students can all be authors
-Students are authors each with his or her own blog
-A team of teachers that are all authors on one shared blog CORRECT ANSWERS
Teacher is the sole author. Students can leave comments
Teacher and students can all be authors
Students are authors each with his or her own blog
A team of teachers that are all authors on one shared blog
Which of the following is true about using a Google Doc as a class syllabus?
(Select all that apply.)
