Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo
Workplace Software and Skills

9.5 Google Sheets Basics

Workplace Software and Skills9.5 Google Sheets Basics

Table of contents
  1. Preface
  2. 1 Technology in Everyday Life and Business
    1. Chapter Scenario
    2. 1.1 Computing from Inception to Today
    3. 1.2 Computer Hardware and Networks
    4. 1.3 The Internet, Cloud Computing, and the Internet of Things
    5. 1.4 Safety, Security, Privacy, and the Ethical Use of Technology
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  3. 2 Essentials of Software Applications for Business
    1. Chapter Scenario
    2. 2.1 Software Basics
    3. 2.2 Files and Folders
    4. 2.3 Communication and Calendar Applications
    5. 2.4 Essentials of Microsoft 365
    6. 2.5 Essentials of Google Workspace
    7. 2.6 Collaboration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  4. 3 Creating and Working in Documents
    1. Chapter Scenario
    2. 3.1 Navigating Microsoft Word
    3. 3.2 Formatting Document Layout in Microsoft Word
    4. 3.3 Formatting Document Content in Microsoft Word
    5. 3.4 Collaborative Editing and Reviewing in Microsoft Word
    6. 3.5 Document Design
    7. 3.6 Navigating Google Docs
    8. 3.7 Formatting Layout and Content in Google Docs
    9. 3.8 Collaborative Editing and Reviewing in Google Docs
    10. 3.9 Versions and Version History
    11. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  5. 4 Document Preparation
    1. Chapter Scenario
    2. 4.1 Microsoft Word: Advanced Formatting Features
    3. 4.2 Working with Graphics and Text Tools in Microsoft Word
    4. 4.3 Managing Long Documents in Microsoft Word
    5. 4.4 Google Docs: Enhanced Formatting Features
    6. 4.5 Working with Graphics and Text Tools in Google Docs
    7. 4.6 Managing Long Documents in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  6. 5 Advanced Document Preparation
    1. Chapter Scenario
    2. 5.1 Creating Different Document Types in Microsoft Word
    3. 5.2 Mail Merge in Microsoft Word
    4. 5.3 Creating Forms in Microsoft Word
    5. 5.4 Creating Different Document Types in Google Docs
    6. 5.5 Creating Forms in Google Docs
    7. 5.6 Advanced Collaboration in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  7. 6 Preparing Presentations
    1. Chapter Scenario
    2. 6.1 Presentation and Design Essentials
    3. 6.2 Designing a Presentation in Microsoft PowerPoint
    4. 6.3 Formatting Microsoft PowerPoint Slides: Layout and Design Principles
    5. 6.4 Adding Visuals and Features to Microsoft PowerPoint Slides
    6. 6.5 Designing a Presentation in Google Slides
    7. 6.6 Creating Google Slides: Layout and Text
    8. 6.7 Adding Visuals and Features to Google Slides
    9. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  8. 7 Advanced Presentation Skills
    1. Chapter Scenario
    2. 7.1 Effective Presentation Skills
    3. 7.2 Finalizing a Slide Collection
    4. 7.3 Preparing a Microsoft PowerPoint Collection for Presentation
    5. 7.4 Preparing a Google Slides Collection for Presentation
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  9. 8 Content Management Systems and Social Media in Business
    1. Chapter Scenario
    2. 8.1 What Are Content Management Systems?
    3. 8.2 Common Content Management Systems
    4. 8.3 Creating Content with a Content Management System
    5. 8.4 Search Engine Optimization
    6. 8.5 Social Media in Business
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  10. 9 Working with Spreadsheets
    1. Chapter Scenario
    2. 9.1 Microsoft Excel Basics
    3. 9.2 Text and Numbers in Microsoft Excel
    4. 9.3 Calculations and Basic Formulas in Microsoft Excel
    5. 9.4 Formatting and Templates in Microsoft Excel
    6. 9.5 Google Sheets Basics
    7. 9.6 Text and Numbers in Google Sheets
    8. 9.7 Calculations and Basic Formulas in Google Sheets
    9. 9.8 Formatting and Templates in Google Sheets
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  11. 10 Advanced Excel Formulas, Functions, and Techniques
    1. Chapter Scenario
    2. 10.1 Data Tables and Ranges
    3. 10.2 More About Formulas
    4. 10.3 Using Arithmetic, Statistical, and Logical Functions
    5. 10.4 PivotTables
    6. 10.5 Auditing Formulas and Fixing Errors
    7. 10.6 Advanced Formatting Techniques
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  12. 11 Advanced Excel Spreadsheets: Statistical and Data Analysis
    1. Chapter Scenario
    2. 11.1 Understanding Data, Data Validation, and Data Tables
    3. 11.2 Statistical Functions
    4. 11.3 What-If Analysis
    5. 11.4 PivotTables/Charts
    6. 11.5 Data Analysis Charts
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  13. 12 Using Excel in Accounting and Financial Reporting
    1. Chapter Scenario
    2. 12.1 Basic Accounting
    3. 12.2 Financial Functions in Microsoft Excel
    4. 12.3 Integrating Microsoft Excel and Accounting Programs
    5. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  14. 13 Understanding and Using Databases
    1. Chapter Scenario
    2. 13.1 What Is a Database?
    3. 13.2 Microsoft Access: Main Features and Navigation
    4. 13.3 Querying a Database
    5. 13.4 Maintaining Records in a Database
    6. 13.5 Creating Reports in Microsoft Access
    7. 13.6 Creating Forms in Microsoft Access
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  15. 14 Advanced Database Use
    1. Chapter Scenario
    2. 14.1 Advanced Queries in Microsoft Access
    3. 14.2 Multiple Table Forms
    4. 14.3 Customizing Forms
    5. 14.4 Customizing Reports
    6. 14.5 Using Macros
    7. 14.6 Data Analysis and Integration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  16. 15 Integrating Applications
    1. Chapter Scenario
    2. 15.1 Microsoft 365: Collaboration and Integration
    3. 15.2 Microsoft Word: Integration with Microsoft Excel and Microsoft Access
    4. 15.3 Microsoft Word and Microsoft PowerPoint Integration
    5. 15.4 Microsoft Excel and Microsoft PowerPoint Integration
    6. 15.5 Microsoft Excel and Microsoft Access Integration
    7. 15.6 Integrating Data from Other Programs into Google Workspace
    8. 15.7 New Developments: The Role of Artificial Intelligence
    9. 15.8 Mastering Workplace Software Skills: A Project
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
  17. Index

Learning Objectives

By the end of this section, you will be able to:

  • Identify common uses and basic features of Google Sheets
  • Describe the essential functions of each command group on the toolbar
  • Create a worksheet in Google Sheets
  • Open an existing workbook in Google Sheets
  • Print a Google Sheets file

Google Sheets is another spreadsheet application that has much of the same functionality as Microsoft Excel. They have similar GUIs, in that they use window menus and a toolbar. Excel has the ribbon, which has wide tabs filled with commands. Sheets only has one toolbar menu, although its button commands grow over time as the product is updated. Sheets contains all the same basic features as Excel, but Excel is more robust with regard to higher-level tools.

Common Uses and Basic Features

Sheets serves the same basic purposes as Excel and can be used for most of the same purposes that any spreadsheet could serve. Google Workspace is a web-based service and does not have desktop versions like Microsoft Office. Because of this, there are some limitations to the functionality of Sheets compared with Excel. To access Sheets, you need to have internet access and a Gmail account.

The basic features are the same as any other spreadsheet program. Similar to Excel, Sheets has rows and columns in an interface that does calculations for the user. It has automated features like autofill and easy copying of formatting. You can create all tables you’ve created in Excel in Sheets, including your order-dispatching worksheets or sales reports. Sheets also requires you to separate the values in each column so that the spreadsheet can read the numbers and calculate the desired result. Words and letters should be separated from numbers in order for spreadsheets to use the numbers for calculations. Sheets doesn’t have the same library of functions that you can find in Excel. On its own, Sheets may not be able to handle in-depth analysis like Excel can.

The Toolbar Overview

Sheets does not have any ribbon tabs like Excel. Instead, the toolbar is composed of menus and commands. The menu options are similar to those you see in Excel in the ribbon tabs. The menus are as follows: File, Edit, View, Insert, Format, Data, Tools, and Extensions. To view the contents in the menu, simply hover over the menu title with your cursor. The File and Edit menus are similar to those for Google Docs, as covered in Essentials of Google Workspace. The View menu gives the user the ability to freeze and group cells together. Inserting and deleting cells can be accessed in the Insert menu. The data and text can be formatted using the commands contained in the Format menu. The Data menu includes commands similar to the Data tab in Excel that are useful for analyzing data in a spreadsheet. The Tools menu is like the Review tab in Excel with spelling and grammar checking commands. Advanced features are in the Extensions menu.

The toolbar is called the action bar, and it mostly remains static, yet sometimes it adds functions based on usage. Figure 9.39 shows the toolbar. In addition to the menus, the toolbar includes buttons for the more frequently used commands for easy access. These commands can be accessed through the menus, but here they are available with one click. You will notice there is some similarity in the look of the icons in Sheets and Excel. The first two commands are Undo and Redo, then Print, and Paint format. After that, you see the Zoom drop-down menu, the Format as currency, Format as percent, Decrease decimal places or Increase decimal places, and more formats. Next are the menus for the font type and size, font formatting, border lines, alignment, text wrapping, and text rotation. The last group includes linking, commenting, and adding a graph, filter, or function.

Toolbar options: Undo, Redo, Print, Paint format, Zoom, Format as currency/percent, Decrease/Increase decimal places, More formats, Font type/size, Font formatting, Border lines, Alignment, Text wrapping/rotation, Linking, Commenting, Adding graph, filter, function.
Figure 9.39 The toolbar in Sheets has one row of commands. (Google Sheets is a trademark of Google LLC.)

Mac Tip

On a Mac, the Google Sheets action bar shows the menu, like on a PC. However, rather than simply hovering, you will need to click on the menu title to see its contents.

Creating Sheets

Figure 9.40 shows a finished sales report, much like an Excel worksheet. As in Excel, when you open Sheets, there is only one worksheet, called “Sheet1.” To add another sheet, you can click on the plus sign at the bottom left. This will add another sheet called “Sheet2.” Let’s walk through the steps to create this table in Sheets. Let’s assume that you have handwritten invoices of a set of orders, and you want to enter these invoices in Excel or Sheets. The receipt-block pads are customized with a unique receipt number, your company logo, contact data, and other business information. These were popular before small and medium businesses started to use computerized receipts, yet you may still see these handwritten receipts sometimes. In such a case, after the sale has occurred, you need to input the data into Excel or Sheets.

The first step in re-creating the table in Figure 9.40 is to insert and format the headers in a blank worksheet. Then, select the first 20 rows below the headers, since the table has 20 rows of data (Figure 9.41), click on the Borders drop-down menu, and choose All Borders. Next, change the format type for each column based on the contents of the column (Figure 9.42). For cells A2 to A21, use the Date format under the More Formats drop-down menu. Format cells B2 to B21 and C2 to C21 as Plain Text. You can leave cells D2 to D21 as Automatic or change them to Plain Text. Format cells E2 to E21 and G2 to G21 as Accounting. Automatic as a format type is the equivalent of “General” in Excel. To select two columns that are not contiguous, select the first one, in this case E, then press Ctrl on the keyboard, and select G. This is called the Ctrl+Select process. For column F, you can leave it as Automatic or format it as a number. Now, you are ready to do the data entry of the manual invoicing. You will format the header after entering the data.

An arrow points to a “+” in the bottom left of Sheet 1.
Figure 9.40 Formatting a normal sales report table in Sheets is similar to formatting in Excel. The table contains different types of data. First, create the headers. (Google Sheets is a trademark of Google LLC.)
Cells A1 to G20 are selected in a spreadsheet and the Borders icon is selected. All borders is selected from the options visible.
Figure 9.41 Then, highlight the cells you will be filling in to add borders. (Google Sheets is a trademark of Google LLC.)
Column A is selected on a spreadsheet. The 123 button opens to selection including the selected Automatic.
Figure 9.42 Format each column according to the type of data it will contain. The first column is a date, so you can choose Date from the menu. The next two columns can be formatted as plain text. Columns E and G can be formatted as Accounting. You can use Ctrl+Select to format both of them at the same time. (Google Sheets is a trademark of Google LLC.)

Next, enter the data in row 2, and follow the same steps for subsequent rows. The first several columns only require typing in data from the data source. The first order was placed on February 27, 2021, for 14 model E-900s 32-inch LCD TVs for $170 each. First, enter the date as 02-27-21 (Figure 9.43a). Because we selected the format in advance, it will automatically be formatted to the desired format of 02/27/2021. Fill in the rest of the data from the order across the row (Figure 9.43b). The price is already in accounting format, so you do not need to type the currency symbol. The Revenue, column G, is the product of the price and the quantity, so type in a formula, “=E2*F2” (Figure 9.43b).

(a) Row 1 is populated with headings. Cell A2 is selected (2-27-21 inside). (b) Headings display in columns of row 1. Information populates row 2. Cell G2 selected; Formula bar displays =E2*F2.
Figure 9.43 First, populate the first row of the table. (a) The date should automatically be formatted as month/day/year. The rest of the data can be copied from the order. (b) The revenue cell needs a formula so that it calculates the product of the price and the quantity. Notice the date is formatted correctly once you press Enter or navigate to another cell. (Google Sheets is a trademark of Google LLC.)

Now that the first row is finished, you will adjust the width of each column to accommodate the data so it looks like the original table. Place your cursor on the edge of column A, and the cursor will change to an arrow (Figure 9.44a), then double-click it. The column automatically adjusts to the width of the contents. To do this with a single action, highlight the entire table and then double-click between any two columns. This will apply the AutoFit function to all columns you have selected (highlighted). When you do this for all columns, the columns all have different widths (Figure 9.44b). Finally, to format the header row, select the whole row and click on the Fill color command, choosing a similar color, as shown in Figure 9.45.

(a) Right side of Column A is highlighted blue. Columns vary in width. (b) Columns display in all different widths to accommodate the date inside the cells.
Figure 9.44 After entering a row of data, you can do the final formatting of the table. (a) Double-click at the edge of a column to change the width automatically. (b) Repeat this process for all columns. (Google Sheets is a trademark of Google LLC.)
Row 1 is selected and the Fill color command (paint bucket icon) selected. The drop down shows “Reset” and 60 different color circles with the white selected with a checkmark.
Figure 9.45 You can change the white fill color of the header row to match the original table by choosing blue from the Fill color command. (Google Sheets is a trademark of Google LLC.)

Navigating Existing Sheets

To open existing sheets, you start from Google Drive. Sign into your Drive account, then browse through your files to look for the existing workbooks. Double-click on an existing Sheets file, and it will open in a new browser tab. Figure 9.46 shows several files in Google Drive. You will need to recognize the icon for Sheets to know which are workbooks. The icon for Sheets is green. Sheets can also open Excel files. To browse for the saved Excel files not found in your Google Drive, choose Upload.

Google My Drive Page is visible. Arrow points to green box with off center “t” on second file. Another arrow points to green box with white “X” in center on fourth file.
Figure 9.46 To open a Sheets file from Google Drive, you need to recognize the icon for spreadsheets. The first arrow points to an Excel file, and the second arrow points to a Sheets file. Sheets can open both types. (Google Sheets is a trademark of Google LLC.)

Spotlight on Ethics

Maintaining Accountability with Version History

In order to open Docs or Sheets, you will need to create or log in to your Google account. Every time you make a change to a file, Google Workspace uses your username to track it. If multiple people have been given access to open or edit the file, Google tracks these changes. You can review the changes different collaborators in your company make to a file using the Version History feature located near the bottom of the File menu. Version history is tracked from file creation. If a user has editing privileges for a document, they can see the version history. You can also filter changes by date to see what users changed on a specific date. You can check what changes any coworker made in the document. Having access to the version history of the document protects the integrity of collaborating with others by establishing accountability. Changes to the file cannot be made without other collaborators knowing that changes have been made. This allows transparency of information flow between collaborators. This can become important in tracking down errors in the file and can guide you if you need to revert to an earlier version of a document. It is also an important feature that helps collaboration when the individuals are not in the same location.

Printing Sheets

The process for printing worksheets in Sheets is the same as it is in Excel. Choose Print from the File menu (Figure 9.47a). The dialog box that opens (Figure 9.47b) lets you choose the print settings, such as page setup, range of pages to print, and zoom level, just like in Excel. The Print dialog box allows you to adjust the margins and add page breaks to make sure the spreadsheet prints as you would like. To adjust the margins, choose the Margins menu from the right side of the display. To add page breaks, choose Set Custom Page Breaks and move the lines to the desired location for the page breaks. Then, choose Confirm Breaks in the upper-right corner. You can also choose to print the active worksheet or the whole workbook. The whole workbook choice is shown in Figure 9.47b. When you click Next, Sheets will generate a preview of the file you are printing. Typically, your printer is listed as the default destination for printing. Choose the down arrow to choose your printer if it is not automatically listed. You can also generate a .pdf file, which you can save and then download from the browser into your computer. You can then open the .pdf file in Adobe Acrobat or any other .pdf viewer, such as Microsoft Edge, and print it there.

(a) Print is selected from the File menu. (b) Print pane displays option for Workbook which opens to Selected cells (A1). Portrait Orientation, Normal Scale/Margins, Formatting, and Headers & Footers also available.
Figure 9.47 Printing from Sheets is similar to printing from Excel. (a) Select Print from the File menu. You can print the current sheet. (b) You can also print the entire workbook. Choose your printer from the Destination drop-down menu or save the file as a .pdf. (Google Sheets is a trademark of Google LLC.)
Citation/Attribution

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.