Google Cert 1 Unit 8

You can only input data into a Google Sheet through a Google Form.

• True

• False

Which feature limits the type of data that can be entered into a cell?

• Formatting

• Data Validation

• Sum

• Transpose

Which of the following are types of data you can collect with Google Forms? (Select all that apply.)

• Text

• Dates

• Fingerprints

• Numbers

Which app allows you to analyze data?

• Search

• Gmail

• Google Forms

• Google Sheets

What Google tool creates a digital questionnaire to collect entries from users?

• Google Search

• Google News

• Gmail

• Google Forms

Which function ignores duplicates in a list and returns a single instance of each item?

• Sort

• Unique

• Average

• Transpose

Which of the following are types of data you can store in a Google Sheet? (Select all that apply.)

• Videos

• Numbers

• Text

• Dates

Users can only use Google Sheets on a Chromebook.

• True

• False

Charts created in Google Sheets can be added to a Google Site

• True

• False

Which chart can be used to represent trends over time

• Bar chart

• Pie chart

• Scatterplot

• Line chart