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