Page 211 - CA 165 ver 1.0 Class 9
P. 211

Lab Assignment ‘n Activity                          Subject Enrichment



                    Complete the following activities and tick on the circle.
                    ª  Make a worksheet with following data:
                              Name          Department         Salary       Bonus       Gross Salary
                         Zeba              Accounts            40000        10000
                         Kanchan           Marketing           40000        15000
                         Ruby              HR                  80000        20000
                         Naveen            Accounts            60000        10000
                         Sam               Marketing           40000        15000
                         Syed              Finance             40000        20000


                    ª   Hide HR department from ‘Department’ and find gross salary of all employees by
                       using SUM function.
                    ª  Filter ‘Bonus’ where bonus amount is greater than 10000.



                   CHARTS AND GRAPHS

                 In spreadsheet package, there are additional features that help to represent information in the form
                 of charts and graphs. It is a visual or graphical representation of data from a worksheet which is very
                 useful for instant analysis and decision making. There are various options related to charts that can be
                 used to display data in ‘Calc’ in a graphical format.
                 Terms used in a chart

                 Following are the terms used in reference with a chart:

                   X-Axis               It is the horizontal axis known as category axis.

                                        It is the vertical axis and is known as value axis.
                   Y-Axis
                                        The X and Y axis divide the X-Y plane into four quadrants.
                   Data series          It is the set of values which the user wants to plot in the chart.

                   Chart Area           It refers to the total area surrounded by the chart.
                                        It is that area of the chart in which the data is plotted.
                   Plot Area            In a 2-D chart; axis bound the plot area whereas in 3-D charts, walls and floors
                                        bound the plot area.
                   Chart Title          It is the heading text that helps to identify the chart.

                   Axis Title           It refers to the titles given to three axis, i.e. X, Y and Z axis.

                                        It helps to identify the plotted data series. Unique colour or pattern is helpful
                   Legend
                                        to identify such series.
                                        It refers to the horizontal and vertical lines in the plot area. The gridlines are
                   Gridlines
                                        inserted in the chart to enhance its readability.




                                                                                                Data Analysis    209
   206   207   208   209   210   211   212   213   214   215   216