g sheets introduction
TRANSCRIPT
![Page 1: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/1.jpg)
Sheets
Google Sheets is a web-based spreadsheet that allows you to store, organize, sort and manage different types of information, in a similar way to Microsoft Excel.
![Page 2: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/2.jpg)
Create a spreadsheet using Google Sheets
Sheets
![Page 3: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/3.jpg)
Sheets
From within Google Drive, click New and select Google Sheets from the drop-down menu.
![Page 4: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/4.jpg)
A blank spreadsheet will appear in a new browser tab
Sheets
![Page 5: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/5.jpg)
Click on Untitled spreadsheet and enter a name for your spreadsheet.
Press ENTER
Your named spreadsheet will be saved in your Google Drive.
Sheets
![Page 6: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/6.jpg)
A column is a group of cells that runs vertically from top to bottom.
Columns are identified by letters.
Sheets
![Page 7: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/7.jpg)
A row is a group of cells that runs horizontally from left to right.
Rows are identified by numbers.
Sheets
![Page 8: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/8.jpg)
The formula bar is used to enter and edit data,
functions, and formulas for the selected cell.
Sheets
![Page 9: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/9.jpg)
Each rectangle in a spreadsheet is called a cell.
A cell is where a row and a column intersect. Cell A1 is highlighted.
Sheets
![Page 10: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/10.jpg)
By clicking and dragging your mouse, you can select a range of cells
In this example cells A1 to B10 are selected.
This range would be referenced as A1:B10 in the formula bar.
Sheets
![Page 11: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/11.jpg)
Sometimes, when entering data in a cell, the data may be longer than the cells width.
There are several things you can do to address this.
Sheets
![Page 12: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/12.jpg)
You can resize the column to fit the width of the data.
When you hover your mouse over the dividing line between the column ID letters
the cursor will switch into a right pointing arrow and the line will turn blue.
Click and hold, whilst dragging, to resize the column.
Sheets
![Page 13: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/13.jpg)
You can, instead, select the ‘Text Wrapping’ function.
Click the highlighted button and a sub-menu will appear.
Select the middle icon and height of the row will resize to accommodate your data.
Sheets
![Page 14: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/14.jpg)
Select the formatting icons to make the text BOLD and CENTRED.
Your spreadsheet should look similar to the one below.
Sheets
![Page 15: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/15.jpg)
Now, recreate the layout shown below.
Not forgetting to rename your spreadsheet to “G Sheets Lesson 1”
Sheets
![Page 16: G Sheets introduction](https://reader031.vdocuments.us/reader031/viewer/2022030402/587c7a271a28abd04e8b7ac9/html5/thumbnails/16.jpg)
Create a spreadsheet using Google Sheets
Sheets
Complete 12 surveys and populate your new spreadsheet.