Page 267 - open office
P. 267

On the right side, the corresponding in-built function is displayed. E.g.:SUM ( umber1   umber2 ....)
                 Step 3:  Select the ‘Category’ as ‘Mathematical’ from the list box.

                 Step 4:  Select the  SUM  function.
                 Step 5:  Click on ‘Next’.

                 Step 6:  Fill the range of cells to be calculated in the given text box. (Here, range of cells is given as (B2:F2)).





                   3


                                                                                                                      6


                   4


                   5
                                                                                                                      7



                 Step 7:  Click on the  OK  button of the function wizard. The result will be displayed in the cell  2.

                    Sneak Peek



                          To use functions is MS Excel:
                          1.  Select the cell in which the output has to be displayed or function is to be inserted. Here,
                             cell G2 has been selected to enter the function.
                          2.  Click on the fx button on the Formula bar. ‘=’ sign will appear in the Formula bar. The Insert
                             Function dialog box will also appear on the screen.
                          3.  Click on the drop-down arrow of or select a category drop-down list.

                          4.  Click on Math & Trig option from the list.
                          5.  Search and click on the SUM function from the Select a function list.
                          6.  Click on the OK button. The Function Arguments dialog box will appear on the screen.
                           .  Enter the range of cells to be calculated in the  umber1 text box. Here, the range of cells is
                             given as B2:F2.
                           .  Click on the OK button. The result will be displayed in the cell  2.





                   COMMON ERRORS
                 Sometimes when we use wrong type of data, operand or operator in a formula, an error message is displayed.
                 Given below is the list of errors which commonly occurs in ‘Calc’.










                                                                                     Working with Spreadsheet       26
   262   263   264   265   266   267   268   269   270   271   272