Page 225 - CA_165_V2.0_C9_Flipbook
P. 225
21 st
Lab Assignment ‘n Activity Century #Technology Literacy
Skills
Complete the following activities and tick on the circles:
ª 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 a spreadsheet software, there are additional features that help to represent information in the form
of charts and graphs. A chart 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:
Element Description
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 Analysis 223

