Page 225 - IT_Play_V1.0 Class9
P. 225

Recap Zone


                     A spreadsheet package is an application software that does analysis, calculations, comparisons and
                     displays information in the required format and in charts and graphs.
                     Rows are the set of rectangular boxes that are placed on top of each other in a horizontal position.
                     Columns are the vertical set of rectangular boxes that are placed adjacent to each other.

                     A rectangular box formed by the intersection of a row and column is called a cell.
                     The active cell in a spreadsheet is known as the Cell Pointer.
                     A group of cells is known as a cell range.

                     Each cell in the sheet has a unique address that is formed by the intersection of its column and row.
                     Navigator is a feature in LibreOffice Calc by which the cursor can be placed anywhere on a sheet
                     directly.



                                                            Exercise


                                                   Section A (Objective Type Questions)

                 A.  Multiple choice questions.
                    1.   What is the primary purpose of a spreadsheet application?
                       i.  To write articles                            ii.  To store images
                       iii. To perform calculations and display information   iv.  To create graphics
                    2.  Which menu in LibreOffice Calc contains commands like Open, Save, and Print?
                       i.  Edit                 ii.  View               iii.  File              iv.  Insert
                    3.  Which type of range includes cells A1 to A5 in a column?
                       i.  Horizontal Range     ii.  Vertical Range     iii.  Mixed Range       iv.  None of these
                    4.  What is the maximum number of columns available in a LibreOffice Calc's sheet?
                       i.  1024                 ii.  2048               iii.  10,48,576         iv.  256
                    5.  Which of the following is a valid cell address?
                       i.  1A                   ii.  A5                 iii.  5A                iv.  B2C
                 B.  State whether the following statements are true or false:
                    1.  A cell address is a combination of row number and column label.                        .......................
                    2.  Horizontal scroll bars help move the spreadsheet vertically.                           .......................
                    3.  A spreadsheet consists of multiple sheets by default.                                  .......................
                    4.  The Sidebar in LibreOffice Calc provides access to Properties and Functions.           .......................
                    5.  The cell A1 in a spreadsheet is always highlighted when a new sheet is created.        .......................

                                                                                                     21 st
                 C.  Assertion and reasoning questions.                                            Century   #Information Literacy
                                                                                                     Skills
                     The following questions consist of two statements – Assertion (A) and Reason (R). Answer these questions by
                    selecting the appropriate option given below:
                    i.  Both A and R are true and R is the correct explanation of A.
                    ii.  Both A and R are true but R is not the correct explanation of A.
                    iii. A is true but R is false.
                    iv. A is false but R is true.



                                                                                             Create a Spreadsheet   223
   220   221   222   223   224   225   226   227   228   229   230