Now we're ready to start exploring Google Sheets.
Exploring the Sheets interface
When a file is saved in Google Sheets, it is saved as a workbook, which is a file consisting of one or more related spreadsheets known as worksheets. At the bottom of the workbook, there are tabs for each worksheet. You can see that this worksheet is named "Fundraiser Sales." New worksheets can be added as needed.
Exploring the worksheet
Some elements of the Google Sheets workspace are described below:
At the top of the worksheet, we see the workbook name, Google Sheets: The Basics. Under the file name we see the menu bar. Many of the commands we will use in Google Sheets are found in these menus. The toolbar is also at the top of the workbook. The toolbar contains various command buttons, such as undo, print, font size, and bold.
The worksheet is made up of rowsand columns. The rows are labeled with numbers and the columns are labeled with letters. Google Sheets can support several thousand columns and over a million rows.
Columns and rows are made up of consecutive cells. The currently selected cell is the active cell. Any data entered or formatting applied will take place in the active cell.
Each cell has a unique address, called a cell reference. This address is made up of the column letter followed by the row number. In the following example, the selected cell is in column A and row 2. Therefore the cell reference is A2.
Column letters are not case sensitive. The cell reference for A2 could be written as a2.
Google Sheets refers to a cell or group of cells as a range. A range can contain a single cell or an entire workbook. The address of a range is determined by the address of its upper-left cell, followed by a colon (:), and the address of the lower-right cell. In this example, the selected range would be A2:B3.
Navigating the worksheet
Both the mouse and the keyboard can be used to move around within the worksheet. Let's practice navigating through the worksheet before we continue.
Now that we're familiar with the Google Sheets interface, we're ready to explore data types, formulas, and functions.