Page 249 - IT_Play_V1.0 Class9
P. 249

Step 7:  To insert the user-defined entries in the Lists box.
                 Step 8:  Click on the Ok button.

                                                 5





                                                         6


                                                                                                                       7









                                                                                                                       8



                    Recap Zone

                     Formatting a cell includes changing the contents of a cell with respect to appearance, i.e., Changing
                     text, Styles, Alignment, Font, Font style, Font size, Border, Patterns, etc.
                     The data present in the cell can be customized or formatted using the ‘Format Cells’ option.

                     Auto Fill is an additional feature in spreadsheet package like ‘LibreOffice Calc’ in which a certain kind
                     of pre-defined series of data such as name of months of a year, serial numbers, etc. are automatically
                     generated once the user feeds the initial data.



                                                            Exercise


                                                   Section A (Objective Type Questions)

                 A.  Multiple choice questions.
                    1.   To format a cell for a scientific number, which tab in the Format Cells dialog box is used?
                       i.  Alignment            ii.  Font               iii.  Numbers           iv.  Protection
                    2.  Which menu in LibreOffice Calc is used to access the Format Cells dialog box?
                       i.  Tools                ii.  Format             iii.  Insert            iv.  View
                    3.  What is the primary purpose of formatting data in a spreadsheet?
                       i.  Make it editable                             ii.  Enhance readability and presentation
                       iii. Protect data                                iv.  Perform calculations
                    4.  How do you apply Bold formatting in Excel?
                       i.  Press Ctrl + U       ii.  Press Ctrl + B     iii.  Press Ctrl + I    iv.  Press Ctrl + F
                    5.  Which alignment in LibreOffice Calc adjusts the column width to fit text?
                       i.  Center               ii.  Filled             iii.  Justified         iv.  Distributed
                    6.  What happens when the “Shrink to Fit Cell Size” option is selected?
                       i.  Font size is reduced to fit within the column width   ii.  Text is wrapped
                       iii. Content is rotated                          iv.  Data is removed



                                                                                   Format Data in the Spreadsheet   247
   244   245   246   247   248   249   250   251   252   253   254