Page 179 - IT_V1.0_Class10
P. 179

To rename a sheet:
                 Step 1:  Double-click on any of the existing sheet tab. Rename Sheet dialog box appears on the screen.

                 Step 2:  Type the desired name of the sheet.

                 Step 3:  Click on OK button.





















                    2




                                                 3


                                                                                                               Renamed
                    1                                                                                            Sheet




                 Alternatively, Right-click on the sheet tab and select the Rename Sheet option from the drop-down menu.
                 OR Click on Sheet menu and then select Rename Sheet option.

                   CELL REFERENCE

                 Sometimes, we need to calculate or refer to different sheets of a spreadsheet or different spreadsheet for
                 any calculation, then instead of copying data of those sheets, LibreOffice Calc provides a feature to refer to
                 those sheets.

                 While doing calculations or summarising data in spreadsheet, it may be required to fetch data from other
                 sheets or even from different spreadsheets. This can be done by creating Cell Reference. In Calc there are
                 options to link different sheets and one can fetch data from different sheets or spreadsheets based on a
                 common field.

                 A cell reference refers to a cell or a range of cells in a sheet that can be used to find the values or data. The
                 main benefit of using a cell reference is when the data present in referenced cell(s) in another spreadsheet
                 changes, a value returned by the cell reference is automatically updated.
                 Cell Reference refers to:
                   Data from one or more contiguous cells on the sheet

                   Data contained in different areas of a sheet
                   Data on other sheets in the same spreadsheet




                                                                                         Linking Spreadsheet Data   177
   174   175   176   177   178   179   180   181   182   183   184