Page 194 - CA 165 ver 1.0 Class 9
P. 194
5. A formula always starts with .................................... sign.
i. – ii. =
iii. * iv. $
Ans. 1. i. 2. iv. 3. iii. 4. i. 5. ii.
PART B
A. Short answer type questions.
1. What is a spreadsheet software? Give two examples.
Ans. A spreadsheet package is an application software that analyzes 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 workbook different from a worksheet?
Ans. Worksheet is the working area or page on the screen. A worksheet consists of rows and columns. A
workbook is a collection of multiple worksheets. (A workbook is like a book and the worksheet 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 worksheet 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’.
B. 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.
● Complex and long calculations can be solved accurately in a short span of time.
● Data can be exported to or imported from other packages.
● Data can be expressed in tabular or pictorial form, i.e. in the form of charts and graphs.
● Non-numeric data can also be processed.
2. Discuss the various Cell Alignment options available in Calc.
Ans. Various horizontal alignment options are:
● Default: The contents will be aligned according to the default settings of the type of data being entered.
● Left: The contents will be aligned towards the left side of the cell.
● Right: The contents will be aligned towards the right side of the cell.
● Center: The contents will be aligned towards the center of the cell.
● Filled: The contents will be displayed within the column width only. The data which does not get
accommodated in the cell width will be hidden in the sheet.
192 Touchpad Computer Applications-IX

