Page 209 - CA_165_V2.0_C9_Flipbook
P. 209

Ans. 1. AutoFill    2. Custom List     5.     The extension of OpenOffice Calc file is .................................... which automatically gets attached with the file
                         name.
 SECTION C       C.  Assertion and Reasoning question:
 (Case-based/Passage-based Type Questions)       The following questions consist of two statements – Assertion (A) and Reasoning (R). Answer these
      A company manager is using OpenOffice Calc to prepare an employee attendance sheet. He needs to:  questions by selecting the appropriate option given below:
    ●   Enter employee names and their daily attendance (P for present, A for absent).     i.   Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation of Assertion (A).
    ●   Ensure that the names are fully visible within the cells.     ii.   Both Assertion (A) and Reason (R) are true but Reason (R) is not the correct explanation of Assertion (A).
    1.   Which feature should he use to display full employee names without changing the column width?     iii.  Assertion (A) is true, but Reason (R) is false.
    2.   By default, where is text aligned in a Calc cell?     iv.   Assertion (A) is false, but Reason (R) is true.
    3.   How can he quickly fill in attendance for multiple employees without typing manually?    1. Assertion (A): A spreadsheet allows users to perform complex calculations automatically.

    Ans. 1. Wrap Text    2. Left alignment    3. AutoFill             Reason (R): Spreadsheets support formulas and functions that can process numerical data.
                           2.  Assertion (A): In a spreadsheet, text data and numerical data are treated in the same way.
 Unsolved Exercise             Reason (R): A spreadsheet only recognises numbers for calculations, whereas text is used for labels or
                           descriptions.
                           3. Assertion (A): A spreadsheet in Calc can contain multiple sheets.
 SECTION A
                              Reason (R): Calc allows users to organise data in separate sheets within a single file.
 (Objective Type Questions)    4.  Assertion (A): Pressing Ctrl + Z in Calc will redo the last action performed.

 A. Multiple choice questions.              Reason (R): The shortcut Ctrl + Z is used to undo the last action, not redo it.
    1.   Which feature is used to display data graphically in spreadsheets?
       i.  Charts   ii.  Pivot Table                          SECTION B
       iii.  Data Sort   iv.  Hyperlink               (Subjective Type Questions)
    2.   Which of the following is NOT a valid cell reference in OpenOffice Calc?  A.  Very short answer type questions.
       i.  A1    ii.  B2      1.   How many rows are there in a sheet of OpenOffice Calc?
       iii.  1A    iv.  C3     2.   What is active cell?
    3.   Which menu option allows you to insert a new sheet in OpenOffice Calc?     3.   Write the shortcut to save a new spreadsheet.
       i.  File    ii.  Edit     4.   Which feature of OpenOffice Calc is used to place the cursor anywhere in a sheet directly?
       iii.  Insert    iv.  Tools     5.   What is the shortcut key for Redo?
    4.   What is the shortcut key to save a document in OpenOffice Calc?      6.   Which feature of OpenOffice Calc can be used to print series of months of the year?
       i.  Ctrl + S    ii.  Ctrl + P
       iii.  Ctrl + O   iv.  Ctrl + N  B.   Short answer type questions.

    5.   Which type of data can be entered into a cell in OpenOffice Calc?     1.   How can a sheet of spreadsheet be hidden?
       i.  Text    ii.  Numbers     2.   How will you add a new sheet in your spreadsheet?
       iii.  Formulas    iv.  All of these     3.   Explain the ‘AutoFill’ feature of spreadsheet.
    6.   To enter a formula in OpenOffice Calc, which symbol must be used first?     4.   What are the different types of data that can be entered in the cells?
       i. #    ii. =     5.   Differentiate between Wrap Text and Shrink to fit cell size.
       iii. @   iv. $  C.   Long answer type questions.
 B.   Fill in the blanks.     1.   Explain any two logical functions with example.
    1.   A OpenOffice Calc sheet contains .................................... columns and 65,536 rows.     2.   Define Operators. List and describe all the operators.

 2.  .................................... helps to change the  direction of contents in a cell.     3.   Write down the steps to hide columns in OpenOffice Calc.
    3.   Series of numbers can be filled using .................................... feature.     4.   Write short notes on:
 4.  .................................... button is used to enter or edit formula in OpenOffice Calc.        i.  Formula Bar   ii.  Operands
                         iii.  Sheet Tab                                     iv.  Formatting Cells


                                                                                    Working with Spreadsheet     207
   204   205   206   207   208   209   210   211   212   213   214