Page 287 - open office
P. 287

Solved Exercise


                                                                Section A
                                                        (Objective Type Questions)

                 A.  Multiple choice questions:

                     1.  If the data is of text type, it will be aligned towards .................................. If the data is of numeric type, it will be
                       aligned towards ..................................
                       i.  left, right                                        ii.  right, left
                       iii.  Both are aligned left                            iv.  None of these

                     2.  Which of the following options helps to rotate the direction of the contents in a Cell.
                       i.  Wrap Text                                          ii.  Shrink to fit Cell size
                       iii.  Text Orientation                                 iv.  None of these

                     3.  ................................. is an additional feature in spreadsheet in which a certain kind of predefined series of data are
                       automatically generated once the user feeds the initial data.
                       i.  Automatic Fill                                     ii.  Auto Fill

                       iii.  Wrap Text                                        iv.  Custom List
                     4.  Which of the following menu has ‘Cells’ option to apply formatting on cells?
                       i.  Home                                               ii.  Format

                       iii.  Edit                                             iv.  None of these
                     5.  Which of the following helps to forecast the trends on the basis of comparisons?
                       i.  Chart                                              ii.  Legends

                       iii.  Plots                                            iv.  None of these
                     6.  What helps to identify the plotted data series? Unique colour or pattern is helpful to identify such series.
                       i.  Data  abel                                         ii.   ridlines

                       iii.  Legend                                           iv.  Data series
                       ‘
                     7.  Calc’ provides a feature to create a ................................. where some series of names or text can be pre-defined
                       and then displayed when the initial data is entered and AutoFill is applied.
                       i.  Style                                              ii.  Wrap Text

                       iii.  Custom List                                      iv.  None of these
                     8.  The chart preview can be seen in ..................................              [CBSE Handbook]
                       i.  Page preview                                       ii.  Chart preview

                       iii.  Export chart                                     iv.  All of these
                     9.  Which of the following option reduces the font size of the data to accommodate it within the column width?
                       i.  Shrink to fit cell size                            ii.  Columns
                       iii.  Text Orientation                                 iv.  None of these







                                                                                Formatting Cells in Spreadsheet     287
   282   283   284   285   286   287   288   289   290   291   292