Page 237 - IT_Play_V1.0 Class9
P. 237

Step 8:  Press and hold the mouse button to select the range of cells.
                 Step 9:  Click on Shrink button again to insert the range selected.









                                                           7





                                                                                                                    9





                 Step 10: Click on the OK button of the Function Wizard. The result will be displayed in the cell G2.


























                                                                                           10



                   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 LibreOffice Calc.

                     Errors                                             Reasons
                                 Occurs when the cell contains a number, date or time that is wider than the Cell width or
                   ###
                                 when the cell contains a date and/or time formula that produces a negative result.
                   #VALUE!       Occurs when a wrong type of argument or operand is used.
                   #NAME?        Occurs when LibreOffice Calc does not recognise text in a formula.
                   #NUM!         Occurs when there is a problem with a number in a formula or function.

                   #REF!         Occurs when a cell reference is not valid.
                   #DIV/0!       Occurs when a value is divided by zero.





                                                                     Applying Formula and Functions in Spreadsheet  235
   232   233   234   235   236   237   238   239   240   241   242