Google Certification - Level 2 (Units 4-7)
Questions and Correct Answers with Complete
Solutions | New Update 2026
With conditional formatting, teachers can alter the cell color based on the value
for:
(Select all that apply)
Text
Images
Dates
Numbers - ANSWERS Text
Dates
Numbers
Which advanced Google Sheets function gives you a list that removes all duplicate
values?
Filter
Average
Data Validation
, Unique - ANSWERS Unique
Which criteria could a pivot table be applied to: (Select all that apply.)
Student Names
Assignment Dates
Assignment Scores
Shared Collaborators - 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")
Questions and Correct Answers with Complete
Solutions | New Update 2026
With conditional formatting, teachers can alter the cell color based on the value
for:
(Select all that apply)
Text
Images
Dates
Numbers - ANSWERS Text
Dates
Numbers
Which advanced Google Sheets function gives you a list that removes all duplicate
values?
Filter
Average
Data Validation
, Unique - ANSWERS Unique
Which criteria could a pivot table be applied to: (Select all that apply.)
Student Names
Assignment Dates
Assignment Scores
Shared Collaborators - 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")
