Sheets

 

Google Sheets

What it is:  A program that helps you create spreadsheets 

Benefits:  Create spreadsheet files, Organize data into rows or columns,

 Do arithmetic functions

Google Sheets is an online spreadsheet app that lets users create

 and format spreadsheets and simultaneously work with other people. 

ata

Spreadsheet Basics

Cells

A cell is an individual box on a spreadsheet. Cells are meant to hold one type of 

data, such as a number, or some text. If you open up a spreadsheet, you'll see what 

looks like an elongated grid. An individual cell is named by the row and column it's 

on, such as "1A" for the top left cell.

 

Rows

Rows on spreadsheets are labeled (1, 2, 3, ...) and consist of one cell on the left of 

the spreadsheet, and all cells in line with that cell vertically going off to the right.

 

Columns

Columns are the vertical parts of a spreadsheet and consist of one cell at the top, 

and all the cells below it. These are labeled ("A, B, C, ...).

 

 

Math

 

Use Google sheets to do math 

performed on a set of data, doing math in a Google spreadsheet is very easy if you

 know the right symbols to use

 

Addition

When it return it calculates results

Subtraction

Multiplication

Division

 

 

On upper right hand side you can use the SUM, AVERAGE, COUNT, MAX, MIN 

on range of cells

 

 

 

 

SHEETS

• Share a sheet 

• Math functions

• Charts

• Using rows and columns to organize

• Decimals 

• Percent

• currency($)

• Sorting

• Selecting

Data

Data can be thought of as collections of facts. They may be numbers, names, 

locations, or other items.

As an example, we can think of a person. Some data for that person may be:

 

• First Name: Ronald

• Last Name: Reagan

Data with a key:value structure like above - as in Key:"First Name", 

value:"Ronald" - can be easily stored in a table to see more data in line with it:

 

First Name | Last Name

-------------------|--------------------

Ronald         | Reagan

As you can see, it's a bit cumbersome to type out a table as seen here. So, we can 

instead turn to Google Sheets.

Google Sheets

How to get to Google Sheets

• Click on the icon for an internet browser 

• (Internet Explorer, Google Chrome, Safari, Firefox)

• Type sheets.google.com in the internet browser search bar and press enter

• Sign in to google or create an account. For help with this see the accounts 

page or your instructor.

Spreadsheet Basics

• Formula

• Least