Embedded Files
Overview
You may have already worked with spreadsheets at school. This section is an introduction to Google Sheets. If you already have experience with spreadsheets, much of this information will be review. You may discover alternate ways to perform tasks or learn shortcuts to speed up your work.
In this section you will
learn key features of Google Sheets
use help functions and online references
open and save a workbook
insert and delete worksheets
move, copy, and rename worksheets
change the tab window size
create hyperlinks
Key Features of Google Sheets
Study the Google Sheets screen to learn about some of the features. Watch the “Google Sheets - What is a spreadsheet? video.
Using Help Functions and Online References
Resourceful, adaptable, lifelong learners know where to look for information. There are several ways to find information about how to use your spreadsheet software. You can
use the built-in and online Help function
access online resources and demonstrations through the Internet
Browse Google Sheets’ Help menu from the main toolbar or try searching using a keyword to familiarize yourself with the features it has.
The Google Apps Learning Centre can be a wealth of information. Google has developed a variety of how-to resources to support the users. The website can be a place where you go to refresh your memory or to learn a new skill. Additionally, the Richardson Independent School District has prepared a variety of Google Sheets Tutorials that you can access at the link provided.
Basic Terminology
From this point on, you will be doing the bulk of your work in Google Sheets workbooks. Once you have opened the training room, you will see a number of worksheet tabs at the bottom.
A workbook is the Google Sheets file in which you enter and store related data. Each workbook can contain many worksheets, just as a book contains multiple pages.
A worksheet (also known as a spreadsheet) is a collection of cells on a single “sheet” where you actually keep and manipulate the data. They are accessed via tabs along the bottom of the workbook.
Instructions /7
For all assignments, it is CRUCIAL that you complete the steps in order:
Step 1: Open Intro to Sheets. Save your copy as Intro to Sheets - Firstname Lastname in your Practice folder.
/1 Step 2: Rename the Slave Lake worksheet Edmonton by right-clicking and selecting rename from the menu.
/1 Step 3: Delete the Three Hills worksheet.
Step 4: Insert a worksheet before Calgary.
/1 Step 5: Rename the worksheet you inserted in Step 5 with the name of your hometown. If your hometown is already a sheet, name it your hometown with 1 after the name, e.g., Calgary 1.
/1 Step 6: Put the worksheets (other than your hometown) in alphabetical order. Select the sheet name tab and drag it where you want it to go.
/1 Step 7: Make a copy of the Edmonton worksheet, and place it after the original Edmonton worksheet. By now, your tabs should look something like this, with Your Hometown tab being located based on its name:
/2 Step 8: In cell A1 of both the Calgary and Medicine Hat sheets, create a hyperlink to the next worksheet (worksheet to the right) using the word NEXT. Because Sheets is browser-based, you will need to:
In Calgary, Type “NEXT” into cell A1
Right click the text, and select the 'insert link'.
In the "Sheets in this Spreadsheet" dropdown, select the Edmonton sheet.
Test the link to ensure it works. It should look something like this:
In Medicine Hat, Type “NEXT” into cell A1
Select the hyperlink feature.
In the "Sheets in this Spreadsheet" dropdown, select the Red Deer sheet.
Step 9: Submit your Intro to Sheets on Google Classroom for assessment.
Page updated
Report abuse