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

Lab Assignment ‘n Activity                           Subject Enrichment




                     Complete the following activities and tick on the circle.
                     ª  Enter the marks of 5 subjects and draw a Line chart and a Bar Chart for the subjects.
                     ª   The table below shows marks obtained by 50 students in Computer Class Test. Draw a
                        Column Chart (graph) based on the table.

                              Marks            3       4        5       6        7       8        9       10
                         No. of Students       1       3        4       8       12       10       9       3

                     ª  For the following data, draw a Pie Chart.

                             Item           Rent          Food           Cloth       Education        Misc
                         Expenses in%        15%           35%           10%            20%           20%






                      Recap Zone

                        Calculations are performed on cells on the basis of Cell Addresses mentioned, while writing the
                         formula.
                        Formula can be applied in reference to cell names. Name can be used directly in a formula.
                        Functions are in-built formula in ‘Calc’, which can be used to perform arithmetical and non-
                         arithmetical tasks.
                        The identification or address of a cell in a formula is known as ‘Cell Reference’. There are three
                         types of referencing in ‘Calc’ are relative, absolute and mixed referencing.
                        An operator is a symbol that performs certain mathematical or logical operations.
                        Functions are entered in a cell to produce the output of data.
                        List of errors which commonly occurs in ‘Calc’ are ####, #VALUE, #NAME, #NUM, #REF! and
                         #DIV/O!.
                        Sorting refers to the process of arranging data in ascending or descending order based on a
                         certain criteria.

                        Filtering is a quick and easy way to get required information from the subset of data in a range
                         of cells.

                        If the user does not want to show columns or rows that contain some part of data on the
                         screen, it can be hidden with the help of ‘Hide’ feature.

                        Charts and graphs are visual or graphical representation of data from a worksheet which is
                         very useful for instant analysis and decision making.
                        Based on the same data, a user can easily switch from one type of chart to another.











                   214    Touchpad Computer Applications-IX
   211   212   213   214   215   216   217   218   219   220   221