WorksheetsGoogle Certified Educator Level 1 Exam Questions
Total questions: 20
Worksheet time: 7mins
How do you freeze a row or column in Google Sheets?
A. View > Freeze
B. Format > Number
C. Data > Sort
D. File > Lock
Which function in a Sheet ignores duplicates in a list and returns a single instance of each item?
A. Sort
B. Transpose
C. Unique
D. Average
Charts created in Google Sheets can be added to a Google Site.
A. True
B. False
Which chart can be used to show trends over time?
A. Scatterplot
B. Pie chart
C. Bar chart
D. Line chart
Teachers and counselors can view student data simultaneously in a Google Sheet. When filtering data, the only option is to change the view of the data for everyone.
A. True
B. False
You can create Google Calendar events from your computer or device. Select all the ways you can create events. (choose three answers)
A. Create an event from a Gmail message
B. Click an empty time on your calendar
C. Click the create button
D. Right click over an empty time on your calendar
Double click on the mini calendar
When editing a Google Calendar event, under the More actions, what options do you have? (choose 3 answers)
A. Print
B. Email participants
C. Publish event
D. Duplicate
All events must be put on a user's personal calendar as well as any other calendars they create.
True
False
A Google Calendar can have which of the following attributes?
A distinct color option
A default notification reminder
A unique name
All of the above
How do you invite someone to a Calendar event?
Using the blue share button in the event
Enter their email address in the Add Guests field
Use the Invite setting under the File menu
Enter their email in the Event Title
Mr. Bentley finds it easy to use Google Docs, Sheets, and Slides in his classroom as they are very similar to other programs he’s used in the past. He overhears his colleague Ms. Bernard talk about using Google Forms as well, but isn’t sure how it’s relevant in a school environment. Which of the following are relevant uses for Google Forms in education?
Gathering feedback on field trips
Creating an interactive presentation
Create formative quiz checks at the end of each lesson
Designing a logo for school football teen
Surveys for collecting data for group projects
Teachers can use Google Forms to create surveys, measure student success, administer quizzes, and more. Which of the following is NOT a question option?
Multiple choice with grid
Flash cards
Drop down
Date
Teachers can customize Google Forms to go with the lesson topic or school event what custom design options are available in a Google Form?
Change the background color of the Form
Choose a different font
Add a video to the header
Add an animated GIF to the header
Select the header from the Themes options or upload an image from the computer
What are the options for storing and viewing responses from a Google Form?
Store in a new spreadsheet
Store in an existing spreadsheet
Both of the above
None of the above
What options do you have for adding questions in Google Forms?
Objective & Subjective Questions
Images
YouTube Videos
All of the Above
Which product allows you to create to-do lists shared with many people?
Google Forms
Google Calendar
Google Drawings
Google Keep
Can you add images to Google Keep?
True
False
What's the best way to make a list on Google Keep?
Copy to Google Docs
Make a Copy
Add an Image
Show Checkboxes
What are the main features of Google Keep?
Text notes, voice notes, and reminders
File storage and sharing
Video editing and steaming
Social media integration
Google Keep allows you to add labels to your notes for better organization.
True
False
