Google Workspace CE Level 1 Prep

Google Sheets use

• Spreadsheet creation and data analysis

• Word processing and document editing

• Graphic design and image editing

• Video editing and production

Slides feature: Presenter view

• Speaker notes and slide previews during presentations

• Full-screen slide display without notes

• Automatic slide transitions during presentations

• Real-time audience feedback and polling

Comparing Drive and Docs: Storage vs. Editing

• Drive is for creating and editing documents; Docs stores files.

• Drive stores files; Docs is for creating and editing documents.

• Drive is a cloud storage service; Docs is a photo editing tool.

• Drive is for sharing files; Docs is for managing spreadsheets.

Real-time collaboration in Docs

• Users can edit documents simultaneously.

• Users can only view documents at the same time.

• Users can edit documents, but only one at a time.

• Users can only comment on documents without editing.

Drive feature: File sharing

• Files/folders with specific people or groups

• Files/folders with anyone on the internet

• Files/folders that are public to everyone

• Files/folders that can only be shared via email

Slides feature: Themes

• Visual styles for presentations

• A type of animation effect

• A method for data analysis

• A tool for video editing

Sheets feature: Formulas

• Calculations using built-in functions like SUM and AVERAGE.

• A tool for creating charts and graphs.

• A method for formatting text and cells.

• A way to import data from external sources.

Google Docs function

• Spreadsheet creation and analysis

• Word processing and document collaboration

• Graphic design and editing

• Database management and querying

Docs feature: Voice typing

• Allows users to dictate text directly into documents.

• Enables users to convert text to speech.

• Facilitates collaborative editing in real-time.

• Provides templates for document formatting.

Google Slides main purpose

• Creating spreadsheets

• Editing presentations online

• Designing websites

• Managing emails