Page 206 - CA_165_V2.0_C9_Flipbook
P. 206
iv. Assertion (A) is false, but Reason (R) is true.
1. Assertion (A): The Formula Bar in Calc is used to display the address of the active cell.
Reason (R): The Name Box is used to enter or edit formulas in Calc.
2. Assertion (A): The Wrap Text feature in Calc helps in adjusting long text within a cell without changing
the column width.
Reason (R): It increases the row height automatically to fit the text properly.
Ans. 1. iii. 2. i
SECTION B
(Subjective Type Questions)
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. Short answer type questions.
1. What is a spreadsheet software? Give two examples.
Ans. A spreadsheet package is an application software that analyses data with the help of graphs and charts
and does analysis, calculations, comparisons, etc. Two examples are MS Excel and OpenOffice Calc.
2. How is a spreadsheet different from a sheet?
Ans. Sheet is the working area or page on the screen. A sheet consists of rows and columns. A spreadsheet is a
collection of multiple sheets. (A spreadsheet is like a book and the sheet is like a page of a book).
3. State the purpose of the Name box and Formula bar.
Ans. Name box lies besides the Formula Bar. It contains the address of the current cell or active cell. ‘Formula
Bar’ lies below the formatting toolbar. Formula that performs different calculations in cells are entered and
displayed here. It is denoted by ‘fx’.
4. What is the purpose of Wrap text option?
Ans. Wrap text option wraps the text in multiple lines to accommodate it automatically within the column width
by increasing the row height.
5. Define Custom List.
Ans. Custom list is some series of names or text that can be predefined and then it can be displayed when the
initial data is entered and AutoFill is applied.
6. What are cells in a spreadsheet? How are cells named?
Ans. A rectangular box formed by the intersection of a row and a column is called a cell. Cell is the basic unit of
a spreadsheet where data (numbers, text, formulas, etc.) are entered. Each cell has a unique address which
identifies its location. A cell address is identified with its column position followed by its row number, for
example: ‘A5’ is the cell address that is a combination of column ‘A’ and row ‘5’.
C. Long answer type questions.
1. List the important features of a Spreadsheet Package.
Ans. The important features of a Spreadsheet Package are:
● Bulk volume of data can be handled easily with the help of spreadsheet.
204 Touchpad Computer Applications (Ver. 2.0)-IX

