Spreadsheets

If you want to calculate the average of your students, your earnings or many other things of an easy way and without having to do the accounts mentally, then I have a solution: use Spreadsheets. It is really easy. Reading this post you can learn some vocabulary from spreadsheets, the differences between a formula and a function,  how to use them and two examples to understand them better, and obviously the basics of how to use google spreadsheets. In this last topic you will learn how to create a chart and how to insert an image, between other things.  Let’s start!

Vocabulary:

The basics

The first step to create a spreadsheet is to open your google drive. Then click on new. Next click on google sheets. After this, google will open a second tap, which will be your Spreadsheet. Now you just have to chose a cell and you can start inserting data. When you are ready, google drive will automatically save all you’ve done, so you don’t have to worry by clicking save.   

How to create a chart

The first thing you have to do is select the data you want to insert in your chart. Afters click on insert and then click on chart. Many types of styles will appear, choose one. Press on customize, to choose the title of your chart, the colour and other things. At last click on insert, for your chart to appear on your spreadsheet.  

How to insert an image

The first thing you have to do is click on insert. Then click on image. Six options will appear, which are upload (your own image), take a snapshot, use a URL, google albums, google drive and search, select one of those and insert your image, that will appear automatically in your spreadsheet.   

Formulas

A Formula is used to perform calculations. Once the formula is entered, you only need to change the amounts to be calculated. You don’t have to keep entering “plus this" or “minus that” like you do with a regular calculator.

The first thing you have to enter is the equal sign (=). Then you click on the first cell you need for the calculation. After that you have to insert a sign, taking in mind what you want to calculate. If you want to subtract you click on the minus sign (-), if you want to add, you click on the plus sign (+), if you want to divide, you click on the forward slash (/), and if you want to multiply you click on the asterisk (*). The next step is to select the other cell you need for the calculation. At last, you click enter, and you’re ready!

Example: =B2+B3

Functions:

A function is a programmed formula that carries out specific calculations in the cell in which it is located. You start with an equal sign. The following thing you have to do, is insert the function you need. Next you open brackets. Then, you click on the first cell you want to add. After that put a column in the middle, with the ; sign, if you want only 2 cells or the : sign for a range. Then click on the last cell you want to add. Last but not least close the brackets. At last click enter.

Example: =MIN(B4:C6)