Embedded Files
Sheets is Google's cloud based spreadsheet application . It is part of the GSuite.
Sheets is Google's cloud based spreadsheet application . It is part of the GSuite.
What is Google Sheets?
What is Google Sheets?
Google Sheets is a cloud based spreadsheet app from Google.
Google Sheetis is an online spreadsheet, (similar to Microsoft Excel) and because it is cloud based, more than one person can edit, comment and collaborate on the same spreadsheet at the same time!
What can I do with Google Sheets?
Google Sheets are great for files using numbers, data, graphs and charts. Some examples include budget and financial reports, class lists, mark books or test results. They can also be used for documents which require lots of boxes, like calendars.
Working with Sheets
Working with Sheets
Spreadsheet Basics
Spreadsheet Basics
Spreadsheets are made up of cells, arranged into rows and columns. Each column is named with a letter (e.g. A), and each row is named with a number (e.g. 7).
This means that each cell has a unique reference or address (e.g. A7).
Tip You can drag, copy and fill the contents of cells by clicking on the small blue square in the bottom right corner of the cell and dragging to new cells.
Formulas
Formulas
Formulas are short procedures that allow us to link the content of cells together and complete calculations. Formulas must always start with an = sign.
A simple formula is shown here: =A1+B1
After writing the formula, the spreadsheet will perform the calculation and the answer will appear in cell C1. If the values in cell A1 or B1 are updated, the answer wil automatically update.
Common Formulas
Common Formulas
When you first type an = the sheet will suggest possible formulas which may be used. The most common formula is probably =sum.
You will notice that formula has to be written in a certain way...
=sum(A1:D1)
Some other useful formulas include...
=mode(A1:D1)
=median(A1:D1)
=average(A1:D1)
=max(A1:D1)
=min(A1:D1)
More Complicated Formulas
More Complicated Formulas
Some other formulas, which may be useful for teachers...
=countif(A1:A4,“pass”)
This formula will count if the word "pass" is present. This formula can be useful for quickly adding the number of responses in a survey, or words in a spelling test.
=concatenate(A1, " ", B1)
The concatenate formula is useful for joining two sets of data together. This is an easy way to merge first and last names into one cell.
To perform the opposite of concatenate (splitting a name into two columns) you don't need to use a formula, simply click on Data > Split text into columns.
You can learn more about the formulas in Google Sheets here.
Working with Data
Working with Data
Sorting Data
Sorting Data
Clicking the arrow at the top of a column will allow you to sort the data on your spreadsheet quickly and easily.
For more control, or to sort a particular column or range, go to Data on the menu bar.
Creating Graphs & Charts
Creating Graphs & Charts
Highlight your data and then click Insert > Chart
This will bring up the chart editor. From here you can choose and edit the graphs/charts of your data.
Any changes you make to the data will be automatically reflected in the charts.
See the Google Sheets Cheat Sheet from Google at https://support.google.com/a/users/answer/9300022
CreditsHeader image created by makyzz - www.freepik.com and used under licence. Icons used under licence from nounproject.com. Images used under licence from Freepik.com. Screenshots ©2018 Google LLC, used with permission. Google and the Google logo are registered trademarks of Google LLC.
Page updated
Google Sites
Report abuse