Page 213 - Trackpad 402_Class-X_Final
P. 213
Link to Registered Data Sources
Other registered data sources like databases can also be easily linked in OpenOffice calc. To register a database in
*.odb format the steps are as follows:
Step 1: Click on Tools menu and select Options. The Options dialog box opens.
Step 2: Double-click on OpenOffice Base and select Databases option.
Step 3: Click on New button to open the Create Database Link dialog box.
Step 4: Click on Browse to open a database file.
Step 5: Select the database file.
Step 6: Type a name to use as the Registered name for the database.
Step 7: Click on OK button. The database is added to the list of registered databases.
Step 8: Then click on OK button to use the database selected.
Tick ( ) if you know this.
Solver is a tool that helps you do backward calculation of the input to obtain the desired output.
A cell reference is the method used to refer to a cell or a range of cells in a worksheet.
Hyperlink means a content when clicked will open another linked file.
SHARING WORKSHEET DATA
A file is sometimes required to be accessed by multiple users at the same time for editing. For this purpose the file can
be placed in the network so that it can be shared by several users and can be accessed simultaneously.
The steps to make the spreadsheet shareable with the other users are as follows:
Step 1: Open the spreadsheet.
Step 2: Click on Tools menu and select Share Document option. The Share Document dialog box opens where you
switch on the sharing option by clicking on the check box Share this spreadsheet with other users.
Electronic Spreadsheet (Advanced) 213

