Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 60 - 2505_CoreGPT(Podar)_Flipbook_C6
P. 60

    Formula

                      A  formula  is  an  expression  that  helps  to  perform  arithmetical  calculation  and  also  executes
                      non-arithmetical  tasks.  It  consists  of  the  operands  and  operators  that  operate  on  the  data.
                      Formula has to be expressed with prefix ‘=’ before the operator/data.

                            ENTERING AND EDITING DATA

                      The data in the form of numbers or text can be entered by just clicking on a cell and typing with
                      the help of a keyboard. You can type data directly into the cell or you can enter data using the

                      Formula bar. Follow the below steps to enter data into a worksheet:
                      Step 1   Click on the cell where you want to enter the data.

                      Step 2   Type the text or numbers to input the data.
                      Step 3   Repeat Steps 1 and 2 until you finish entering all your data.

                                   Entering data in a worksheet                              Worksheet

                            CALCULATING IN CALC

                      In Calc, you can carry out various mathematical operations like addition, subtraction, multiplication
                      and calculating averages using formulas and functions. A formula is an equation designed to
                      perform calculations, while functions are predefined formulas that help you carry out standard
                      mathematical operations on values.

                      The following are some examples of using formulas:
                       S. No    Calculation                      Type in a cell    Press         Output

                       1.       To add 58 and 32                 = 36 + 51         Enter Key     87

                                To  add  the  contents  of  two
                                                                                                 The sum of the contents
                       2.       cells using the cell addresses,  = A2 + B4         Enter Key
                                                                                                 of cells A2 and B4
                                for example, A2 and B4

                       3.       To subtract 20 from 100          = 100 - 20        Enter Key     80

                       4.       To multiply 15 by 4              = 15* 4           Enter Key     60

                     58     Premium Edition-VI

| 55 56 57 58 59 60 61 62 63 64 65 |