Font size
WorksheetsGoogle Cert 1 Unit 8
Total questions: 18
Worksheet time: 10mins
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
Which type of graphs represent values as percentages of a whole?
Bar chart
Pie chart
Scatterplot
Line chart
Google Sheets can be used to share student performance data with others.
True
False
Throughout the school year Mrs. Michaud has her students create many science projects and would like to track the progress of her students. She creates a Google Sheet that contains her students’ names with each assignment, date, score, and standard addressed. The columns are:
A: Name B: Assignment C: Date D: Score E: Standard Addressed
What tool can Mrs. Michaud use to add data to her Google Sheet more easily?
Google Draw
Google Docs
Google Forms
Google Slides
What is the correct formula for calculating an average score?
=Mean
=Average
=Av
=Av(Mean)
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
Protected Slide
Protected Menu
Google Forms are most helpful in which types of tasks?
Drafting responses to email
Classroom quick checks
Measure student progress over time
Communicating to large groups of educators
Which function would provide Mrs. Michaud a compressed list of the standards she has assessed?
Remember her spreadsheet contained the following values:
A: Name B: Assignment C: Date D: Score E: Standard Addressed
=unique(E:E)
=count(E:E)
=sort
=average(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 are designed to display information over a period of time.
Both can be customized.
