Chapter - 8 Application Package

Chapter - 8 Application Package

Word Processor(MS-Word):
The software which is designed to create, edit and format textual matter like letter,
application, newspaper, book etc is called word processor.

Types of Word Processor:
There are numbers of word processor packages available today. Some of the popular word
processing packages are Microsoft Word, Open office write etc.

Features of Word Processor [Ms-word]:
a) File Management: This feature allows you for creating, typing, appending, saving
and opening document etc.
b) Formatting: This is related to character Formatting (Font, Color, size, spacing etc),
Paragraph Formatting (Alignment, Line spacing, Indentation etc), Page
Formatting(Margins, Paper-size, Orientation, border etc) and so on.
c) Editing: Operations such as copy, cut, paste, redo , undo, find and replace etc are
provided.
d) Table: Various operations related to designing a table such as creating, editing,
adding and removing rows and column, using formula for calculation, sorting data etc
are provided.
e) Printing: It comprises print preview, printing selected text, printing whole document,
specifying the number of copies, selecting paper size etc.

Spreadsheet Program(MS-Excel):
Concept and uses of spreadsheet:
At first, people used manual system to maintain the calculations sheets. It took so long time
to maintain and great problem arises when some change occur in any fields during the
calculation. Hence, the spreadsheet program developed.
The program that provide sheet of grid boxes (cells) set up in rows and columns are called
spreadsheet. These programs are called spreadsheet because the sheets are very large than
manual sheets.
In office Excel 2007, there are 16,384 columns and 10,48,576 rows.
In office Excel 2003, there are 256 columns and 65,536 rows.

Features of Spreadsheet Program:
Spreadsheet provides a lot of features. It is mainly used for data processing and calculations
of tabular data such as accounting. Some of the features of spreadsheet are as follows:
a) File Management: This feature is used to create, save, open documents.
b) Word Processing: This feature is used to type, change font, formatting text alignment,
cut, copy, paste etc.
c) Data Manipulation: This feature adds and deletes records, modify records, modify
records, search, sort data or present data in charts, pivot table etc.
d) Formula and Function: Different mathematical formula and built in functions like
SUM( ), AVERAGE ( ), MAX ( ) etc are available in spreadsheet.

Types of Spreadsheet:
There are various types of spreadsheet software such as Microsoft Excel, Open office.org
Calc, Lotus 1-2-3 etc available in the market. Among all those Microsoft Excel is one of
the most popular Spreadsheet Software. Microsoft Excel is developed by Microsoft
Corporation, USA.

Basic Fundamentals of Spreadsheet:
Workbook:
The collection of worksheet is called workbook. By default, there are 3 sheets (i.e. Sheet
1, Sheet 2 , and Sheet 3) in the workbook. The other sheets can be added later as our
required.
Worksheet:
The working area of a workbook as well as collection of cells where we perform
mathematical calculation is called worksheet.

Cell:
An intersection of the column and row with rectangular box shape, and holds the data we
have typed is called cell.
Cell Address:
Every cell in the Excel worksheet has a unique name which consists of column heading
and row number is called cell address. For Example: A1, A2 etc.

Cell Range:
The collections of two or more continuous cells in the worksheets are called cell range.
For Example: A1:A4, A1:A2 etc

Cell Reference:
It is the reference of cell address. There are 3 types of cell reference.
a) Relative Cell Reference
b) Absolute Cell Reference
c) Mixed Cell Reference

a) Relative Cell Reference
The cell reference which changes automatically when we copy the formula from one cell
to another, then it is called Relative Cell Reference. For Example: If the formula of cell
b) Absolute Cell Reference
The cell reference which remains unchanged when we copy the formula from one cell to
another, then it is called Absolute Cell Reference.
c) Mixed Cell Reference
It has a combination of both relative and absolute cell references. It has one absolute
coordinate and one relative coordinate. For example: A$1, $C3 etc.

Presentation Software:

Concept of Presentation:
“A picture is worth a thousand words”. Presentation is the practice of showing and
explaining the content of a topic to an audience or learner. A presentation is supposed to
help both : the speaker with an easier access to his ideas and the participants with visual
information which complements the task.

Features of a Presentation Software:
a) Presentation gives detail overview of the topic.
b) Audio-video can be merged on the single slide to clarify on specific topic.
c) It is easy to build from simple to interactive presentation.
d) It provides wide range of design, animation and other built in tools for easiness.
e) Presentation software provides 2D and 3D text editing and display facilities.

Types and uses of Presentation Program:
There are two types of presentation:
a) Static Presentation: The presentation program which runs without user interaction
from start to end is called static presentation. These types of presentation are used for
continuous description of any subject matter. The description on the subject matter
should be continuously, so that from starting to end could be played at once.
b) Interactive Presentation: The presentation which required the user interaction through
keyboard, mouse or any other devices to transmit from one slide to another slide is
called interactive presentation. These types of presentation are widely used in the field
of education and official presentation. On the slide description is required for the
clarification. The person who is presenting the presentation will describe about the
slide until it is not covered all the portion of the slide. Then only he goes to the next
slide for the same description. This control mechanism better gives by the help of
interactive presentation.

Slide: A single page of a presentation created with Microsoft PowerPoint is called a slide.
Animation: A visual effect applied to individual items on the slide is called animation.



Exercise:
1. What is word processor? Explain about footnote and endnote.
2. Write the uses of spreadsheet.
3. What is mail merge? Describe its major uses.
4. What is word processor? Explain about document formatting.
5. Explain the features and application areas of MS- Word.
6. What is spreadsheet? Define cell, cell address, cell reference, worksheet
and workbook.

7. What is application program? Explain features of application program.