Page 58 - TechPluse_C6_Flipbook
P. 58

5.   Which of the following commands in the Toolbar is used to set the text color in a cell?

                             a.    Font Color                            c.  Font
                             b.    Background Color                      d.  Color

                  B.    Write ‘T’ for true and ‘F’ for false.

                         1.   LibreOffice Calc is a spreadsheet application.                              ..........................
                         2.   We can format numbers in a cell.                                            ..........................
                         3.   The default row height is 0.75 cm.                                          ..........................
                         4.   AutoFill allows user to automatically fill a number or text series.         ..........................

                         5.   Two or more cells can be merged into one cell.                              ..........................

                  C.    Fill in the blanks using the words given below:
                                         Hints


                                                   create, merge cells, Calc, Tab Color, workbook


                         1.   .......................... allows you to organise data in the form of rows and columns.
                         2.   LibreOffice Calc is used to .......................... and manage business transactions that deal with
                             accounting.
                         3.   A .......................... is a collection of different worksheets.
                         4.   You can use .......................... option in the Format menu to combine two or more selected cells
                             into a single cell.
                         5.   We can change the color of a worksheet tab by using the .......................... option.

                  D.    Short answer type questions.
                         1.   What is a spreadsheet?

                             ...........................................................................................................................................................................
                         2.   What is a column?
                             ...........................................................................................................................................................................
                         3.   What is the function of the AutoFill feature?
                             ...........................................................................................................................................................................
                  E.    Long answer type questions.
                         1.   How will you insert data in a worksheet?
                         2.   How will you change the row height and column width?

                         3.   Write the steps to apply cell borders.


                                                         Mind Boggler



                  A.    Application based questions.                                                     Experiential Learning
                         1.   Sonia is preparing project details in a spreadsheet. Some text in a
                              cell is too long and get hidden when she types text in the adjacent cell on the right. How
                             can she change this?

               56       Premium Edition-VI
   53   54   55   56   57   58   59   60   61   62   63