Page 288 - open office
P. 288

10.  Which of the following option accommodates the text automatically within the column width by increasing the
                     row height?
                     i.  Merge Cells                                        ii.  Text Orientation
                     iii.  Wrap text                                        iv.  None of these
                  Ans. 1. i.             2. iii.           3. ii.            4. ii.             5. i
                  6. iii.                7. iii.           8. i.             9. i.            10. iii

              B.  Fill in the blanks.

                  1.  When the corresponding cell address changes with reference to a new cell address, it is known as
                     ................................. reference.

                  2.  ................................. is the heading text that helps to identify the chart.
                  3.  ................................. chart represents the data over a period of time in columns.

                  4.  Regular, Bold, Italic and Bold Italic are the types of ..................................

                  Ans. 1. relative       2. Chart Title                  3. Column             4. Font Styles

                                                              Section B
                                                     (Subjective Type Questions)

              A.  Answer the following questions:

                   1.  Write short notes on:
                      i.  Alignment                              ii.  Formatting Cells
                      iii. Charts                                iv.  Axis Titles

                 Ans.  i.  Alignment: The data in a cell gets aligned by default based on the type of the data entered. (If the data is of
                        text type, it will be aligned towards left. If the data is of numeric type, it will be aligned towards right).

                      ii.  Formatting Cells: Formatting a cell includes changing the contents of a cell with respect to the appearance,
                        i.e., Changing text, Styles, Alignment, Font, Font style, Font size, Border, Patterns, etc.
                      iii.  Charts: In a spreadsheet package, there are additional features that help to represent information in the
                        form of charts and graphs. It is a visual graphical representation of data from a worksheet that is very useful
                        for instant analysis of data and decision-making. There are various options of charts that can be used to
                        display in ‘Calc’ in graphical format.
                      iv. Axis Titles: It refers to the titles given to the three axis, i.e. X, Y and Z axis.
                   2.  Differentiate between:

                        i.  Wrap text and shrink to fit cells
                      ii.  Area chart and Line chart
                 Ans.  i.  Wrap Text: This option wraps the text in multiple lines to accommodate the text automatically within the
                        column width by increasing the row height.

                          hrin  to fit Cell si e: This option reduces the font size of the contents to accommodate it within the
                        column width.
                      ii.  Area Chart: An area chart is a version of a line or column graph. It is useful to emphasize the volume of
                        changes of data. Area charts have better visual impact than line charts.
                         Line Chart: Line chart is used to view information that is shown by lines at equal intervals. It depicts the
                        change in data over a period of time.


               288      Touchpad Information Technology-IX
   283   284   285   286   287   288   289   290   291   292   293