Google Sheet Top Functions and explanation how to use those!Google documents and spreadsheets launched in 2006, offer a fantastic way of creating spreadsheets and documents. These can be used for collaboration between various people.
Since their launch Google spreadsheets have come a long way and the application now offers a list of functions and formulas to allow you data analysis.
In this post i will show you how to use some of the Google spreadsheet functions. These functions are very similar to Excel functions and formulas. If you are familiar with functions and formulas in Excel then the transition to Google spreadsheets should be painless.
How to apply Functions into Google Spreadsheets
There are five functions available from the “Insert”, “Function” list. 1.SUM function,
4.MAX function and
5. MIN function.
To use SUM function, click on your target cell, then click “Insert”, “Function” and select the SUM function from the drop down menu. The Google sheet application provides a description of how each function works and how to set the parameters for each function which you can do manually:
Now adding sales in 2nd of March and then creates a SUM for the sales on the 2nd of March, now the spreadsheet will look like this one:
AVERAGE function in Google Spreadsheets
AVERAGE function in Google Spreadsheets is calculating the average value of a range or a selected row or column.
For calculating the AVERAGE sales per day using example spreadsheet, you can type the following code into the target cell:
Result will looks like this:
MAX function in Google Spreadsheets
The MAX function allows you to quickly find the largest value in a given set of cells or row/column. For this type the followingcode in Fx bar
The result spreadsheet should look like this:
MIN function in Google SpreadsheetsIt's similar to above rule but code is different, try the code below
The result will look like this: