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
   79   80   81   82   83   84   85   86   87   88   89