16 Questions
Collaborate in real-time from ______
Sheets
Share using ______ for the web or a shared workbook
Excel
Save automatically using ______ or OneDrive
SharePoint
Add formulas and use ______ AutoComplete for suggestions
Formula
Record macros or use ______ Apps Script
Create filters and ______ views
filter
Set notifications in ______
OneDrive
In Chrome Browser, in the top-right corner next to the address bar, click your ______ image
profile
With Google ______, you can create and edit spreadsheets directly in your web browser—no special software is required.
Sheets
Create and name your ______, Sheets, Slides, or Forms.
Docs
You can import and convert an existing spreadsheet to ______, Sheets, or Slides.
Docs
In the Upload complete window, click Show file location and then right-click the file and select Open with Google ______/Sheets/Slides.
Docs
Learn the differences between Microsoft Excel and Google ______, and get best practices for collaboration at work or school.
Sheets
You can ______ spreadsheets from Google Sheets.
export
You can get ______ productivity tips for Google Sheets.
Sheets
Microsoft Excel and Google ______ have many similar features and important differences.
Sheets
Study Notes
Google Sheets Basics
- Google Sheets allows users to create and edit spreadsheets directly in their web browser, without requiring special software.
- Multiple people can work on a spreadsheet simultaneously, and all changes are saved automatically.
Creating a New Spreadsheet
- To create a new spreadsheet, open a Google Docs, Sheets, Slides, or Forms home screen and click "Create".
- You can also create a document from a template or import an existing spreadsheet from another program.
Importing and Converting Existing Spreadsheets
- To import an existing spreadsheet, go to Google Drive, click "New File Upload", and choose the file to upload.
- Once uploaded, right-click the file and select "Open with Google Sheets" to edit it in your browser.
Switching from Excel to Sheets
- Google Sheets and Microsoft Excel have similar features, but also important differences.
- Switching to Sheets enables real-time collaboration and automatic saving to Drive.
Key Differences between Excel and Sheets
- Collaboration: Sheets allows real-time collaboration, while Excel requires a shared workbook or SharePoint/OneDrive.
- Saving: Sheets saves automatically to Drive, while Excel requires manual saving to SharePoint or OneDrive.
- Formulas: Sheets provides formula suggestions as you type, while Excel has Formula AutoComplete.
- Macros: Sheets uses Google Apps Script, while Excel uses VBE.
- Filters: Sheets creates filters and filter views, while Excel creates filters.
- Pivot tables: Sheets creates pivot tables manually or automatically with Explore, while Excel requires manual creation.
- Charts: Sheets creates charts manually or automatically with Explore, while Excel creates charts manually.
- Notifications: Sheets set notifications, while Excel sets notifications in OneDrive.
Accessing Google Sheets
- Google Sheets can be accessed through a web browser at sheets.google.com, Google Drive, or most Google pages.
- The Sheets app is available for Android and iOS devices, and can be added as a browser bookmark or desktop shortcut (Windows only).
- Offline work is possible with Chrome only.
Learn how to create and edit spreadsheets online with Google Sheets, a web-based application that allows real-time collaboration and automatic saving.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
