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