Page 20 - Touchpad_Plus_V3.2_Class 7
P. 20

2                     Formulas, Functions and
                                                         Charts in Calc












                                    Your Aim
                                    to learn about:

                                         Formula Basics                          Order of Operation
                                          Cell Referencing in Formulas and its Types      Functions
                                           Charts in Calc



                  In this chapter, you will learn how to create a basic formula in Calc. One of the Calc’s most
                  useful feature is that it allows users to create formulas in order to perform calculations on data.
                  Calc also contains built-in formulas called  functions that make it easy to perform common
                  calculations on data.


                      FORMULA BASICS
                  Formulas in LibreOffice Calc begin with an equal (=) sign. When the contents of a cell begin
                  with equal to sign, LibreOffice Calc understands that user has given a formula here. If you don’t

                  enter the equal sign, Calc will treat your entry as text and the calculation will fail. To show how
                  formulas work, we'll begin with a simple exercise by selecting blank cell A1.
                  Then type = 10 + 4, and press Enter key. As you press the Enter key, Calc performs the calculation
                  and produces the result as 14 in cell A1. Enter some more formula in other cells and see what
                  results are shown by Calc. For example:

                  1. =10 – 4            2. =10 * 4           3. =10/4              4. =10 ^ 4
                  The results will be 6, 40, 2.5 and 10000 respectively. Some formulas based on BEDMAS rule can
                  be entered as:

                  1. =(10 + 4) – (3 + 5) ^ 3                 2. =(16/8) * (5 ^ 2) – 7

                   Clickipedia



                    LibreOffice Calc follows BEDMAS rule for doing mathematical calculations, where B stands
                    for Brackets, E for Exponentiation, D for Division, M for Multiplication, A for Addition and
                    S for Subtraction.







               18       Plus (Ver. 3.2)-VII
   15   16   17   18   19   20   21   22   23   24   25