Sunday, June 4, 2017

Spreadsheets Mayer & Ranftl


This post is about learning how to use google spreadsheets /microsoft excel. This is what is all about, learning how to write functions and formulas, we are also showing you what are the differences between them . Google Spreadsheets and Microsoft Excel are very similar because they have almost the same functions and Tools, but first things first you can get google Spreadsheets for Free you just have to create an Gmail account, go to google drive and choose the kind of document you want to create. To download Microsoft Excel you must have Windows (if you have a Mac you can’t download it, so you will have to use google spreadsheets). It is not included in every Microsoft package, it comes only in the office version. (it includes: Word, Powerpoint and Excel).   
Formulas:
They are usable for adding, subtracting, dividing or multiplying two different cells. The best thing about them is that if you change the number that’s in the cell, it will change in the cell were you wrote the formula. Formulas work like this: in the cell where you want to have the result you have to put an equal sign (=), then write the cells you want to add or subtract, etc. and  finally, when you did this, you click enter and the result will appear. Example:

=C4+D4

Functions:
They are the best option to make calculations faster. You give like an order to it, because sometimes you will use SUM, AVG, MIN, MAX, etc. It’s like in the formulas, the result changes when you change something in one of the cells. To use a function you have to:
First put an equal sign (=), then choose what you want to do, like Add (SUM), Maximal (MAX), etc. After that select the cell range you want to work with. Finally click enter and the result will appear. Example:

=SUM(C4:E9)


No comments:

Post a Comment