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

B.  Long answer type questions:

           1.  Differentiate between row range and column range with an example.
           2.  Answer the following:
               a.  Cell A1 contains 20 and B1 contains 3.

                  What will be the contents of cell C1, if the formula =A1+B1*2^3 is entered in cell C1?
               b.  The contents of Cell A1, B1, C1 and D1 are 10, -20, 30 and -40 respectively.
                  What will be the value displayed in cell E1 which contains the formula =MIN(A1:D1)?
               c.   Cell D3 contains the formula =$B3 + C3 and this formula is copied to cell E3. What will be the copied formula in
                 cell E3?
           3.  A Biology teacher has used spreadsheet software to form the tabular format of population growth in various countries in
              the last 10 years. She now wants to depict a comparison of the same diagrammatically. Which option of the spreadsheet
              she would use? Explain any two types of it.
           4.  How do formulae work in a spreadsheet?                                                     [NCERT]
           5.  A maths teacher wants to generate a series of multiples of 11. Which feature of the spreadsheet should he be advised to
              use to make his work easier? What are the steps to use it?

           6.  What is the default name of the worksheet? How can it be renamed?                          [NCERT]
           7.  What is cell referencing? What is the significance of the $ sign in cell referencing? Explain with examples.
           8.  What is the use of Min function? Write any three ways to use it.

                                                                                       21 st   #Computational Thinking
        C.  Competency-based/Application-based questions:                            Century
                                                                                      Skills  #Productivity & Accountability
           1.  Snighdha’s computer mouse is not working properly and she wants to use shortcut key combination to work in digital
              spreadsheet. Help her by giving the key combinations to do the following:
               a.  Move to one screen down on the worksheet.
               b.  Opens function wizard.
               c.  Moves the cursor to the Name box of the formula bar.
               d.  To change the value in a cell.

               e.  Go to last cell of a worksheet.
           2.  Consider the following worksheet.















               Answer the following queries by writing functions/formulas:
               a.  Find the number of Jeans to be calculated as the product of QUANTITY and PRICE in cell D4.
               b.  Copy the formula from D5 to D8.
               c.  Find the total price of all the items in cell C9.
               d.  Find the most expensive item in cell C9.
               e.  Find the most inexpensive item in cell C10.




          312   Trackpad Information Technology-IX
   307   308   309   310   311   312   313   314   315   316   317