Skip to content
Past Exams

Computer Science Practice Exam With Answers (25 Solved Questions)

Computer Science Practice Exam With Answers is designed to sharpen your test-taking abilities with authentic past exams.

Preview 3 of 8 pages

See the first 3 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    Google Certification - Level 2 (Units 4-7) 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. =fil- ter(D:F,C:C="Jim- my Wong") 1 / 8

  2. Page 2
  3. Page 3
    Read page 3 as text

    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 ad- dress 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 com- 2 / 8

5 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Information Technology study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.