Page 208 - CA_165_V2.0_C9_Flipbook
P. 208

Ans. 1. AutoFill    2. Custom List


                                                               SECTION C
                                               (Case-based/Passage-based Type Questions)
                        A company manager is using OpenOffice Calc to prepare an employee attendance sheet. He needs to:
                      ●   Enter employee names and their daily attendance (P for present, A for absent).
                      ●   Ensure that the names are fully visible within the cells.
                      1.   Which feature should he use to display full employee names without changing the column width?
                      2.   By default, where is text aligned in a Calc cell?
                      3.   How can he quickly fill in attendance for multiple employees without typing manually?

                      Ans. 1. Wrap Text    2. Left alignment    3. AutoFill


                  Unsolved Exercise



                                                               SECTION A
                                                       (Objective Type Questions)

                  A. Multiple choice questions.
                      1.   Which feature is used to display data graphically in spreadsheets?
                          i.  Charts                                          ii.  Pivot Table
                          iii.  Data Sort                                     iv.  Hyperlink
                      2.   Which of the following is NOT a valid cell reference in OpenOffice Calc?
                          i.  A1                                               ii.  B2
                          iii.  1A                                             iv.  C3
                      3.   Which menu option allows you to insert a new sheet in OpenOffice Calc?
                          i.  File                                             ii.  Edit
                          iii.  Insert                                         iv.  Tools
                      4.   What is the shortcut key to save a document in OpenOffice Calc?
                          i.  Ctrl + S                                        ii.  Ctrl + P
                          iii.  Ctrl + O                                      iv.  Ctrl + N

                      5.   Which type of data can be entered into a cell in OpenOffice Calc?
                          i.  Text                                            ii.  Numbers
                          iii.  Formulas                                      iv.  All of these
                      6.   To enter a formula in OpenOffice Calc, which symbol must be used first?
                          i. #                                                ii. =
                          iii. @                                              iv. $
                  B.   Fill in the blanks.
                      1.   A OpenOffice Calc sheet contains .................................... columns and 65,536 rows.

                      2.  .................................... helps to change the  direction of contents in a cell.
                      3.   Series of numbers can be filled using .................................... feature.
                      4.  .................................... button is used to enter or edit formula in OpenOffice Calc.




                   206   Touchpad Computer Applications (Ver. 2.0)-IX
   203   204   205   206   207   208   209   210   211   212   213