1. 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 2. Which advanced Google Sheets function gives you a list that removes all duplicate values? Filter Average Data Validation Unique Unique 3. 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 4. 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. =filter(D:F,C:C="Jimmy Wong") 1 / 8 Google Certification - Level 2 (Units 4-7) Study online at https://quizlet.com/_6sch5x 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) 5. 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 Use conditional formatting 6. 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 It creates a short URL that is easy for students to type into the address bar 7. 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 All of the above 8. 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 com2 / 8 Google Certification - Level 2 (Units 4-7) Study online at https://quizlet.com/_6sch5x -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 ments 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 9. Which of the following is true about using a Google Doc as a class syllabus? (Select all that apply.) -Once you send it to your students, you can't make any changes -You can only share it by attaching the file to an email -You can collaborate with a teaching partner to create a shared syllabus -You can share your syllabus with the world You can collaborate with a teaching partner to create a shared syllabus You can share your syllabus with the world 10. What are some ways to make a Google Doc more engaging? (Select all that apply.) Use a table of contents Use different fonts for each paragraph Use images with purpose Alert collaborators using "+" in comments Use a table of contents Use images with purpose Alert collaborators using "+" in comments 11. Student work can take many forms. When students include documents, videos, and other media in a Google Sites portfolio, best practice indicates they should put In Google Drive On YouTube