Spreadsheets

In this post you will be informed about how Spreadsheets are used, what they look like and what we can do with them. You will also learn how you can insert an image and a chart and the basic vocabulary.

This post will also explain the difference between a formula and a function and how to use them. Spreadsheets are a reaaly good tool, and you can use them to work with numbers, prices, create reports, summarize information, calculate earnings, solve mathematical problems and many other tasks. It's so easy to use... let's start.

How to use Google Speadsheets:

First you go to Google Drive and click on "New". Different options will appear, then you must click on "Google sheets". Google will open a page containing your new Spreadsheet. And now, start writing all your data. Google drive wll automatically save it, so... don't worry!

Basic vocabulary:

In the cell you can write many things, like numbers, letters and words. If you insert a number it will be located on the right side of the cell and if you write a letter or a word it will be located on the left side of the cell. You can insert symbols with text too, they will appear on the right. You can also change the text font, size or colour.

How to insert a chart:

First you have to select the data you want to use. Secondly you click on "insert" and then on "chart". Then the chart menu will appear and you can choose which chart you want, but be careful! In order to insert some charts, you must pay. Finally you have to click on the blue bottom to insert the selected chart, and it will be there!

How to insert an image:

You can insert different types of images. You can upload one from your computer, take one with the camera in your computer, copy the link of an image, choose it from your albums or google drive or search for one in google. You just have to go to the spreadsheet and click on "insert". Next you select the image you want to insert and the image will appear in your Spreadsheet. You can make the image bigger or smaller.

Formula:
The formula is to do calculations easily. First you have to select the cell where you want to put the result of the calculation. Then you put "=" and click on the first cell you want to calculate. Then, if you want to add you put "+", if you want to subtract write "-", to divide "/" and to multiply "*". Then click on the next cell you want to calculate and finaly click on "enter".
It must look like this: =E4+E5

Function:
The function is another way to do calculations. First you select the cell where you want to put the result of the calculations, as in the formula. Then put "=" and then to add or subtract write SUM, to divide or multiply write PRODUCT. Then open parentheses and click on the first cell you want to calculate. Next, if you want to add you put ";" and to subtract ";-", if you want to multiply you put ";" and to divide ";/". Finally clik on the other cell you want to calculate and close the parentheses. If you click on "enter" the result will be there!