Page 77 - Web Applications (803) Class 12
P. 77

5.  Which of the following does NOT exist in a slide layout in Impress?
                        a.  Title                                        b.   Animation
                        c.   Image                                       d.   Text Box

                    6.  When we give ‘D12’ in a formula in Calc, we are referring to     .
                        a.  cell reference                               b.   cell name
                        c.   cell range                                  d.   function

                    7.  In which menu in Impress will you find features like Duplicate Slide, Delete Slide, etc.?
                        a.  File                                         b.   workbook
                        c.   Insert                                      d.   Slide
                    8.  What happens when you select a cell in Calc and type ‘=C12’ in the cell?
                        a.  The selected cell will show the value in cell C12.      b.  The selected cell will be blank.

                        c.  The selected cell will show C12 written in it.      d.  Error
                    9.  In Impress, the slide that announces the topic and sets the tone for the presentation is the    .
                        a.  content slide                                b.   master slide

                        c.   title slide                                 d.   handout
                    10.  Which feature in Calc helps to display data in column(s) as per specified criteria?
                        a.  Sorting                                      b.   Filtering
                        c.   Functions                                   d.   All of the above

                    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]
                        a.  apply filter                                 b.   sort the data

                        c.   use password                                d.   format data

                    12.  Which of the following features is used to perform addition in spreadsheets?             [NCERT]
                        a.  Format option                                b.   Charts
                        c.   Graphs                                      d.   Formula

                 B.  Fill in the blanks.

                    1.  Calculations can be done in Calc using         and               .
                    2.  Any function in Calc must begin with an         sign.
                    3.                 and               are the two types of filters in Calc.
                    4.  Hyperlinks can be inserted in an Impress presentation from the      menu.

                    5.  A new Impress file can be opened using the keyboard shortcut       .
                 C.  State whether the following statements are true or false.

                    1.  Charts cannot be inserted in an Impress presentation.
                    2.  Large volumes of data can be manipulated using Calc.
                    3.  Arranging the data in descending order is called filtering.
                    4.  Data stored in a spreadsheet can be used for calculations, graphical representation, and
                        information display.
                    5.  You cannot change the layout of any slide in Impress.

                                                                                                 ICT Skills-IV  75
   72   73   74   75   76   77   78   79   80   81   82