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

13.  How can one calculate the total of values entered in a worksheet column of?               [NCERT]
              a. By manual entry                                 b. By auto-sum
              c. By formula                                      d. By sum function
          Ans.  1. a.  2. b  3. d  4. a  5. a.  6. d  7. b  8. a  9. d  10. b  11. c  12. d  13. d.

        B.  Fill in the blanks.

           1.  A group of continuous cells selected with a mouse or keyboard is known as a   .
           2.                consists of the tools used for formatting of the spreadsheet such as change of text colour, size, style, etc.
           3.  A               represents the data in a pictorial form which is easy to read and understand.
           4.  / and ^ are examples of           operators.
           5.                is the default chart in a spreadsheet.
          Ans.  1. cell range     2. Formatting toolbar   3. chart   4. mathematical   5. Column Chart


        C.  State whether the following statements are true or false:
           1.  A cell is a combination of row and column.                                                [NCERT]
           2.  All the formulae or functions in a spreadsheet should begin with an “=” sign.
           3.  =B4+B5 is an example of a function in a spreadsheet.
           4.  SUM() returns the count of the number of cells that contain numeric values.

           5.  A new row or column can be inserted from the Insert menu.
           6.  Semicolon (;) is used to separate the arguments in a function.
           7.  In a spreadsheet, we can change the column width and row height.                          [NCERT]
          Ans.  1. False    2. True    3. False   4. False   5. True    6. True    7. True

                                          SECTION B (Subjective Type Questions)


        A.  Short answer type questions:
           1.  What is cell referencing?
          Ans.  A cell address is a combination of a column name and a row number like A5, B12, H23, etc. Using a cell address in a formula
              or a function is known as cell referencing.
           2.  How can a chart be inserted into a spreadsheet? Write the steps to be followed.
          Ans.  We can insert charts in two different ways – the Chart option in the Insert menu or the Chart icon on the Standard toolbar.
               The steps to insert a chart are as follows:
               i.  Select the cell range for which a chart is required to be inserted.
               ii.  Select Insert menu → Charts. It will open a Chart Wizard dialog box.
               iii.  Select the Chart Type as Column .
               vi.  Click on Finish. It will close the dialog box and a column chart will be inserted.
           3.  Naina Sharma wants to store data of her monthly expenditure for a period of one year and also perform some calculation
              and analysis. Which Office application will you suggest Naina for this purpose?
          Ans.  OpenOffice Calc
           4.  In spreadsheet software like OpenOffice Calc, the formula =A1+ $A$2 is entered in cell A3 and then copied to cell B3. What
              formula will be copied to B3?
          Ans.  =B1+ $A$2
           5.  Name the cells that are included in the cell range A1:B2.
          Ans.  A1, A2, B1 and B2.





          306   Trackpad Information Technology-IX
   301   302   303   304   305   306   307   308   309   310   311