Google Level 2 Questions and Answers Already Passed
What chart would be best to compare an individual group go the larger population? - AnswersRadar
Chart
Which function will give you the total number of times a value appears if it meets certain criteria? -
Answers=countif
The options to summarize data in a pivot table report include - Answers=sum
=counta
=average
If you change the sort or filter criteria in a filter view everyone viewing that Sheet will also have their
data sorted or filtered - Answersfalse
What feature is used to color code calls based on their contents? - AnswersConditional Formatting
Which Google Sheets Function creates line graphs and different types of bar charts right in the cell of a
spreadsheet? - Answers=sparkline
Custom functions can be used for conditional formatting - Answerstrue
how can you apply conditional formatting to a cell? - Answersby date
by text contained in the cell
by a number in the cell
Google Forms results can be imported into Google Classroom - Answerstrue
Which advanced Google Sheets function gives you a list that removes all duplicate values? -
AnswersUnique
Which criteria could a pivot table be applied to? - AnswersStudent names
assignment dates
assignment scores
what is one efficient way to format data on a sheet using color? - AnswersUse conditional formatting
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 in a rubric that you created. Select the formula that could be used to
show only peer feedback from Columne D, E F for ______ - Answers=filter(D:F, C:C="Jimmy Wong"
Organizing a tech committee at your school will support teachers by - Answersgiving teachers a voice in
effective tech integration
, Tagging blog posts helps when searching a blog for specific content - Answerstrue
Your principal has asked you to share tips to improve collaboration with students and teachers at the
next faculty meeting. You could share... - Answershow to create a newsletter using blogger
a YouTube playlist of video tutorials for creating Google Sites
Teachers in your school have complained about a one-size-fits-all model of training that has been used
in your district for years. They would like to personalize the professional learning that goes on in school.
Which of the following models provides the most relevant and timely support to teachers on an
individual basis when they need it: - AnswersInstructional coaches,
School site mentors
YouTube is a great option for finding new content, but some educators worry about searching for videos
during class because it wastes time and inappropriate content might show up. Select the benefits of
using a YouTube channel and playlists to address these concerns: - AnswersPlaylists allow you to
organize pre-selected videos so you don't waste class time searching for them;
YouTube channels allow you to organize and share your playlists with students, parents, and other
teachers
The primary reason it is a good idea to use YouTube Live vs. Google Meet for professional development
sessions is: - AnswersYouTube Live is recorded and can be shared on YouTube.
Flipped Learning can help students learn at their own pace: alleviating educators from conducting whole
class reviews of concepts with students who already understand them. - AnswersTrue
Blended Learning is where - AnswersStudents learn in the classroom setting with a teacher and online
with guided activities
Which of the following learning techniques allow time for a teacher to pull aside a small group for
additional learning during class? - AnswersBlended learning,
Project-Based Learning,
Flipped Classroom
A teacher provides the most authentic audience for students' creative work - AnswersFalse
The Flipped Learning model allows student access to concepts at any time of the day - AnswersTrue
Which app allows students to save images, text, graphs and more from their research? - AnswersGoogle
Keep
Students can animate their drawings using Google Slides - AnswersTrue
What chart would be best to compare an individual group go the larger population? - AnswersRadar
Chart
Which function will give you the total number of times a value appears if it meets certain criteria? -
Answers=countif
The options to summarize data in a pivot table report include - Answers=sum
=counta
=average
If you change the sort or filter criteria in a filter view everyone viewing that Sheet will also have their
data sorted or filtered - Answersfalse
What feature is used to color code calls based on their contents? - AnswersConditional Formatting
Which Google Sheets Function creates line graphs and different types of bar charts right in the cell of a
spreadsheet? - Answers=sparkline
Custom functions can be used for conditional formatting - Answerstrue
how can you apply conditional formatting to a cell? - Answersby date
by text contained in the cell
by a number in the cell
Google Forms results can be imported into Google Classroom - Answerstrue
Which advanced Google Sheets function gives you a list that removes all duplicate values? -
AnswersUnique
Which criteria could a pivot table be applied to? - AnswersStudent names
assignment dates
assignment scores
what is one efficient way to format data on a sheet using color? - AnswersUse conditional formatting
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 in a rubric that you created. Select the formula that could be used to
show only peer feedback from Columne D, E F for ______ - Answers=filter(D:F, C:C="Jimmy Wong"
Organizing a tech committee at your school will support teachers by - Answersgiving teachers a voice in
effective tech integration
, Tagging blog posts helps when searching a blog for specific content - Answerstrue
Your principal has asked you to share tips to improve collaboration with students and teachers at the
next faculty meeting. You could share... - Answershow to create a newsletter using blogger
a YouTube playlist of video tutorials for creating Google Sites
Teachers in your school have complained about a one-size-fits-all model of training that has been used
in your district for years. They would like to personalize the professional learning that goes on in school.
Which of the following models provides the most relevant and timely support to teachers on an
individual basis when they need it: - AnswersInstructional coaches,
School site mentors
YouTube is a great option for finding new content, but some educators worry about searching for videos
during class because it wastes time and inappropriate content might show up. Select the benefits of
using a YouTube channel and playlists to address these concerns: - AnswersPlaylists allow you to
organize pre-selected videos so you don't waste class time searching for them;
YouTube channels allow you to organize and share your playlists with students, parents, and other
teachers
The primary reason it is a good idea to use YouTube Live vs. Google Meet for professional development
sessions is: - AnswersYouTube Live is recorded and can be shared on YouTube.
Flipped Learning can help students learn at their own pace: alleviating educators from conducting whole
class reviews of concepts with students who already understand them. - AnswersTrue
Blended Learning is where - AnswersStudents learn in the classroom setting with a teacher and online
with guided activities
Which of the following learning techniques allow time for a teacher to pull aside a small group for
additional learning during class? - AnswersBlended learning,
Project-Based Learning,
Flipped Classroom
A teacher provides the most authentic audience for students' creative work - AnswersFalse
The Flipped Learning model allows student access to concepts at any time of the day - AnswersTrue
Which app allows students to save images, text, graphs and more from their research? - AnswersGoogle
Keep
Students can animate their drawings using Google Slides - AnswersTrue
