Google Certification unit 8

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

False

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

Data Validation

Which of the following are types of data you can collect with Google Forms?

Text

Dates

Numbers

Which app allows you to analyze data?

Google Sheets

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

Google Forms

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

unique

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

Numbers

Text

Dates

Users can only use Google Sheets on a Chromebook.

False

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

true

Which chart can be used to represent trends over time

Line chart

Which type of graphs represent values as percentages of a whole?

Pie chart

Google Sheets can be used to share student performance data with others.

True

What tool can Mrs. Michaud use to add data to her Google Sheet more easily?

Google Forms

Which function would provide Mrs. Michaud a compressed list of the standards she has assessed?

=unique(E:E)

Comparing the line graph and pie chart feature set, which of the following is accurate for both? (Select all that apply.)

Both can be shared publicly.

Both can pull data from multiple sources.

Both can be customized

Which formula would be used to calculate the average scores in column D?

=Average

Mrs. Michaud wants to share the results with another teacher, but not allow the teacher to alter the data. Which of these choices allow this? (Select all that apply.)

Protected Range

Protected Sheet

Google Forms are most helpful in which types of tasks?

Classroom quick checks

Measure student progress over time