Google Certification - Level 2 Expertly Crafted Questions and Answers
With conditional formatting, teachers can alter the cell color based on the value for: (Select all that apply) Text Images Dates Numbers Text Dates Numbers Which advanced Google Sheets function gives you a list that removes all duplicate values? Filter Average Data Validation Unique Unique Which criteria could a pivot table be applied to: (Select all that apply.) Student Names Assignment Dates Assignment Scores Shared Collaborators 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) =filter(D:F,C:C="Jimmy Wong")
Document information
- Uploaded on
- January 6, 2024
- Number of pages
- 13
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
