Page 76 - Web Applications (803) Class 12
P. 76

At a Glance


                     •  ICT, or information and communication technology, has become an essential component of our daily lives.
                     •  A spreadsheet is a type of electronic document with rows and columns.
                     •  It is used to store data and perform calculations in a systematic manner.
                     •  A worksheet contains numerous cells arranged in rows and columns.
                     •  A cell is a rectangle-shaped box formed by the intersection of a row and column.
                     •  A row is a horizontal (sleeping) arrangement of cells.
                     •  A column is a vertical (standing) arrangement of cells.
                     •  A spreadsheet with one or more worksheets is referred to as a workbook.
                     •  Formulas can be entered in a cell or typed in the formula bar.
                     •  Each formula must begin with an ‘=’ (equal to) symbol.
                     •  Data stored in a spreadsheet can be used for calculations, graphical representation, and information display.
                     •  A function is a pre-defined formula that performs calculations with specific values in a specific order.
                     •  Calc has various functions to help you with your calculations like SUM, MIN, MAX, AVERAGE.
                     •  Presentation software is widely used to create digital presentations.
                     •  A presentation can be made interesting by including images, videos, animation, and music.
                     •  You can change the layout of the slide through the layout tab.



                                                           Exercise





                                                       Solved Questions

                                                 SECTION A (Objective Type Questions)
                    uiz

              A.  Tick ( ) the correct option.

                  1.  In Calc spreadsheet software,           are numbered from 1 and               are numbered from A
                     onwards.
                      a.  columns, rows                                b.  columns, spreadsheet
                      c.   rows, columns                               d.   rows, slides

                  2.  What is the value of the following formula:
                      =SUM(10,20,30,40)
                      a.  110                                          b.   100
                      c.   40                                          d.   Error

                  3.                is a collection of numerous rows and columns.
                      a.  worksheet                                    b.   slide
                      c.   workbook                                    d.   None of the above

                  4.  What is the keyboard shortcut of Paste?
                      a.  Ctrl + P                                     b.   Ctrl + C
                      c.   Ctrl + V                                    d.   Ctrl + X

                    74      Touchpad Web Applications-XII
   71   72   73   74   75   76   77   78   79   80   81