Google Certification - Level 2 (Units 4-7) Questions and Correct Answers with Complete Solutions | New Update 2026

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")