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

