Page 63 - TechPluse_C6_Flipbook
P. 63

5                     Formulas, Functions and
                                                          Charts in Calc












                           Your Aim

                           to learn about:

                                    Formula Basics                              Order of Operation
                                     Functions                                     Charts in Calc
                                       Sorting Data                                  Filtering Data
                                        Conditional Formatting                         Printing a Worksheet



                 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.






                                                                        Formulas, Functions and Charts in Calc       61
   58   59   60   61   62   63   64   65   66   67   68