Page 272 - Trackpad IT-402_Class-IX
P. 272

Step 3:  Press the ENTER key on the keyboard or click on another cell using the mouse.

































                TYPES OF DATA

        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. 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.
        •  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.

        Mathematical Operators Used in a Formula

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

                      Mathematical Operators                        Example                     Result
               +       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:






          272   Trackpad Information Technology-IX
   267   268   269   270   271   272   273   274   275   276   277