Spreadsheets

In this post you will be informed about spreadsheets, and how to create a chart and insert an image in there. You will also learn about the “basic vocabulary”, about formulas and functions, the difference between them and how to use them. Spreadsheets are normally used to analyze and organize numbers, financial data, and other information. For example: solving a mathematical problem, calculating your earnings, or others things. They are frequently used in the fields of business and accounting. Now that these concepts are clear, let´s begin.  

The basics:

To create a Google Spreadsheet, the first step is open Google Drive and then click on the blue button: “New”. Now, different options would appear, and you must click on Google sheets. Automatically Google opens a new website and this would be your spreadsheet. It is advisable that you put a titel for your spreadsheets. Now you can start writing data in your document. When you write something Google Drive automatically saves it, so don't worry!

Basic vocabulary:

You can insert many things in a cell, like numbers (appear on the left), and words (appear on the right). You can also change the color, the size of the text, the font, and other things.

How to create a chart:

Firstly you need to select the data, that you are going to use. Then you click on insert and then on chart. Next it would appear the chart menu, where you can choose the style that you want to use, and also you can customise your chart as you like. Finally you click on the blue insert button and if you want, you can move it and put it where you want or you can select the size that you prefer.

How to insert an image:

First you click on the “insert” button, that is located on the toolbar and then you click on image. Now it would we appear six differents options: Upload, Take a snapshot, By URL, Your albums, Google Drive and Search. When you already chose your option you click on insert and then you can select the size from the image or the place in which you will put it.

Formulas:

We use a formulas to perform calculations. The first step is to enter the equal sign (=). Then you click on the first cell you need for the calculation. Then insert the sign, taking in mind what you want to calculate. If you want to subtract, you must 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 (/=Shift+7). If you want to multiply you click on the asterisk (*=Shift++). Finally you select the other cell that you need for the calculation and you click on the enter button.

Functions:

A function is a programmed formula that carries out specific calculations in the cell in which it is located. The first step is enter the equal sign (=). Then you have to insert the function you need. Next you open brackets (), and then you select the first cell. Next you put the ; sign, if you want only two cells, and : sign if you want a range. Next you close brackets, and after that you click enter.

Nadine Wunderlich and Maria Ramirez Calvo.