Page 270 - open office
P. 270
B. Fill in the blanks.
1. ................................. is a feature in Calc by which the cursor can be placed anywhere in a sheet directly.
2. ................................. produces the positive value of a given integer.
3. In a cell, the calculation takes place in the order of precedence of operators in a similar way as .................................
in mathematics.
4. ‘Redo’ can be applied by ................................. shortcut.
5. To hide worksheet(s), select the option ................................. from the ‘Format’ menu.
6. If A1:A5 contain the numbers 16, 1 , 3, 25 and 6, then Average(A1:A5 6 ) will
display ................................. . CBSE Handbook
Ans. 1. avigation 2. ABS( ) 3. BODMAS 4. Ctrl 5. Sheet 6. 2
Section B
(Subjective Type Questions)
A. Answer the following questions:
1. Define Worksheet.
Ans. The worksheet in Calc is also referred to as spreadsheet which is the working area. The spreadsheet consists
of many sheets. Each sheet has cells arranged in rows and columns. The sheet tab shows its default name as
Sheet1, Sheet2, Sheet3 and we can insert more sheets.
2. If cell a1 contains 1 and cell b1 contains 5 , the formula is given in c1 as a1 b1.
i. The cell c1 does not show 6 as answer instead displays a1 b1.What could be the reason
ii. Can we give the formula in any other way
Ans. i. The cell c1 should contain a formula starting with sign.
In cell C1 enter a1 b1
ii. We can enter in C1 cell sum(a1:b1)
3. Give the steps to insert a column in a worksheet.
Ans. Step 1: Click on the left/right side of the existing column to which a new column has to be inserted on the
respective sides.
Step 2: Select the option ‘Columns’ from the ‘Insert’ menu.
4. What is an active cell How to delete the contents of an active cell CBSE Handbook
Ans. The selected or activated cell is referred to as an active cell that is always highlighted with a thick border. The
address of the active cell is displayed in the name box.
To delete the content of an active cell, select the cell and right-click and choose delete cell.
5. Differentiate between the following:
i. Workbook and Worksheet ii. Undo and Redo
Ans. i A workbook consists of worksheets. Worksheet is the working area or page on the screen. A worksheet
consists of rows and columns. (A workbook is like a book and worksheet is like the page of a book). By
default, a workbook opens with three worksheets, namely Sheet1, Sheet2 and Sheet3. The user can change
the name of the sheets and may delete or add extra sheets if required. The name of each sheet appears in
the sheet tab towards the bottom of the worksheet.
ii. While working in the worksheet, the Undo command helps the user to reverse the series of actions and
Redo helps to reverse the actions that have been executed by the Undo action.
By pressing Ctrl or clicking on the Undo option from the Edit menu or clicking on the Undo button
from the standard toolbar, we can undo. By pressing Ctrl or clicking on the Redo option from the Edit
menu or clicking on the ‘Redo’ button from the standard toolbar, we can redo.
2 Touchpad Information Technology-IX

