EDUCATOR-LEVEL-1 Practice Questions

The MIN function in Google Sheets is used to identify and return the lowest numerical value from a specified range of cells. It parses through all the cells in the defined range (e.g., A1:B10), ignores any non-numeric data such as text or empty cells, and outputs the single smallest number it finds. This is a fundamental function for data analysis when you need to find a minimum value in a dataset.

A. The AVERAGE function calculates the arithmetic mean of the numbers in a range, not the lowest value.

B. The MAX function finds the highest numerical value in a range, which is the direct opposite of the MIN function.

D. The SUM function adds all the numerical values in a range together to produce a total.

1. Google Workspace Help. (n.d.). MIN function. In Google Docs Editors Help. Retrieved from https://support.google.com/docs/answer/3094017?hl=en. (This is the official documentation for the MIN function in Google Sheets).

2. Google for Education. (n.d.). Unit 7: Organize your data with Google Sheets - Lesson 2: Calculate and summarize your data. In Google Educator Level 1 Fundamentals Training. Retrieved from https://skillshop.exceedlms.com/student/path/29453-fundamentals-training. (The official training curriculum for the exam covers basic data analysis functions

including MIN).

There is no default single keyboard shortcut, such as Ctrl + [key], to apply the "Wrap text" formatting feature to a cell in Google Sheets. Text wrapping is a formatting option that must be selected from the menu (Format > Wrapping > Wrap) or the toolbar icon. While Alt + Enter or Ctrl + Enter can be used to insert a manual line break within a cell, this is different from applying the automatic text wrapping property, which adjusts dynamically to the cell's width. The options provided correspond to other browser or application functions.

A. Ctrl + Enter inserts a manual line break within a cell's text; it does not apply the automatic "Wrap text" formatting property.

B. Ctrl + W is a common browser shortcut to close the current tab, not a function within Google Sheets for text formatting.

D. Ctrl + T is a standard browser shortcut to open a new tab. It has no text wrapping function in Google Sheets.

1. Google Docs Editors Help. (n.d.). Keyboard shortcuts for Google Sheets. Google. Retrieved from https://support.google.com/docs/answer/181110. (The official list of shortcuts does not include a command for applying the "Wrap text" format).

2. Google Workspace Learning Center. (n.d.). Google Sheets cheat sheet. Google. Retrieved from https://support.google.com/a/users/answer/9288465. (This guide lists common actions and shortcuts

but "Wrap text" is shown as a menu/toolbar action

not a keyboard shortcut).

The Google Search feature that allows a user to limit results to a specific timeframe is the time filter, which includes a "Custom range" option. Among the choices provided, "Google Date Range" is the most accurate description of this user-facing tool. By selecting "Tools" on the search results page, users can specify a time period, such as the past week, or set a custom start and end date to filter for content updated within that specific window.

A. "Google Update Filter" is not an official or recognized name for any Google Search feature.

C. "Google Timeframe" is a generic term but not the specific name used for the search tool.

D. "Google Freshness" refers to an underlying search algorithm that prioritizes recent content, not the name of the user-operated filter tool itself.

1. Google Search Help. (n.d.). Filter your search results. Google. Retrieved from https://support.google.com/websearch/answer/142143. (See section "Filter by date").

2. Google for Education Teacher Center. (n.d.). Find what you're looking for

faster. Google. Retrieved from https://skillshop.exceedlms.com/student/path/18301-fundamentals-training. (See Unit 2: Find what you're looking for

faster

which demonstrates using the "Tools" menu to filter by time).

While teachers can generate a persistent Google Meet link directly within the Google Classroom interface, a common and officially supported workflow is scheduling meetings through Google Calendar. A teacher can create a Calendar event, add a Google Meet video conference, and invite the entire class using the Classroom's automatically generated Google Group email address. This method is particularly useful for scheduling specific, recurring class sessions and integrates the calendar, meeting, and classroom functionalities.

A. The primary integration provides a direct link, so students do not need to manually enter codes to join.

C. The integration within Classroom generates a unique link automatically; manual creation and entry are not required.

D. Students use the standard Google Meet application or a web browser, not a separate, specialized app for Classroom.

1. Google for Education

Teacher Center. (n.d.). Unit 5: Facilitate group work. Google. Retrieved from https://skillshop.exceedlms.com/student/path/32348/activity/489592. (This unit discusses using Calendar and Meet with Classroom).

2. Google Classroom Help. (n.d.). Start a video meeting for education. Google. Retrieved from https://support.google.com/edu/classroom/answer/9776888. (This document outlines multiple methods

including creating meetings in Calendar for a class).

Google Sheets follows standard Google Docs Editors shortcuts: pressing Ctrl + Z (Cmd + Z on Mac) reverses the most recent action, restoring the previous state of the sheet.

A. Ctrl + V pastes clipboard contents; does not undo.

C. Ctrl + C copies selected cells; does not undo.

D. Ctrl + X cuts selected cells; does not undo.

1. Google Docs Editors Help – “Keyboard shortcuts for Google Sheets

” table row “Undo” (support.google.com/docs/answer/181110)

Google Docs smart chips allow users to insert rich, interactive links to a wide variety of content by typing "@". This functionality includes creating links to other Google Workspace files, such as Slides and Docs, as well as any other file type stored in Google Drive, including PDFs and audio files. This makes "All of the above" the correct and most comprehensive answer, as smart chips can reference all the listed content types through the file chip feature.

A. This is incorrect because it is incomplete. Smart chips can link to audio files, but also to Slideshows and PDFs.

C. This is incorrect because it is incomplete. Smart chips can link to Slideshows, but also to audio files and PDFs.

D. This is incorrect because it is incomplete. Smart chips can link to PDFs, but also to audio files and Slideshows.

1. Google Workspace Learning Center. (n.d.). Use smart chips in Google Docs. Google. Retrieved from https://support.google.com/a/users/answer/11596410. The documentation states

"You can add smart chips for... Files: Insert Google Docs

Sheets

Slides

and other file types." This confirms that all listed file types are supported.

Smart chips (people, files, events, place chips, etc.) rely on contextual AI to surface suggestions. Google’s documentation states that suggestions “might not always be perfect,” and users should review and edit as needed, confirming that chips can sometimes be inaccurate or irrelevant.

A. Documentation explicitly notes suggestions may be imperfect.

B. Accuracy is not tied to subscription tier; all users receive the same AI model.

D. While content richness can influence relevance, Google makes no guarantee that sufficient content ensures accuracy; errors can still occur.

1. Google Docs Help

“Add smart chips & building blocks

” note under ‘Tip’ (support.google.com/docs/answer/12150699).

2. Google Docs Help

“Use Smart Compose & grammar suggestions

” disclaimer line “Suggestions might not always be correct” (support.google.com/docs/answer/9331168).

A Smart chip behaves like ordinary inline text; deleting it simply removes that chip from the document while leaving all other content and formatting untouched.

A. Smart chips are document elements, not app installers; deleting one doesn’t affect third-party apps.

C. Chips are inline objects; removing one doesn’t alter paragraph or page formatting.

D. Deleting a chip affects only that selected element, not the whole document.

1. Google Docs Help – “Use smart chips & building blocks

” subsection “Remove a smart chip” (support.google.com/docs/answer/12533771)

2. Google Workspace Blog – “Smart canvas updates

” paragraph on deleting chips (blog.google)

Smart chips in Google Docs are interactive elements that provide rich context and functionality directly within the document. By typing "@", users can insert smart chips for people, files, dates, and events. These chips act as dynamic links, allowing users to preview information, see contact details, or open linked files without leaving the document. They streamline workflows by integrating information from other Google Workspace apps, suchas Calendar and Drive, directly into the text. This feature enhances collaboration and information access, going beyond simple hyperlinks to external web pages.

B. Advanced formulas are a feature of Google Sheets, not Google Docs. Smart chips are for linking information, not performing calculations.

C. Text formatting tools (like bold, italics, or fonts) are separate from smart chips, which are about embedding dynamic content and links.

D. The commenting feature is a distinct tool for collaboration and feedback, separate from the function of inserting smart chips into the document's body.

1. Google Docs Help. (n.d.). Insert smart chips in your Google Docs

Sheets

Slides & Drawings. Google. Retrieved from https://support.google.com/docs/answer/10555896. (See section "Add a smart chip").

2. Google Workspace Learning Center. (n.d.). Google Docs cheat sheet. Google. Retrieved from https://support.google.com/a/users/answer/9300022. (See section "Insert special items

" which describes using the "@" menu for smart chips).

In Google Sheets, the "Freeze panes" feature is used to keep a specific area of a worksheet visible while you scroll to another area. This is particularly useful for keeping row headers or column labels in view when working with large datasets. The option is found under the "View" > "Freeze" menu, where you can select the number of rows or columns to freeze. This functionality is standard across most spreadsheet applications.

"Protect range" is a security feature that prevents specified users from editing a part of the sheet; it does not affect scrolling visibility.

"Pin rows/columns" is not the terminology used in Google Sheets for this feature; the correct term is "Freeze."

"Lock cells" is synonymous with protecting cells from being edited, not with keeping them visible during scrolling.

- Google Workspace Learning Center. (n.d.). Edit & format a spreadsheet. Google. Retrieved from https://support.google.com/a/users/answer/9308853. (Under the section "Organize your data

" it explicitly states: "Freeze header rows and columns: Keep a row or column in the same place as you scroll through your spreadsheet.")

- Google for Education. (n.d.). Unit 4: Organize your data. Teacher Center: Fundamentals Training. Retrieved from https://skillshop.exceedlms.com/student/path/18127-fundamentals-training. (This official training material covers freezing rows and columns as a key data organization skill in Google Sheets.)