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

