Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 81 - Data_Science_Part_A C12
P. 81

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

                                                                                         21 st  Century   #Productivity & Accountability
                C.  Competency-based/Application-based question.                             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

                     Objective Type Questions (Section A)

                A.  Tick ( ) 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]
                       a.  Chart paper                                   b.   Word document
                       c.   Presentation software                        d.   Spreadsheet

                    2.  Which is the correct step for printing a presentation?                                   [NCERT]
                       a.  File → Print                                  b.   File → Print → Handout
                       c.   File → Print → Handout → OK                  d.   File → OK

                    3.  Which menu do you use to insert a slide?                                                 [NCERT]
                       a.  Edit                                          b.   Insert
                       c.   Slide                                        d.   Tools
                    4.  A               is an arrangement of cells in a horizontal manner.        [CBSE Sample Paper, 2022]
                       a.  Row                                           b.   Column
                       c.   Cell                                         d.   Formula bar

                    5.  Pressing             key opens the Start menu.                            [CBSE Sample Paper, 2022]
                       a.  Windows                                       b.   Alt + Windows
                       c.   Ctrl + Windows                               d.   Alt + Ctrl + Windows

                                                                                                     ICT Skills-III  79

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