Page 178 - IT 402 v2.0 class 10
P. 178
Renaming Worksheets
t the bottom of each worksheet window there are small abs that indicate the names of the worksheets
in the workbook. y default their names are Sheet Sheet Sheet and so on. hese names are not very
descriptive. enaming a worksheet as per its content gives a brief idea about the stored content. For instance
if sales of different months by a salesman are stored in different worksheets names of the sheets can be
renamed by month names.
To rename a worksheet:
Step 1: ouble-click on one of the existing worksheet names.
ename Sheet dialog box appears on the screen.
Step 2: ype the desired name of the worksheet
Step 3: lick on O button.
3
2
1
Renamed
Worksheet
CELL REFERENCE
hile doing calculations or summarising data in spreadsheet we often find ourselves in a situation to fetch
data from other worksheets or even from different workbooks. his can be done by creating ell eference.
In OpenO ce alc there are options to link different sheets and one can fetch data from different sheets
based on a common field.
cell reference refers to a cell or a range of cells on a worksheet that can be used to find the values or data.
he main benefit of using a cell reference is when the data present in referenced cell s in another worksheet
changes a value returned by the cell reference is automatically updated.
Cell Reference refers to:
Data from one or more contiguous cells on the worksheet
ata contained in different areas of a worksheet
ata on other worksheets in the same workbook
176 Touchpad Information Technology-X

