Page 170 - Computer - 10(A&B)

Use semicolon (;) if you want to take more cells for
referencing from different worksheets.
For example: = SUM (Jan.B3;Feb.B3)

Creating a Reference with the Keyboard

Typing the reference is simple once you know the format the reference takes. The reference has two parts to it:
v Sheet name
v Cell Address/Range Address

You can see the general format for the reference is = $SheetName.CellName.
You can type the cell reference in the formula. Let us take the same worksheets. Assuming that the cost is in the
same cell in the Price sheet, B2, the cell reference should be =B2*$Price.B2.

Referencing Other Workbooks

Calc can link different files together. The process is the same as described for different sheets in a single
spreadsheet, but we add one more parameter to indicate which file the sheet is in.

Creating the Reference between two Workbooks with the Mouse
To create a link between two workbooks:
Step 1: Open the two workbooks that you wish to link with each other, e.g., ‘Price’ and ‘Monthly’, at the same
time

Price Workbook Monthly Workbook

52