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 mathematical problem, calculating your earnings, or other things. They are frequently used in the fields of business and accounting. Now that these concepts are crear, let´s start!
How to create a Google Spreadsheet:
To create a Google Spreadsheet, first of all you must 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 tab and this would be your spreadsheet. It is recommendable 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":
In a cell you can insert many things, like numbers (appear on the left side from the cell) and text (appear on the right side). Also you can insert text with numbers (appear on the left side)or symbols with numbers (appaer on the right side). You can change the color, the size or the font from your text.
How to create a chart:
First of all 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.
In a cell you can insert many things, like numbers (appear on the left side from the cell) and text (appear on the right side). Also you can insert text with numbers (appear on the left side)or symbols with numbers (appaer on the right side). You can change the color, the size or the font from your text.
How to create a chart:
First of all 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 of all you click on the “insert” button, that is on the toolbar located and then 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 choose your image you click on insert and then you can select the size from the image or the place in which you will put it.
First of all you click on the “insert” button, that is on the toolbar located and then 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 choose your image 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.
Example: =B5+B6
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.
Example: =B5+B6
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 an equal sign (=). Then you have to insert the function you need and you open brackets. Next you selct the first cell and you put the ; sign, if you want only two cells you use the : sign if you want a range. After that you insert the last cell that you need for the calculation and you close brackets. Finally you click on the “enter” button.
Example: =sum(A2:A3)
A Function is a programmed formula that carries out specific calculations in the cell in which it is located. The first step is enter an equal sign (=). Then you have to insert the function you need and you open brackets. Next you selct the first cell and you put the ; sign, if you want only two cells you use the : sign if you want a range. After that you insert the last cell that you need for the calculation and you close brackets. Finally you click on the “enter” button.
Example: =sum(A2:A3)
No comments:
Post a Comment