Page 311 - Trackpad IT-402_Class-IX
P. 311

12.  Which of the following is not a type of data?
                  a. Numbers                                        b. Formula
                  c. Text                                           d. Operator
              13. Which of the following option is used to print a chart?                                     [NCERT]
                  a. Insert → Chart                                 b. File → View
                  c. File → Print                                   d. View → Chart

            B.  Fill in the blanks.

               1.                displays the name or reference of an active cell or a selected cell range.
               2.                is used to enter a formula that needs to be applied in the current cell or selected cell range.
               3.                is a combination of a column name and row number.
               4.  The              chart is the default chart in OpenOffice Calc.

               5.                gives the status of the worksheet in terms of insert or overwrite mode, sheet sequence number, page
                  style, etc.

            C.  State whether the following statements are true or false:

               1.  Horizontal scrollbar is used to move up or down in a worksheet.
               2.  Ctrl+Home takes the cursor to the first sheet in a spreadsheet.
               3.  A spreadsheet is also called as worksheet.                                                 [NCERT]
               4.  An expression with an equal “=” sign is treated as text and no calculations can be done.
               5.  =min(100;200;3452) is an example of a function in a spreadsheet.

               6.  In a spreadsheet, the default font size is 10 which can be increased or decreased.
               7.  There are ‘n’ number of sheets in a spreadsheet.                                           [NCERT]

                                              SECTION B (Subjective Type Questions)
            A.  Short answer type questions:

               1.  Explain any two operations performed on data in a spreadsheet.                             [NCERT]
               2.  What is the advantage of using a spreadsheet?
               3.  Name the three types of referencing methods in a spreadsheet.
               4.  What is the difference between spreadsheet, worksheet and sheet?                           [NCERT]
               5.  What is the use of the AutoFill feature in a spreadsheet?
               6.  The value in cell C10 is 100 and cell D10 is 60. The formula entered in cell E10 is =C10 – D10. If the formula is copied to E20,
                  what will be displayed in the:
                  a.  cell
                  b.  formula bar
                  Can you explain the reason for this?
               7.  Explain in one line each the various types of charts.                                      [NCERT]
               8.  Assume the values in some cells as A3=2, B3=3, C3=1 and D3=A3+B3/C3.
                  What will happen if the content of the cell:
                  a.  A3 is changed to 5
                  b.  B3 is deleted
               9.  Can you include more than one mathematical operators in a formula?                         [NCERT]







                                                                                          Electronic Spreadsheet  311
   306   307   308   309   310   311   312   313   314   315   316