Page 286 - Computer - 9(A&B)
P. 286

When the wizard fi nishes, the chart is inserted inside the spreadsheet as an object.





























                                                          A chart is a dynamic object which means
                                                          it is updated whenever the source data is
                                                          modified or changed.






              Let
              Let us Recallus Recall
              •   LibreOffi ce Calc is the spreadsheet component of LibreOffi ce suite, which is one of the most widely used application software
                  for data analysis.
              •   The basic components of spreadsheet program are workbook, worksheet, row, columns, cell address and cell pointer.
              •   Three types of data can be entered in a Calc worksheet namely Text, Number and Formula.
              •   A formula in Calc is an expression made up of data values or the cell references of the cells containing data values along with
                  the mathematical operations.
              •   There are two types of formulas- Simple and Compound formulas.
              •   A cell reference combines the column letter and row number, such as A1 or F345.

              •   When you use cell references in a formula instead of the cell value, you can change the value without changing the formula.
              •   Functions are the predefi ned formulas used to perform complex calculations and analysis.


               148
               148
   281   282   283   284   285   286   287   288   289   290   291