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
   189   190   191   192   193   194   195   196   197   198   199