Page 269 - open office
P. 269
Solved Exercise
Section A
(Objective Type Questions)
A. Multiple choice questions:
1. Which of the following contains the address of the current cell/active cell
i. Name Box ii. Cell Address
iii. Status Bar iv. None of these
2. Which of the following button is used to calculate the sum of specified range of cells
i. Sum ii. AutoSum
iii. Formula iv. None of these
3. ................................. is a symbol that performs certain mathematical or logical operations.
i. Function ii. Formula
iii. Bullets iv. Operator
4. Which of the following function produces the current date and time and contains no argument
i. MO TH( Date ) ii. DA ( Date )
iii. TODA () iv. OW()
5. ................................. range is the number of selected cells spread across the row and column.
i. Horizontal ii. ertical
iii. Mixed iv. None of these
6. What is the active cell in a worksheet known as
i. Cell Address ii. Cell Pointer
iii. Name Box iii. None of these
. Which of the following is not a type of data
i. numeric ii. alpha-numeric
iii. date/time iv. operator
. Which of the following is an extension of a worksheet created in Calc CBSE Handbook
i. .ods ii. .odd
iii. .xls iv. .obj
. Which of the following is a shortcut key to open a new workbook:
i. Ctrl W ii. Ctrl S
iii. Ctrl iv. Ctrl
1 . Formula bar lies below the ................................. bar.
i. Formatting Tool ii. Standard Tool
iii. Status iv. None of these
Ans. 1. i. 2. ii. 3. iv 6. iv. 5. iii
. 6. ii. . iv. . i . iv 1 .i
Working with Spreadsheet 26

