Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 80 - Data_Science_Part_A C12
P. 80

    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.
                 4.  If cell A1 contains 10 and cell B1 contains 50, the formula is given in C1 as A1+B1.
                    i.  The cell C1 does not show 60 as answer instead displays A1+B1. What could be the reason?
                    ii.  Can we give the formula in any other way?
                Ans.  i.  The cell C1 should contain a formula starting with = sign. In cell C1, enter=A1+B1.
                   ii.  We can enter in C1 cell =sum(A1:B1).

                 5.  What is the use of fill handle?
                Ans.   The Calc Fill Handle tool is used to automatically fill input in series. It fills the next cells when we drag it with the next
                    pre-defined value. For example, if you want to fill the numbers in sequence of even numbers 2, 4, 6...., or days of the
                    week as Monday, Tuesday,.... or months as Jan, Feb,...., we need to enter the first two values, select them and drag to
                    the next cells to generate the series.

            B.  Long answer type questions:
                 1.  What do you understand by presentation? Name few presentation software.
                Ans.  Presentation is a way of systematic display of information. It includes pictures, text, graphics, audios, videos and
                    animated objects that  are  organised and  presented  in a proper  sequence. With the advent  of computers and
                    development of different types of presentation software, ideas or information can be presented in a more effective,
                    efficient and interesting way.
                   There are a variety of presentation software available:
                   •  Microsoft PowerPoint                           •    OpenOffice Impress
                   •  Google Slides                                  •    LibreOffice Impress
                   •  Prezi                                          •    Keynote

                 2.  Define the following terms in association with spreadsheet:

                    i.  Formula bar
                    ii.  Name box
                    iii.  Worksheet
                Ans.  i.   Formula bar: Whatever you input, it appears in the formula bar. You can also immediately input or change data
                       and formulas in the Formula Bar.
                     ii.  Name box: The location of the selected cell is displayed in the name box. The cell’s location is a combination
                       of column and row. For instance, B5, where B denotes the column name and 5 denotes the row number.
                     iii.   Worksheet: A worksheet is a collection of cells in the shape of a grid (a network of intersecting lines that form
                      rectangles). When you initially open a spreadsheet, you will see a blank worksheet with the name ‘Sheet1’.

                 3.  What do you understand by function? Name and define the various functions Calc provides.
                Ans.   A function is a pre-defined formula that performs calculations with specific values in a specific order. One of the
                    primary advantages of functions is that they can save your time because you do not have to write the formula
                    yourself. Calc has various functions to help you with your calculations.
                    i. SUM: To calculate the sum of a given range of numbers
                    ii.  MAX: To find the maximum number from a given range of numbers
                    iii.  MIN: To find the minimum number from a given range of numbers
                    iv.  AVERAGE: To find the average value of a given range of numbers

               78   Touchpad Data Science-XII

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