Page 117 - IT-802_class_12
P. 117

interdisciplinary
            B.  Competency-based/Application-based questions:
               1.  You have a summer vacation project on how to make biogas. You have done a lot of research, clicked pictures of biogas
                 plants and taken videos of people who use biogas. Now, you have to make a presentation before the class. What would you
                 use?                                                                                   Subject Enrichment
             Ans.  OpenOffice Impress
               2.  Mr Tapas 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 quickly? What would Mr Tapas do?
             Ans.  He can use sorting feature to arrange the data alphabetically.



            Unsolved Exercise



                                                            Section A
                                                     (Objective Type Questions)
            A.  Choose the correct option.

               1.  Which of the following is a type of spreadsheet?
                 i.  Microsoft Excel                               ii.  LibreOffice Calc
                 iii. Google Sheets                                iv.  All of the above
               2.  A ............................... software makes our work more expressive and presentable?
                 i.  Presentation                                  ii.  Workbook
                 iii. Notebook                                     iv.  None of these
               3.  You can also use the keyboard to select the entire sheet by pressing ............................... .
                 i.   Ctrl + C                                     ii.   Ctrl + V
                 iii.  Ctrl + A                                    iv.  Ctrl + Z
               4.  The extension of Spreadsheet (OpenOffice) is ................................
                 i.  .xls                                          ii.  .ods
                 iii. .txt                                         iv.  All of the above
               5.  What would you do to select an entire worksheet in a spreadsheet?
                 i.  Click on the File tab and select Properties from the list
                 ii.  Click on the grey row heading
                 iii. Click on the grey rectangle in the upper left corner of the spreadsheet
                 iv. Click on the grey column heading
               6.  Ms Kaushiki is the class teacher of Std XII and has just started using a computer spreadsheet instead of her manual marks
                 register. She has entered the marks of her students in various subjects in a spreadsheet. Now, she wants to find out the total
                 marks for each student. What should she do?
                 i.  She can use the Sum function                  ii.  She can use + operator
                 iii. Both (i) and (ii)                            iv.  None of these
               7.  What is the default alignment of numbers in a cell?
                 i.  Left aligned                                  ii.  Right aligned
                 iii. Center aligned                               iv.  Randomly aligned
               8.  Ms  Kusum  is  sharing  the  computer  with  other  teachers  and  staff.  She  may  want  to  protect  her  data.  She  may  not
                 want  anyone  else  to  look  at  and  make  changes  to  her  work.  She  can  do  this  by  protecting  her  spreadsheet  using
                 a ................................
                 i.  password                                      ii.  track changes
                 iii. read only                                    iv.  None of these




                                                                                                   ICT Skills-IV  115
   112   113   114   115   116   117   118   119   120   121   122