Page 76 - Artificial Intellegence_v2.0_Class_12
P. 76

11.  Mr  Gupta  has a  spreadsheet  with  a  list of 500 items in his shop.  A customer  comes and  asks for  a  particular
               item.   o   should  he  arrange  the  data  so  that  he  can  find  that  item  fast    hat   ould   r   upta  do    e   ill
                               .
                a.  apply filter                                 b.   sort the data
                c.   use password                                d.   format data

              .   hich of the follo ing features is used to perform addition in spreadsheets
                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.

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

        D.  Match the following.
             .   unctions               a.    ori ontal arrangement of cells
            2.  Google Slides           b.   Pre-determined formulae
            3.  Copy                    c.   Text, numbers and formulas
             .   o                      d.    resentation soft are

            5.  Data                    e.   Ctrl + C

                                          SECTION B (Subjective Type Questions)
        A.  Short answer type questions.

            1.  Define workbook.
            Ans.   A workbook is a single file that contains one or more worksheets. Each sheet can contain a large number of cells
                organised into 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.

            3.  What is filter in spreadsheet software?
            Ans.  Filtering is a quick and simple way to find and work with specific data based on the criteria you specify. The filter
                feature selectively hides the data you don't want to see and displays only the rows or columns that meet the conditions
                or criteria you set.

              74      Touchpad Artificial Intelligence (Ver. 2.0)-XII
   71   72   73   74   75   76   77   78   79   80   81