Page 204 - Trackpad 402_Class-X_Final
P. 204
OR
Right-click on the Sheet tab and select Rename Sheet option.
By using either of the above step will open the rename dialog box as shown below:
Step 2: Delete the old name shaded in blue and type a new name of your choice.
Step 3: Click on OK button.
CELL REFERENCE
Cell reference is a very important feature of any spreadsheet program. A cell reference is the method used to refer to
a cell or a range of cells in a worksheet. A cell is made up of a column name followed by a row number Cell reference
of a single cell is Column name followed by the row number. For example, F10 means F column and row 10.
Cell reference of a range of cells is starting cell address and ending cell address separated by colon(:) in between. For
example, C10:C20, A1:B6 and C5:D10.
The main advantage of using cell reference is that it can be used in formulas and functions. This helps you update
the result of a function or a formula automatically if the value in a particular cell used in a formula changes. Also if a
function or a formula is either copied or moved then the cell address in the formula/function is automatically updated
with respect to the location it is copied or moved.
The cell reference used in the formula or function can be taken:
• From different location in the same sheet. For example: D10, A1:C5
• From a different sheet but the same workbook: The reference has the sheet name(Sheet1) and the cell reference
(A3) separated by dot(.) operator in between. For example:Sheet1.A3, Sheet2.C5:D8
• From a different workbook.
Adding a Cell Reference Using a Mouse
A cell reference of some other worksheet can be added easily using a mouse by following the given steps:
Step 1: Let us create a workbook with the name- ”POCKET MONEY.ods”. It has five sheets named as - JAN, FEB, MAR,
APR, FIRST QUARTER SUMMARY with the following details:
Sheet: JAN
204 Trackpad Information Technology-X

