Embedded Files
Getting Started
Getting Started
Throughout the tutorial you will have two windows active; a window displaying the tutorial and a window displaying Google Sheets. Let's begin!
Do the following:
➤ Log in to your Google Drive account and create a new spreadsheet.
➤ Resize and position the window, displaying the tutorial next to the blank spreadsheet.
When a new spreadsheet is created, all the cells are empty by default. A cell is active when the border is highlighted in black. When you enter information, the information is stored in the active cell.
Entering Information Into a Spreadsheet
Entering Information Into a Spreadsheet
Entering Text and Constants
Entering Text and Constants
➤ Click on the Spreadsheet window, select a cell by clicking on it, and enter: Google Docs is fun.
Observe that your text is displayed in two areas. Text is displayed in the active cell within the spreadsheet and it is also displayed in the formula bar. The formula bar is activated as soon as you begin typing in a cell. If you want to edit the text you entered into a cell, click the formula bar, type your changes and click Enter.
Entering Formulas
Entering Formulas
All formulas in Google Sheets must begin with an equal sign (=). When a formula is entered into a cell, the formula itself is displayed in the formula bar when that cell is highlighted, and the result of the formula is displayed in the actual cell.
Do the following:
➤ Within the Spreadsheet window, select cell A2 and enter the constant value 12.
➤ Within the Spreadsheet window, select cell A3 and enter the constant value 15.
➤ Within the Spreadsheet window, select cell A4 and click on the formula bar.
➤ Within the formula bar, enter an equal sign followed by =A2+A3.
➤ Click Enter to enter the formula
Note the Spreadsheet displays the result of the formula in cell A4
➤ Within the Spreadsheet window, select cell A3 and change the number to 40, and click Enter.
Note the formula value should have changed in cell A4 to the number 52
Now that you know how to enter information into Spreadsheets it is time to create a simple spreadsheet.
Now that you know how to enter information into Spreadsheets it is time to create a simple spreadsheet.
Page updated
Google Sites
Report abuse