Creating and opening spreadsheets in Google Sheets - Quick Revision & Summary

Recall & Review

beginner

What is the first step to create a new spreadsheet in Google Sheets?

Open Google Sheets and click on the blank template or the '+' button to start a new spreadsheet.

beginner

How do you open an existing spreadsheet in Google Sheets?

Go to Google Sheets homepage or Google Drive, find your file, and click on it to open.

beginner

What is the benefit of naming your spreadsheet right after creating it?

It helps you find the file easily later and keeps your files organized.

intermediate

Can you create a spreadsheet offline in Google Sheets?

Yes, if you enable offline mode in Google Drive, you can create and edit spreadsheets without internet.

beginner

What happens automatically when you create or edit a spreadsheet in Google Sheets?

Google Sheets automatically saves your changes in real-time, so you don’t have to worry about losing work.

Where do you click to create a new blank spreadsheet in Google Sheets?

A On the '+' button or blank template

B On the settings gear icon

C On the share button

D On the help menu

The '+' button or blank template is used to create a new spreadsheet.

How do you find an existing spreadsheet to open it?

A Use the print option

B Search in Google Drive or Google Sheets homepage

C Create a new spreadsheet

D Close the browser

You open existing files by searching or browsing in Google Drive or Google Sheets homepage.

What is the purpose of naming your spreadsheet?

A To share it with others

B To delete it automatically

C To organize and find it easily later

D To print it

Naming helps you organize and find your spreadsheet easily.

Does Google Sheets save your work automatically?

A Only if you press Ctrl+S

B No, you must save manually

C Only when you close the file

D Yes, it saves in real-time

Google Sheets autosaves your work as you type.

Can you create and edit spreadsheets without internet in Google Sheets?

A Yes, if offline mode is enabled

B No, internet is always required

C Only for viewing, not editing

D Only on mobile apps

Offline mode allows creating and editing without internet.

Describe the steps to create a new spreadsheet in Google Sheets.

Think about what you do first and how you start a new file.

Explain how to open an existing spreadsheet and why naming files is important.

Consider where your files are stored and how names help.

Practice

1. What does creating a spreadsheet mean in Google Sheets?

easy

A. Sharing a file with others

B. Deleting an existing file

C. Printing a document

D. Starting a new file to enter data

Solution

1. Step 1: Understand the meaning of creating a spreadsheet

   Creating means making a new file where you can add data.

2. Step 2: Compare options with the meaning

   Only Starting a new file to enter data matches starting a new file to enter data.

3. Final Answer:

   Starting a new file to enter data -> Option D

4. Quick Check:

   Creating spreadsheet = new file [OK]

Hint: Creating means making a new file, not editing or deleting [OK]

Common Mistakes:

• Confusing creating with opening an existing file
• Thinking creating means sharing or printing
• Mixing up deleting with creating

2. Which of these is the correct way to open an existing spreadsheet in Google Sheets?

easy

A. Click 'File' > 'New' > 'Spreadsheet'

B. Go to Google Drive and double-click the spreadsheet file

C. Type a formula to open the file

D. Use the 'Insert' menu to open a spreadsheet

Solution

1. Step 1: Identify how to open existing files

   Opening means accessing a file already saved, usually by clicking it in Google Drive.

2. Step 2: Check options for correct method

   Go to Google Drive and double-click the spreadsheet file correctly describes opening by double-clicking the file in Google Drive.

3. Final Answer:

   Go to Google Drive and double-click the spreadsheet file -> Option B

4. Quick Check:

   Open spreadsheet = double-click file in Drive [OK]

Hint: Open files by clicking them in Google Drive, not by formulas [OK]

Common Mistakes:

• Trying to open files using formulas
• Confusing 'New' with opening existing files
• Looking for open option inside 'Insert' menu

3. You want to start a new spreadsheet in Google Sheets. Which action will open a blank spreadsheet ready for data entry?

medium

A. Click the '+ Blank' button on the Google Sheets homepage

B. Type =NEW() in any cell

C. Right-click a cell and select 'Open Spreadsheet'

D. Use the 'Format' menu to create a new sheet

Solution

1. Step 1: Identify how to create a new spreadsheet

   On Google Sheets homepage, the '+ Blank' button creates a new empty spreadsheet.

2. Step 2: Evaluate other options for correctness

   Options A, B, and C are incorrect because the 'Format' menu does not create new spreadsheets, formulas can't create files, and right-click doesn't open new files.

3. Final Answer:

   Click the '+ Blank' button on the Google Sheets homepage -> Option A

4. Quick Check:

   New spreadsheet = '+ Blank' button [OK]

Hint: Use '+ Blank' button to start new spreadsheet, not formulas [OK]

Common Mistakes:

• Trying to create files with formulas
• Looking for new file option in wrong menus
• Confusing sheet tabs with new spreadsheets

4. You tried to open a spreadsheet by typing =OPEN("MyFile") in a cell, but it shows an error. What is the problem?

medium

A. The file name must be in lowercase

B. You need to use the IMPORT formula instead

C. Google Sheets does not have an OPEN formula to open files

D. You must enable file opening in settings first

Solution

1. Step 1: Understand formula limitations in Google Sheets

   Google Sheets formulas cannot open or create files; they only work with data inside sheets.

2. Step 2: Analyze the error cause

   The formula =OPEN() does not exist, so it causes an error.

3. Final Answer:

   Google Sheets does not have an OPEN formula to open files -> Option C

4. Quick Check:

   No OPEN formula exists in Google Sheets [OK]

Hint: Files open via interface, not formulas like =OPEN() [OK]

Common Mistakes:

• Assuming formulas can open files
• Trying to fix error by changing file name case
• Looking for settings to enable file opening by formula

5. You want to organize your work by creating a new spreadsheet and then sharing it with your team. What is the correct sequence of actions?

hard

A. Create a new spreadsheet via '+ Blank', then click 'Share' to add team emails

B. Open an existing spreadsheet, then use a formula to share it

C. Type =SHARE() in a cell after creating a spreadsheet

D. Create a new spreadsheet, then download and email it manually

Solution

1. Step 1: Create a new spreadsheet

   Use the '+ Blank' button on Google Sheets homepage to start a new file.

2. Step 2: Share the spreadsheet with your team

   Click the 'Share' button in the top-right corner and enter team members' emails.

3. Step 3: Evaluate other options

   Open an existing spreadsheet, then use a formula to share it is wrong because opening existing file is not creating new. Type =SHARE() in a cell after creating a spreadsheet is wrong because no SHARE formula exists. Create a new spreadsheet, then download and email it manually is possible but less efficient than direct sharing.

4. Final Answer:

   Create a new spreadsheet via '+ Blank', then click 'Share' to add team emails -> Option A

5. Quick Check:

   Create then Share = '+ Blank' then 'Share' button [OK]

Hint: Create new file first, then share via button, not formulas [OK]

Common Mistakes:

• Trying to share using formulas
• Opening old files instead of creating new
• Downloading instead of sharing online