Page 233 - IT_Play_V1.0 Class9
P. 233

Examples of Basic Formulas
                                         Operator                 Formula           Result
                                         Addition (+)             = 15 + 7          22

                                         Subtraction (-)          = 30 - 12         18
                                         Multiplication (×)       = 8 × 7           56
                                         Division (/)             = 84 / 12         7
                                         Exponentiation (^)       = 3 ^ 4           81

                 Using Brackets in Formulas

                 Brackets can change the order of operations in an equation. The following examples show how brackets
                 affect the results:
                                        Formula                   Evaluation        Result
                                        = 6 + 8 × 2               = 6 + 16          22
                                        = (6 + 8) × 2             = 14 × 2          28
                                        = 7 * 3 ^ 2               = 7 × 9           63

                                        = (7 × 3) ^ 2             = 21 ^ 2          441
                                        = (12 / 3) ^ 2            = 4 ^ 2           16
                                        = 25 / (5 ^ 2)            = 25 / 25         1
                 Types of functions include Mathematical, Date and Time, Statistical, and Logical functions.


                                                                                                  21 st
                                                 Lab Assignment ‘n Activity                    Century   #Technology Literacy
                                                                                                 Skills

                    Complete the following and tick the circle.
                      Start LibreOffice Calc and enter the following data in the cells as given:
















                       Add another column after ‘Quantity’ and give the heading as ‘Price per Piece’ and
                      fill the required data in it.

                      Delete the content of 7th row.
                      Copy the whole content and paste it in ‘Sheet2’ of the spreadsheet.

                      Delete the 4th row of the given sheet.
                      Undo the previous work.
                      ‘Redo’ the action taken by the ‘Undo’ command.

                      Save the file and exit from ‘LibreOffice Calc'.




                                                                     Applying Formula and Functions in Spreadsheet  231
   228   229   230   231   232   233   234   235   236   237   238