Page 327 - TP_IT_V1.0_C9_flipbpookl
P. 327

3.  Which of the following is used to insert functions through interactive step-by-step processes?
                       a. Function Wizard                                b. Formula bar
                       c. Name box                                       d. Function button
                    4.  The absolute referencing is used to.
                       a. Fix the address of a row                       b. Fix the address of a column
                       c. Fix the address of both row and column         d. None of these
                    5.  The              symbol is used for representing the absolute referencing.
                       a. &                                              b. $
                       c. #                                              d. @
                    6.  Which of the following is not available on the Formatting toolbar?
                       a. Bold                                           b. Font Name
                       c. Font Color                                     d. Print
                    7.  The formatting of a cell can be changed by using     dialog box.
                       a. Format Pages                                   b. Format Cells
                       c. Format Sheets                                  d. Format Files
                    8.  What will be the output of =6*4-(11-3)/2^3?
                       a. 26                                             b. 35
                       c. 15                                             d. 23
                    9.  Which of the following types of package does Calc refer to?
                       a. Spreadsheet                                    b. Double sheet
                       c. Multi-sheet                                    d. Cannot determine
                   10.  Which of the following is an extension of a spreadsheet created in Calc?
                       a. .ods                                           b. .odd
                       c. .xls                                           d. .obj
                   11.  If we move a cell containing a formula having reference to another cell in the sheet what will happen to the cell numbers
                       used in the formula?
                       a. The cell references will update to reflect the new location.
                       b. Only the row references will update to reflect the new location.
                       c. Only the column references will update to reflect the new location.
                       d. The cell references will not change.
                   12.  A function should start with        .
                       a. ‘=’ sign                                       b. letter
                       c. number                                         d. All of the these
                   13.  Which of the following options is used to print a chart?
                       a. Insert → Char                                  b.  File → View
                       c. File → Print                                   d. View → Chart
                   14.  How many axes do charts in Calc typically have?
                       a. Two                                            b. Three
                       c. Two or three                                   d. Four
                  Ans.  1. b  2. d  3. a  4. c  5. b  6. d  7. b  8. d  9. a  10. a  11. a  12. a  13. c  14. a

                 B.  Fill in the blanks.
                    1.  A group of continuous cells selected with a mouse or a keyboard is known as a   .
                    2.                consists of tools used for the formatting of the spreadsheet, such as change of text colour, size, style etc.

                    3.                represent the data in a pictorial form which is easy to read and understand.
                    4.  / and ^ are examples of          operators.
                    5.                is the default chart type in the spreadsheet.

                                                                                               Electronic Spreadsheet  325
   322   323   324   325   326   327   328   329   330   331   332