Page 69 - Web Applications (803) Class 12
P. 69

Applying Filters
                 Suppose you want to check data of those students who belong to the section ‘B’, then we can apply a filter—another
                 feature in Calc. This can be done as follows:
                 Step 1:   Select the data.
                 Step 2:   Click on Data   Autofilter. A drop-down icon will appear next to each column header.



























                 Step 3:    By default,  all values are  selected.  Click
                          on  the  ‘Section’  drop-down  and  select
                          the appropriate category from the drop-
                          down list.

                 The values will be filtered out for section ‘B’ only.

                 Adding a Password to the Spreadsheet
                 There are several ways to protect your spreadsheet from unauthorised access. One way is to add a password to open
                 your file. Password can be added by anyone of the following methods:
                 Click on tools   Protect Spreadsheet
                 OR
                 Click on File   Save As. In the Save As Dialog box, tick the ‘Save with Password’ option.

                 In both cases, you will be asked to add a password and also confirm the password.


                                 Brainy Fact


                      VisiCalc, the first spreadsheet program for personal computers, was released in 1979.  Dan Bricklin
                      and Bob Frankston created it for the Apple II computer.





                        Presentation Software


                 Presentation is a way of systematic display of information. It includes  pictures, texts, graphics, audios, videos  and
                 animated objects that are organised and presented in a proper sequence. With the advent of computers and development
                 of different types of presentation software, ideas or information can be presented in a more effective, efficient and
                 interesting way. There are a variety of presentation software available:
                                                                                                 ICT Skills-IV  67
   64   65   66   67   68   69   70   71   72   73   74