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

c.  Steps to see all the formulas.
               d.  Feature to copy formula to rest of the cells.
          Ans.  a.  Right click on sheet tab → erase the old name and write new name.
               b.  Click on Insert → Chart option from the menu bar. Select the Line Chart option from the dialog box and click on OK.
               c.  Click on View → Show Formula option.
               d.   AutoFill OR Copy & Paste options.



                                                         Unsolved

                                          SECTION A (Objective Type Questions)

        A.  Choose the correct option.

           1.  Cut, Copy and Paste are a part of the       in spreadsheet.
              a. Status bar                                      b. Menu bar
              c. Standard toolbar                                d. Formula bar
           2.  Which of the following is not a valid cell range?
              a. A1:C1                                           b. A1:1B
              c. C1:C10                                          d. C2:G15
           3.  How many default sheets are there in a spreadsheet?
              a. 3                                               b. 4
              c. 5                                               d. 6
           4.  The function used to calculate the maximum marks in a spreadsheet is    .
              a. MAX(A1:A10)                                     b. MAXIMUM(A1:A10)
              c. HIGH(A1:A10)                                    d. HIGHEST(A1:A10)
           5.  In a spreadsheet, a formula can have        .
              a. A constant value                                b. A cell address
              c. A cell range                                    d. All of these
           6.  The chart that shows the percentage is the       .
              a. Column chart                                    b. Line chart
              c. Scattered chart                                 d. Pie chart
           7.  The default chart created is         .
              a. Bar chart                                       b. Column chart
              c. Pie chart                                       d. Area chart
           8. How many axes does charts in Calc have?                                                     [NCERT]
              a. Two                                             b. Three
              c. Two or three                                    d. Four
           9.  Which of the following formula is correct?
              a. =MIN(C5:C10)                                    b. =MINIMUM(C5:C10)
              c. =MINI(C5:C10)                                   d. =MIN(C5+C10)
          10.  Absolute referencing occurs when          .
              a. The formula is dragged and the cell reference adjusts automatically.
              b. The formula is dragged but the cell reference does not adjust.
              c. $ symbol is automatically added with each cell value.
              d. The spreadsheet is saved with “absolute” as the file name.

          11.  Which of the following type of package does Calc refer to?                                 [NCERT]
              a. Spreadsheet                                     b. Double sheet
              c. Multi-sheet                                     d. Cannot determine

          310   Trackpad Information Technology-IX
   305   306   307   308   309   310   311   312   313   314   315