Page 118 - IT-802_class_12
P. 118

9.  Mr Tapas shares the computer in his office with other colleagues. He wants to make sure no one sees the financial data he
             saves on the computer. What should he do?
             i.  Lock the computer in a cupboard
             ii.  Change the password of his computer so that no one can use it
             iii. Apply a password to the financial data sheet
             iv. Leave it as it is and hope that no one will open it
          10.  Which of the following is the correct step for printing a presentation?
             i.  FileÆPrint                                     ii.  FileÆPrintÆHandout
             iii. FileÆPrintÆHandoutÆOK                         iv.  FileÆOK
          11.  Mr Gupta has a spreadsheet with a list of 500 items in his shop. A customer comes and asks for a particular item. How should
             he arrange the data so that he can find that item fast? What would Mr Gupta do? He will:     [NCERT]
             i.  apply filter                                   ii.  sort the data
             iii. use password                                  iv.  format data.
          12.  What do you need to install on your computer to be able to run Impress?                    [NCERT]
             i.  Google                                         ii.  Microsoft Office
             iii. LibreOffice                                   iv.  Apple iOS

        B.  Fill in the blanks.
           1.  ............................... consists of an operand and the operators that operate upon the data.
           2.  Sorting is the process of arranging data in ............................... .
           3.  Presentation software is a tool used to create ............................... .

           4.  ............................... is a tool used to create visual presentations.
           5.  The............................... can be changed by using the Font Color button.

        C.  State whether the following statements are true or false:
           1.  Calc is the spreadsheet component of OpenOffice.org.

           2.  Status bar contains shortcut buttons for frequently used options.
           3.  We need to press and hold the Shift key to select multiple columns or rows that are not contiguous.
           4.  Functions are in-built formulas in ‘Calc’ that can be used to perform arithmetic and non-arithmetic tasks.
           5.  The text colour can be changed by using the Font Color button and selecting the colour of your choice.



                                                         Section B
                                                 (Subjective Type Questions)
        A.  Answer the following questions:
           1.  What is a spreadsheet? Give a few examples of spreadsheet software.

           2.  What is the difference between a cell and a cell address?
           3.  What is auto filter?
           4.  What is sorting?
           5.  What is ClipArt?
           6.  What are the different components in a spreadsheet?
           7.  Define relative referencing, mixed referencing, and absolute referencing.
           8.  How would you protect a spreadsheet with a password?

           9.  Explain some advanced features of digital presentation.




          116   Touchpad Information Technology-XII
   113   114   115   116   117   118   119   120   121   122   123