Page 244 - TP_IT_V1.0_C10_flipbpookl
P. 244
Cell References
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 within a spreadsheet. Cell references consist of a column letter followed by a row number (e.g.,
A1, B2, C3, etc.). 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.
In LibreOffice Calc, you can use cell references to refer to data in various ways:
• Contiguous cells on the same sheet
• Non-contiguous cells on the same sheet
• Data on other sheets in the same spreadsheet
• Data on sheets of the other spreadsheet
Adding a Cell Reference within a Spreadsheet
You can add a cell reference between sheets within a spreadsheet by referencing the sheet name and the cell reference
separated by dot(.) operator in between. For example, if you want to reference cell A1 in Sheet2 from Sheet1, you
would enter “=$Sheet2.A1” in the desired cell of Sheet1, then press Enter to display the value from cell A1 of Sheet2.
Using a Mouse
You can add cell reference between sheets within a spreadsheet using mouse by performing the following steps:
Step 1: Create a spreadsheet with the name Sales with the four sheets named as - Jan, Feb, Mar, and Quarterly Sales
having the following details:
Sheet: Jan Sheet: Feb
Sheet: Mar Sheet: Quarterly Sales
In Quarterly Sales sheet, we need to add the total sales of a product in a quarter by adding the total sales of a product
in the month of January, February, and March.
Step 2: Click on cell B3 and place an “=” sign in Quarterly Sales sheet.
Step 3: Click on the Jan sheet in the Sheet tab and click on cell B3.
Step 4: Again, click on the Quarterly Sales sheet in the Sheet tab. You will see the cell reference as shown below.
Step 5: Type the + sign.
242 Trackpad Information Technology (Ver. 1.0)-X

