Google Certified Educator Level 1 Exam Questions

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?

• 1. A distinct color option

• 1. A default notification reminder

• 1. A unique name

• 1. All of the above 

How do you invite someone to a Calendar event?

• 1. 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

• 1. Enter their email in the Event Title