Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 83 - Data_Science_Part_A C12
P. 83

    C.  Competency-based/Application-based questions.                              21 st  Century   #Technology Literacy
                                                                                                   Skills
                   Harshit is not very comfortable while working in Excel. Suggest to which the appropriate feature that he can use to do his
                   work in Excel.

                   i.   Type Employee id of 50 employees sequentially.
                   ii.   Show sales of each salesman graphically.
                   iii.  Calculate total sales

                Previous Years’ Questions

                    1.  In a spreadsheet  software, an arrangement of cells in a vertical manner is known as:      [2023]
                       a.   Worksheets                                   b.  Workbooks
                       c.   Rows                                         d.  Columns
                   Ans.  d.    Columns

                    2.  Which of the following is not an example of a spreadsheet?                                 [2023]
                       a.   Microsoft Excel                              b.  LibreOffice Calc
                       c.   LibreOffice Impress                          d.  Google Sheets

                   Ans.  c.   LibreOffice Impress
                    3.  Differentiate between a row and a cell of a spreadsheet.                                   [2023]
                   Ans.  Row: A row is an arrangement of cells in a horizontal manner.
                              (or)
                             A row is a complete record
                       Cell:  A cell is a rectangle shaped box, where the row and column meet. In cell we can enter text, numbers, date,
                           formula, etc. The cell that is selected appears highlighted.
                              (or)
                             A cell is an individual unit / item/ box presents in a spreadsheet.
                    4.  When a cell address is referred to in a formula, it is called    .                         [2022]
                       a.  Cell referencing                              b.   Naming
                       c.   Range                                        d.   Operators
                   Ans.  a.   Cell referencing
                   5. Which option will you use to change the colour of the text?                                  [2021]
                       a.  Font Color                                    b.  Font
                       c.  Highlight Color                               d.  Format
                   Ans.  a.    Font Color

                                                                                                21 st  Century   #Creativity
                                                                                                    Skills
                            Lab Activity

                         1.     Create your mid-term report card in spreadsheet software. Use different fonts and colours to highlight
                              the totals and percentage.
                         2.   Create a presentation on 'Positives of Covid Pandemic for India'.

                                                                                                     ICT Skills-III  81

| 78 79 80 81 82 83 84 85 86 87 88 |