Page 84 - IT-802_class_12
P. 84
6 Similarly, apply the operator AND to filter the Field Name of the student with the condition that it begins with
the Value set as G.
7 Click on OK. The output is displayed as:
Lab Assignment ‘n Activity Subject Enrichment
Create a worksheet and enter the names of your 10 friends and their marks in Hindi, English, and Math in separate
columns. Now, perform the following operations:
Ê ÐSort the records in ascending order of marks in English.
Ê ÐSort the records in alphabetical order according the names.
Ê ÐApply a filter to the Math column to retrieve the records of the friends who scored more than 80.
3.9 fORMUlAS
One of the most useful features of a spreadsheet package is that it enables us to do calculations on the data that is kept
in cells. Calculation is done by using formulas. A formula is entered to perform mathematical operations such as addition,
subtraction, multiplication, division, etc. A “Formula entry” in a cell is a logical entry. It also includes and shows the
relationship between different cells. In Calc or Excel, a formula always starts with an equal (=), plus (+), or minus (-) sign.
When a specific cell is selected, the formula applied to that particular cell can be viewed in the formula bar. The
Formulas in Calc include the following:
82 Touchpad Information Technology-XII

