Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 79 - Data_Science_Part_A C12
P. 79

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

                D.  Match the following:

                   1.  Functions               a.   Horizontal arrangement of cells
                   2.  Google Slides           b.   Pre-determined formula
                   3.  Copy                    c.   Text, numbers and formulas
                   4.  Row                     d.   Presentation software
                   5.  Data                    e.   Ctrl + C

                     Standard Questions (Section B)

                A.  Short answer type questions:

                    1.  Define spreadsheet.
                   Ans.   A spreadsheet consists of sheets. Spreadsheet is the working area or page on the screen. A Spreadsheet consists of
                       rows and columns.
                    2.  What is an active cell?
                   Ans.  The selected cell is called the active cell and is highlighted with a thick border. Also, the address of the active cell is
                       displayed in the Name box.

                                                                                                     ICT Skills-III  77

| 74 75 76 77 78 79 80 81 82 83 84 |