Creating and opening spreadsheets in Google Sheets - Formula Evaluation Walkthrough

Sample Data

A simple spreadsheet with names and ages.

Cell	Value
A1	Name
B1	Age
A2	Alice
B2	30
A3	Bob
B3	25

Formula Trace

IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz456", "Sheet1!A1:B3")

Step 1: IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123xyz456", "Sheet1!A1:B3")

Step 2: Data fetched: [["Name", "Age"], ["Alice", 30], ["Bob", 25]]

Cell Reference Map

  A       B
1 Name    Age
2 Alice   30
3 Bob     25

Formula references external spreadsheet range Sheet1!A1:B3

The formula imports the range A1:B3 from another spreadsheet, which contains names and ages.

Result

  A       B
1 Name    Age
2 Alice   30
3 Bob     25

The imported data appears in the current sheet exactly as it is in the source spreadsheet.

Sheet Trace Quiz - 3 Questions

What does the IMPORTRANGE formula do?

A It deletes data from the sheet.

B It imports data from another Google Sheets file.

C It creates a new spreadsheet.

D It sorts data in the current sheet.

Key Result

IMPORTRANGE("spreadsheet_url", "sheet_name!range") imports data from another Google Sheets file.

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