Page 306 - TP_IT_V1.0_C9_flipbpookl
P. 306
Case 3:
Now, change the formula in cell A3 as =A1+A2
What changes do you see in cell A3?
Ans: The result is updated with new value 17
Case 4:
Now, change the value in cell A1 to 5, A2 to 20.
Cell A3 has formula=A1+A2
What changes do you see in cell A3?
Ans: The result is updated with new value 25.
Notice that, the results obtained from a formula (based on cell addresses) always get updated automatically when the
values of these cells mentioned in the formula change.
INSERT A COLUMN OR A ROW
In LibreOffice Calc, inserting columns or rows is crucial for maintaining data clarity and flexibility. For example,
suppose a sales report where you track monthly sales figures for various products. If you realise you need to add
a new product category or additional months of data, inserting columns or rows allows you to seamlessly expand
your spreadsheet. This not only keeps your data organised but also ensures that calculations and analyses remain
accurate and up-to-date.
For Columns
The steps to insert columns in a sheet are as follows:
Click on the Sheet → Insert Columns → Columns Before or Columns After option from the Menu bar.
OR
Step 1: Right-click on the selected cell.
Step 2: Click on the Insert option from the context menu.
The Insert Cells dialog box will appear.
Step 3: Click on the Entire column radio button to insert a column in a sheet.
Step 4: Click on the OK button.
A new column gets inserted to the left of the selected cell.
304 Trackpad Information Technology (Ver. 1.0)-IX

