Page 183 - IT 402 v2.0 class 10
P. 183

Switch back to the old
                                                                            worksheet. In the input
                                                                            line, it can be observed
                                                                           that OpenO ce Calc has
                                                                           added the reference to the
                                                                                  formula.



























            Step 2:   he reference to a cell of another workbook contains:

                       Name of the other workbook in single inverted commas   ..   followed by     and    .

                       Name of the sheet of the other workbook followed by a dot  .
                       Name of the cell

            Step 3:   onfirm the formula by clicking the   ccept  button in the formula bar.











                   Referenced
                      Cell























                                                                       Advanced Features of Spreadsheet        181
   178   179   180   181   182   183   184   185   186   187   188