Page 318 - TP_IT_V1.0_C9_flipbpookl
P. 318

You will see that the formula is automatically copied to the rest of the cells with the cell address automatically adjusted
              accordingly as shown below.
















              Using Copy and Paste for Copying the Formula
              Following are the steps to copy a formula using the copy-paste command:
              Step 1:  Select the cell that contains the formula.
              Step 2:   Press the Ctrl + C keys to copy the contents of the selected cell.
              Step 3:  Select the cell to which the formula is to be pasted.
              Step 4:  Paste the contents in the selected cell.
              Step 5:  Press the Ctrl + V keys to paste the contents of the selected cell.



                                      Complete the following spreadsheet. Use fill handle, wherever possible to automate the
                       uiz Bee        date entry. F2 should be sum values from B2 to E2. Drag the fill handle to copy the formula
                                      till F6.
                                      G2 should be the average of values from B2 to E2. Copy this formula till G6 using the
                                      Auto Fill feature.


















                             Subject: To show formulas in LibreOffice Calc
                             Step 1:  Click on the View from the Menu bar.
                             Step 2:  Click on the Show Formula option. Now, the formula is visible in place of result.






                        FIND AND REPLACE

              In a spreadsheet, you can find text, formulas, and styles by using Find and Replace dialog box. To open Find and
              Replace dialog box, select the Find and Replace option from the Edit menu.
              Text or numbers in cells may have been entered directly or may be the result of a calculation. The search method
              depends on the type of data you are searching for. By default, Calc searches the current sheet. To search through all
              sheets of the spreadsheet, select the All sheets check box.


                316   Trackpad Information Technology (Ver. 1.0)-IX
   313   314   315   316   317   318   319   320   321   322   323