Page 97 - Web_Application_v2.0_C12_Fb
P. 97

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. Which of the following features is used to perform addition in spreadsheets?              [NCERT]
                        i.   Format option                             ii   Charts
                        iii.   Graphs                                  iv.  Formula

                   Ans.  1.  iii   2. ii     3. i     4. iii   5. ii    6. i     7. iv    8. i     9. iii   10. ii

                       11. ii    12. iv

                 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 ............................... .

                   Ans.  1. functions and formulae   2. = (equal to)        3. AutoFilter and Standard filter

                        4. Insert        5. Ctrl + N

                 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.                                  ......................

                   Ans.  1. False           2. True             3. False             4. True              5. False


                 D.  Match the following:

                    1.  Functions                        a.  Horizontal arrangement of cells
                    2.  Google Slides                    b.  Pre-determined formulae

                    3.  Copy                             c.  Text, numbers and formulas
                    4.  Row                              d.  Presentation software

                    5.  Data                             e.  Ctrl + C


                   Ans.  1. b               2. d                3. e                 4. a                 5. c



                                                                                                      ICT Skills-IV  95
   92   93   94   95   96   97   98   99   100   101   102