Page 77 - Artificial Intellegence_v2.0_Class_12
P. 77

4.  If cell A1 contains 10 and cell B1 contains 50, the formula is given in C1 as A1+B1.
                   i.   he cell    does not sho     as ans er instead displays A    .  hat could be the reason
                   ii.   an  e give the formula in any other  ay
               Ans.  i.   he cell    should contain a formula starting  ith   sign. In cell   , enter A    .
                   ii.   e can enter in    cell  sum A    ).

               5.  What is the use of fill handle?
               Ans.    he  alc  ill  andle tool is used to automatically fill input in series. It fills the ne t cells  hen  e drag it  ith the ne t
                   pre-defined value. For example, if you want to fill the numbers in sequence of even numbers 2, 4, 6...., or days of the
                    eek as  onday,  uesday,.... or months as  an,  eb,....,  e need to enter the first t o 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  ob ects  that  are  organised  and  presented  in  a  proper  sequence.   ith  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.
                    here are a variety of presentation soft are available
                  •  Microsoft PowerPoint                            •    OpenOffice Impress
                  •  Google Slides                                   •    LibreOffice Impress
                  •  Prezi                                           •    Sway
                .  Define the follo ing terms in association  ith 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:  he location of the selected cell is displayed in the name bo .  he 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  orksheet is a collection of cells in the shape of a grid  a net ork of intersecting lines that form
                      rectangles).  hen you initially open a spreadsheet, you  ill see a blank  orksheet  ith the name   heet  .

               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
               4.  What are the advantages of spreadsheets?
               Ans.    preadsheet programmes have gro n in popularity due to the follo ing benefits
                   i.  Built-in functions make calculations easier, faster, and more accurate.
                   ii.  Large amounts of data can be handled and manipulated with ease.
                   iii. Data can be e ported to or imported from other applications.
                   iv. Data can be easily represented in pictorial form, such as graphs or charts.
                   v.  ormulae are automatically recalculated  hen the underlying data values change.
                                                                                            IC T S ki l l s- IV  75
   72   73   74   75   76   77   78   79   80   81   82