Spreadsheets (The post Challenge)

In this post, we are going to talk about:

What is a spreadsheet? Simple, it is a panel of rows and columns which responds to certain patterns. This make your calculates much faster, but especially much easier. That's way, we learned this week to handle this program. They are two programs with the same utility, you can choose between Google Spreadsheets and Microsoft Excel. No matter what you prefer, the two programs have two basic tools, Formulas and Functions, and that is what is this post about. Both are similar, but also different. Also I will show you some other Tools, like how to make graphics and many others.

First we start with the easy ones:

Now, the complicated:

Formulas: They are used to do fast and simple calculations, like Value 1 + Value 2. How do you do that? First, you choose the cell in there you want the result (F4). Then you start with a =. Next step is choosing the cell with value 1(B13). Step 3 is putting the calculation you want to do: +, -, /, *. I choose +. Finally you click on the cell with value 2(G15). You got it! Example: B13 + G15 = F4.

Functions: They are used to make complicated calculations or other more specifically things. The common functions are: MAX(the biggest value), MIN(the smallest value), AVERAGE, SUM(plus), PRODUCT(multiplication).

For the functions, you start with a =. Then you put the functions and in brackets the range of the cells you want to calculate. Easy!