Page 232 - IT_Play_V1.0 Class9
P. 232

2


                 3
                                                                                   4

                 1








              Deleting Rows and Columns

              To delete rows and columns in a sheet, follow the given steps:
              Step 1:  Select the row/column to be deleted.

              Step 2:  Click on Sheet menu from Menu bar.
              Step 3:  Select Delete Rows or Delete Columns from the drop-down menu.

              Undo and  Redo

              While working in the sheet, the 'Undo' command helps the user reverse a series of actions, and the 'Redo'
              command helps reverse the actions undone by the 'Undo' command.
              ‘Undo’ can be done by:
                Clicking on the Undo option from the Edit menu from Menu bar. OR Clicking on the Undo button from
                 the Standard toolbar. OR Pressing Ctrl+Z.

              ‘Redo’ can be done by:
                Clicking on the Redo option from the Edit menu from Menu bar. OR Clicking on the Redo button from the
                 Standard toolbar. OR Pressing Ctrl+Y.

                MATHEMATICAL OPERATOR
              Mathematical operator is a symbol that performs certain mathematical or logical operations. In a cell, the
              calculation takes place in the order of precedence of operators. The table given below shows the operators,
              their meaning:

              The table given below shows the order of precedence of operators:
                               Mathematical Operators
                           +   addition                                        Operator precedence
                           -   subtraction                                First               ( )

                           ×   multiplication                             Second              ^
                           /   division                                   Third               /, ×
                           ^   exponentiation  (power)                    Fourth              + , -

              When two operators share the same ranking or precedence, calculation is done in the order from left to right.

              Simple Calculations using Values and Operators

              Table below illustrates how different mathematical operators can be used in formulas. You can include multiple
              operators in a single formula, and the order of operations determines how these are evaluated.



                230     Information Technology Play (Ver 1.0)-IX
   227   228   229   230   231   232   233   234   235   236   237