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
   301   302   303   304   305   306   307   308   309   310   311