Workbook: Calc document is called workbook. Each workbook  is collection of  worksheets.

Worksheet: The worksheet in Calc is also referred to as spreadsheet. Each sheet can have many individual cells arranged in rows and columns

Cell :The intersection of a row and column is called a cell. It is the basic element of a spreadsheet. It holds data, such as text, numbers, formulas and so on. 

cell address(cell reference) is denoted by its column (letter) and row number. For example, A1,A2 etc.

Range Reference (Cell Range) 

a range is a block of two or more cells. A range reference is represented by the address of the upper left cell and the lower right cell separated with a colon.

What is the use of multiple sheets in a workbook ?

•Multiple sheets help keep information organized.

•Different data can be stored in separate sheets for better organization.

•Suppose you want to store result of students in a workbook. You can create different sheets for different result such as PWT-1,PWT-2,PWT-3, UT-1,UT-2 etc.

•Whenever need  arises , these separate sheets can be linked together to fetch data in One sheet.

•By default a workbook comes with three sheets named sheet1,sheet2,sheet3. But you can add or delete worksheets from workbook.

How we can insert new sheet is a workbook ?

Click on sheet command from insert menu

Or

Right click and sheet tab and click on insert sheet

Or

Click on blank space near sheet tabs.

How can we delete  a worksheet?

Rclick on Sheet tab and click on delete sheet

 or

Click on delete sheet option from sheet menu

How can we rename a worksheet?

Rclick on Sheet tab and click on rename

 or

Double click on sheet tab which you want to rename.

It will display sheet rename box. Enter new name an click on ok

Referencing Other worksheet ( of another Workbook)

There are two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse.

Write the reference of  a cell named A14 of sheet named S2 in another sheet of same workbook ? [S2.A14 ]

To refer to cell K5 if sheet MyData in another worksheet namely Final’s cell B3, What would you write ? [MyData.K5 ]

A ___________ refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.                                [Cell reference]

At the bottom of each worksheet window is a small tab that indicates the ____________ of the worksheets in the workbook.  [Name]

Every workbook is a collection of  _____ .  [worksheet]

What are the two ways of referencing cells in other worksheets? 

[Using keyboard and Using Mouse ]

We can insert sheet in a workbook using  _____ menu.

  [Insert ]

What is Hyperlink ?

A link to another document or webpage.

Hyperlink is a link , clicking on which open the linked document. The linked document may be any other document such as spreadsheet , text document  , image file or a web site.

On the left hand side, select one of the four types of hyperlinks:

Internet: the hyperlink points to a web address or web page, normally starting with http://

Mail & News: the hyperlink opens an email message that is pre-addressed to a particular  email receiver.

Document: the hyperlink points to a place in either the current worksheet or another existing worksheet or other document ,text file or image file.

New document: the hyperlink creates a new worksheet or ppt or text file.

Absolute hyperlink

Absolute hyperlink is a hyperlink that contains the full address of the destination file or of the Web site. Mostly Absolute Hyperlinks are link to webpages or web contents.

Example

http://www.microsoft.com/support

http://www.google.com

D:\xii sc\notes\abc.doc

NOTE: An absolute link will stop working only if the target is moved.

Relative hyperlink

Relative hyperlink is a hyperlink that does not contains the full address of the destination file or of the Web site. It contain the path relative to the current active location.   Example:

..notes\book2.ods

…\notes\image.jpg

NOTE:

A relative link will stop working only if the start and target locations change relative to each other. For instance, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break

1.Open the worksheet and select the cell where you want to insert the external data

2. Choose View -> Data Sources.

3. The Data Source View Pane will open

4. Select the table from given database.

5. select Records  from table and click on Data to Text button.

It will add data in your sheet from the database.