Google Certification - Level 2 (Units 4-7)1.With conditional formatting, teachers can alter the cellcolor based on the value for:(Select all that apply)TextImagesDatesNumbersTextDatesNumbers2.Which advanced Google Sheets function gives you alist that removes all duplicate values?FilterAverageData ValidationUniqueUnique3.Which criteria could a pivot table be applied to: (Selectall that apply.)Student NamesAssignment DatesAssignment ScoresShared CollaboratorsStudent NamesAssignment DatesAssignmentScores4.The 25 students in your class have used a GoogleForm to give peer feedback on presentations that theyare doing. The questions are based on a rubric thatyou created.The first question asks, "Who is presenting?" andthere 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 thatwas given for Jimmy Wong. The responses for "Whois presenting?" are listed in column C on the FormResponses sheet. Columns D, E, and F have the peerfeedback.=fil-ter(D:F,C:C="Jim-my Wong")1 / 8Preview Mode
This document has 8 pages. Sign in to access the full document!