Page 289 - open office
P. 289

3.  Write about Walls & Floors.
                    Ans.  In a 3-D chart, the base area or the plane in  -  axis is called the  oor and the vertical areas i.e. planes in  -
                        and Y-Z axis are called walls.

                      4.  Explain the various vertical alignments.
                    Ans.  Bottom: The contents will be aligned towards the bottom side of the row.

                        Top: The contents will be aligned towards the upper side of the row.
                        Middle: The contents of the cell will be aligned in vertically-centered position.
                        Default: The contents will be aligned according to the default settings of the type of data being entered.

                      5.  Explain any four types of charts.
                    Ans.  i.  Column Chart: A column chart represents the data over a period of time in columns. Each column rises from
                           X-axis and indicates the value of a data. The measurement values are shown vertically as Y-axis.

                        ii.  Bar Chart: A bar chart represents the data in horizontal columns. The measurement of values are organised
                           horizontally. Stacked bar chart is a variation of bar charts.
                        iii.  Pie Chart: A pie chart represents the data or value of each item in proportion or percentage to the consolidated
                           or sum value of all items. Pie chart displays single type of data item and is beneficial when the user wants to
                           emphasize value of a significant item. Pie charts compare how each value relates proportionally to the whole.
                        iv.  X-Y (Scatter) Chart: X-Y (Scatter) chart displays the relationships among the numeric values of several
                           data series. This chart shows uneven intervals or clusters of data and is commonly used to represent
                           scientific data.

                      6.  Define Text Orientation.

                    Ans.  This option helps to rotate the direction of contents in a Cell. The user can either type the degree of angle of
                        rotation or drag the angle indicator and display the content in the required position.
                      7.  Explain Custom List.
                    Ans.  Calc  provides a feature to create a custom list where some series of names or text can be pre-defined and

                        displayed when the initial data is entered and AutoFill is applied. A user can create his own list as per his needs,
                        such as a list of a company s branch offices. After creation of the customized list, it can be used to fill in a range
                        of cells. In such a case, just enter the first name in the list and with the help of the auto fill feature, drag the
                        mouse  the pre-defined series will be displayed.

                      8.  Explain the advantages of drawing a chart in Calc.                              [CBSE Handbook]

                    Ans.    Charts are visually appealing and makes it easy for the users to compare and understand the information.
                          It helps to forecast the trends on the basis of comparisons done.

                      9.  Discuss any four terms used in a chart.
                    Ans.  Legend: It helps to identify the plotted data series. Unique colour or pattern is helpful to identify such series.
                        Gridlines: It refers to the horizontal and vertical lines in the plot area. The gridlines are inserted in the chart to
                        enhance its readability.

                        Data Label: It refers to the label that provides additional information about data marker, thus represents a
                        single data item or value of a cell.
                        Walls & Floors: In a 3-D chart, the base area or the plane in  -  axis is called the  oor and the vertical areas,
                        i.e. planes in X-Z and Y-Z axis are called walls.


                                                                                Formatting Cells in Spreadsheet     289
   284   285   286   287   288   289   290   291   292   293   294