Creating and opening spreadsheets in Google Sheets - Business Scenario Walkthrough

Scenario Mode

👤 Your Role: You are an office assistant at a small company.

📋 Request: Your manager asks you to create a new spreadsheet to track monthly expenses and then open it for data entry.

📊 Data: You have no existing data yet. You need to start a new spreadsheet with columns for Date, Category, Description, and Amount.

🎯 Deliverable: A new Google Sheets spreadsheet with the correct columns set up and opened ready for entering expense data.

Sample Data

Date	Category	Description	Amount

1

Step 1: Open Google Sheets by going to sheets.google.com in your web browser.

No formula needed.

Expected Result

Google Sheets homepage opens showing your existing spreadsheets and an option to create a new one.

2

Step 2: Click the blank (+) button to create a new spreadsheet.

No formula needed.

Expected Result

A new untitled spreadsheet opens with a blank sheet.

3

Step 3: In the first row, enter the column headers: Date in A1, Category in B1, Description in C1, and Amount in D1.

No formula needed.

Expected Result

The first row shows the headers: Date, Category, Description, Amount.

4

Step 4: Rename the spreadsheet by clicking on 'Untitled spreadsheet' at the top and typing 'Monthly Expenses'.

No formula needed.

Expected Result

The spreadsheet title changes to 'Monthly Expenses'.

5

Step 5: Save the spreadsheet. Google Sheets saves automatically, so no manual save is needed.

No formula needed.

Expected Result

Spreadsheet is saved in your Google Drive and ready for data entry.

6

Step 6: To open this spreadsheet later, go to sheets.google.com and click on 'Monthly Expenses' from your list of files.

No formula needed.

Expected Result

The 'Monthly Expenses' spreadsheet opens ready for editing.

Final Result

Monthly Expenses Spreadsheet

| Date       | Category   | Description       | Amount  |
|------------|------------|-------------------|---------|
|            |            |                   |         |
|            |            |                   |         |

✓You successfully created a new spreadsheet with the correct columns.

✓You renamed the file for easy identification.

✓You know how to open the spreadsheet later for data entry.

Bonus Challenge

Add data validation to the Category column to allow only these options: Food, Transport, Utilities, and Other.

Show Hint

Select the Category column cells, then use Data > Data validation, choose 'List of items', and enter the options separated by commas.

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