You can also use spreadsheets to create calculations and display or extract data in certain ways using functions.
Creating Spreadsheet Formulas - click on the Formula Bar and type the formula. Begin the line with an equal sign (=). Formulas use a variety of mathematical operators and worksheet functions to work with values or text. As such they consist of:
Inserting and reusing functions - like with formulas, functions are inserted into the Formula Bar and they begin with an equal sign (=). This is followed by the name of the function and parentheses. Inside the parenthesis is a list of arguments. Functions vary in how they use arguments and depending on what it needs to do, there are:
There are a variety of built-in functions to choose from. Just by typing any letter after = in the Formula Bar, you will see a list of functions to choose from starting with that letter. Another way of inserting functions is to click fx next to the Formula Bar. You can also go to the Formulas Tab and select Insert Function. This will open a window where you can search for functions by categories or even describe what it is supposed to do to find it.
After selecting the desired function, click OK. This will open another window where you will be required to enter the values that will be operated on by the function. Once the values are entered, click OK.
You can see the SUM function being applied above.