Page 99 - Web_Application_v2.0_C12_Fb
P. 99

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.   Spreadsheet programmes have grown in popularity due to the following 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 exported to or imported from other applications.
                        iv.  Data can be easily represented in pictorial form, such as graphs or charts.
                        v.  Formulae are automatically recalculated when the underlying data values change.
                    5.  Differentiate between Undo and Redo.
                  Ans.   While working in the worksheet, ‘Undo’ command helps the user to reverse the series of actions and ‘Redo’ helps
                       to reverse the actions that have been executed by the ‘Undo’ action.

                       Pressing ‘Ctrl+Z’ or by clicking on the ‘Undo’ option from the ‘Edit’ menu or by clicking on the ‘Undo’ button
                       from the standard toolbar, we can undo. Pressing ‘Ctrl+Y’ or by clicking on the ‘Redo’ option from the ‘Edit’ menu
                       or by clicking on the ‘Redo’ button from the standard toolbar, we can redo.


                 C.   Competency-based/Application-based question.                        21 st  Century   #Productivity & Accountability
                                                                                              Skills
                     Muskan has done market analysis for the launch of a new product. Now she has to showcase her analysis to the
                     board members where she works. How should Muskan showcase her results?
                 Ans. Muskan should showcase her results using a presentation software. She should include graphs for her analysis and
                     transitions and animations to make her presentation appeasing to all.


                 Unsolved Exercise


                                                                Section A
                                                        (Objective Type Questions)
                 A.  Choose the correct option.
                    1.  You have a summer vacation project on how to make biogas. You have done a lot of research, clicked pictures
                       of biogas plants and taken videos of people who use biogas. Now, you have to make a presentation before the
                       class. What would you use?                                                                 [NCERT]
                        i.   Chart paper                               ii.  Word document
                        iii.   Presentation software                   iv  Spreadsheet
                    2.  Which is the correct step for printing a presentation?                                    [NCERT]
                        i.  File → Print                               ii.  File → Print → Handout
                        iii.   File → Print → Handout → OK             iv.  File → OK
                    3.  Which menu do you use to insert a slide?                                                  [NCERT]
                        i.   Edit                                      ii.  Insert
                        iii.   Slide                                   iv.  Tools
                    4.  A ............................... is an arrangement of cells in a horizontal manner.   [CBSE Sample Paper, 2022]
                        i.   Row                                       ii.  Column
                        iii.   Cell                                    iv.  Formula bar

                                                                                                      ICT Skills-IV  97
   94   95   96   97   98   99   100   101   102   103   104