Google Sheets and Forms: Data Analysis and Collection Exercises, Exams of Advanced Education

A series of questions and answers related to google sheets and forms, covering data input, validation, analysis, and chart creation. it's valuable for students learning to use these tools for data management and analysis, offering practical exercises to reinforce understanding. The questions test knowledge of various features and functions within both applications, making it suitable for self-assessment or classroom use.

Typology: Exams

2024/2025

Available from 05/02/2025

solution-master
solution-master 🇺🇸

3.2

(27)

11K documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Google Certification unit 8 complete study guide solution
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
pf2

Partial preview of the text

Download Google Sheets and Forms: Data Analysis and Collection Exercises and more Exams Advanced Education in PDF only on Docsity!

Google Certification unit 8 complete study guide solution

  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