Page 193 - CA 165 ver 1.0 Class 9
P. 193
Solved Exercise
PART A
A. Very short answer type questions.
1. Name the option which fits text in a cell within the specified column width.
2. Which feature in Calc can helps in generating the series: 7, 14, 21, 28 ...., 70 quickly?
3. What is the cell address of the cell formed by the intersection of thirteenth row and fifth column?
4. Name the feature that lets the user create a list of names of his colleagues.
5. Name the feature used to change the direction of text inside a cell.
Ans. 1. Wrap text 2. Autofill 3. E13 4. Custom List 5. Text Orientation
B. Fill in the blanks.
1. Calc is a .................................... software.
2. A .................................... is a combination of multiple worksheets.
3. A .................................... is an intersection of a row and a column.
4. .................................... displays the content of the active cell.
5. .................................... displays the address of the active cell.
6. To view the current status of an active sheet we can refer to the .....................................
7. There are .................................... columns in a Calc worksheet.
Ans. 1. spreadsheet 2. workbook 3. cell 4. Formula bar 5. Name box 6. Status bar
7. 1024
C. Case Based MCQs
To begin working with a Spreadsheet Package, the user has to feed or enter data in a worksheet. Based on which
type of data is being stored, data can be classified into numeric, alpha-numeric or text, date/time and formula.
1. The numbers or values on which formulae are applied to perform mathematical operations are called
.....................................
i. Operand ii. Operator
iii. Function iv. Expression
2. .................................... is an expression which helps to perform arithmetical calculation and also executes non-
arithmetical tasks.
i. Numeric Data ii. Operand
iii. Expression iv. Formula
3. In Calc, which data are aligned (by default) towards the left side of the cell and are generally not meant
for calculation?
i. Date and Time ii. Numeric
iii. Alphanumeric iv. Formulae
4. Which data consists of digits (0–9), ‘e’ (Exponential), decimal (.) and numeric operators like
+,- ,/,*,%,$ ?
i. Numeric ii. Alphanumeric
iii. Date and Time iv. Formulae
Working with Spreadsheet 191

