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

