Page 229 - IT_Play_V1.0 Class9
P. 229

Here, the output will be 100 that will be displayed in the cell A5 as soon as the ‘Enter’ key is pressed. Now, in
                 the next cell, i.e. A6, enter a new formula to find the average of cell values as ‘=A5/4’. Now, the output 25 will
                 be displayed in the cell (A6). (It can be seen here that in A6, the formula is applied with respect to the address
                 of the cell, i.e. A5). The significant factor of using a formula in a spreadsheet with cell addresses is that if a
                 value or entry of one cell is changed, then the values of all subsequent cells where the particular cell address
                 has been applied in the  formula are also recalculated. In the above example, if the entry in cell A1 is changed
                 from 5 to 25, then the cell A5 will change from 100 to 120 and the value of A6 will change i.e., from 25 to 30.

                 Formula with Cell Names

                 In LibreOffice Calc Formula can be applied with reference to cell names. For doing so, first define the name
                 of the cell or the range of cells.

                 For naming a cell, click on the cell and type the name for that cell in the address to replace the cell address
                 (co-ordinates) with the name and press the 'Enter' key. Name can be used directly in a formula.
                 For example: Consider a spreadsheet that has the following details:








                 In the address bar, assign the cell A1 as Name of Sales Person, B1 as Sale in 2015, C1 as Sale in 2016, D1 as
                 Sale in 2017 and E1 as Total Sales. Enter the values in the cells A2, B2, C2 and D2 as Kumar Narayan, 80000,
                 80000, 99000 respectively.

                 Now, enter a formula in cell E2, =B2+C2+D2. After pressing the 'Enter' key, the output will be shown as
                 259000 in cell E2.
                   EDITING CONTENTS IN A SPREADSHEET

                 After creating a spreadsheet, the user may require to edit the contents or data of a cell or a range of cells.
                 Editing refers to:
                   Modifying the contents                                     Inserting/Deleting the contents

                   Copying/Moving the contents                                Cancelling or repeating the recent actions
                 Modifying the Cell Content


                 Cell content can be modified by either replacing or deleting it.
                 To replace the cell content:

                    Select the cell whose contents have to be modified. Type the new content and press the Enter key. The old
                   data gets replaced with the new one.
                 To delete the cell content:

                   Select the cell or the range of cells and press the Delete key.
                 Inserting Cells

                 To insert cells, follow the given steps:

                 Step 1:  Select the cell or range of cells to be inserted.
                 Step 2:  Click on the Sheet menu from Menu bar.



                                                                     Applying Formula and Functions in Spreadsheet  227
   224   225   226   227   228   229   230   231   232   233   234