Page 304 - TP_IT_V1.0_C9_flipbpookl
P. 304

The data entered in a cell can be:
              •  Label/Text: Any set of characters like letters, numbers, or special characters that can be entered in a cell is called a
                label. Labels in a cell are always left-aligned by default.
              •  Value/Number: The numbers like salary, marks, etc. that can be entered in a cell are called value. It can be in
                decimals also. Values in a cell are always right-aligned. If you enter a number preceded by zero, then it is ignored and
                only the number will be displayed. To show the preceding ‘0’, the data type has to be specified as ‘Text’.
              •  Formula: An expression that begins with an “=” sign is called a formula in a spreadsheet. It can have a value, cell
                address, or function. The equal sign indicates that the following part after the equal sign is a formula and not just
                a name or number. A formula can be directly entered in a cell or by typing it in an Input line of the formula bar. An
                expression without an equals “=” sign is treated as text and no calculations will be done. For example, A1+B1+10 will
                not give any answer because it is not preceded by an “=” sign. The advantage of using a formula is that if a number
                in a cell used as a cell reference in a formula changes then the result is automatically updated.




                       uiz Bee        If A1 has value 10 and B1 has Value 20 then write the given formula in cell C1 as =A1+B1.
                                      The Answer displayed in cell C1 will be 30. Now go to cell A1 and change the value 10 to
                                      20. What will happen to the value in Cell C1?





                      MATHEMATICAL OPERATORS USED IN A FORMULA

              The mathematical operators that can be used in a formula for calculations in a spreadsheet are:


                     +       Addition                                      =10+2                       12
                     -       Subtraction                                   =10-2                        8
                     *       Multiplication                                =10*2                       20

                     /       Division                                      =10/2                        5
                     ^       Exponential (Power)                           =10^2                       100

              When multiple operators are used in an expression, the operators are evaluated in the order of precedence as given
              below:

                                            Order of precedence             Operator
                                                    1                          ()

                                                    2                          ^
                                                    3                          / *

                                                    4                          + –
              In the above order of precedence, / and * are in the same order. Similarly, + and - are in the same order. In an
              expression, if the operators of the same order are present, then the order of evaluation of the expression will be from
              left to right. Let's see some examples given below:

                                    Formula                   Evaluation                   Result
                                                           =5–4/2
                           =2+3-4/2                                                          3
                                                           =5–2




                302   Trackpad Information Technology (Ver. 1.0)-IX
   299   300   301   302   303   304   305   306   307   308   309