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

