MS – OFFICE 2007

INTRODUCTION
MS-Office 2007 help us to produce professional looking document by providing
a set up tools for creating and formatting our document in the new MS-Office
user interface. Advance data and decreation ensure that document stay
connect to important source of business information. Ms-office was first
introduced by Bill Gates on August 1st 1988.

Advantages of MS-Office 2007

MS-Office is a word processor programme. The 2007 edition called Ms-Office
2007, which offers many features that depart from the previous 2003 edition.
This feature includes new file types, a different GUI. This feature and more are
some of the advantages updating our system from 2003 to 2007.

Features
(1) Ribbon:-
Ribbon is the user interface in Ms-Office 2007. It is a major difference between
this version and previous version of the word processor in the 2003 edition and
current version of the word processor. In 2003 edition there are many different
menu to scroll and click through to find some of the more complex task of the
problem. The ribbon interface provide tools and Icon that make finding those
function take few ever click and less time.

(2) Template and Themes:-

The program comes with 100 of templates that were not available in previous
version. In this edition there are a 100 of templates located through the
program. The building block tools in word 2007 can also help to built a
template quickly from the document component like slide bar, cover page etc.

(3) File compatibility: -

Ms-office 2007 is more compatible with other files type then the
previous edition. In the program we can save a word document into a portable
document format.

Example -PDF or XML paper specification without using any software.

Page | 1
(4) Safety:-
There are many new security features available with 2007 that can help to keep
your document safe. The MS-Office documents check your files to ensure that
they are not the unwanted or hidden component hide in your document. This
will ensure that we have receive from editor or notes that a client was not
supported to see.

(5) File size & stability:-

The structure of ms-office – 2007 has been changed to make file size smaller
and more stable. These file formats are inform by XML (Extend Markup
Language) files, that more compact, saving disk space on hard drive or server.
The way that the files are store has been after change in storage to separate
document instead of one document .

Ms-Office word-2007:-
It was develop by Microsoft and was first announced by Bill gates on 1 Aug
1988. Ms-office word is a versatile word processing program that offer
flexibility in correcting and revising our work as well as a number of stylist
option to improve your document presentation. This quick tip will teacher us
how to change the overall layout of a word document and use built an
application is ms-word.

Features of MS-Word -
i) Use templates and create a new document.
ii) Change page margin and paragraph spacing.
iii) Insert page number.
iv) Add header and footer.
v) Use the autocorrect.
vi) Use the margin on ruler.
vii) Add tables
viii) Insert image
ix) Use the keyboard shortcut key
x) Use word mail merge feature

Word Processing:-
Computer were first develop to program for arithmetic operation such as
adding and subtracting. In other words to process number however a computer

Page | 2
could also be very useful in manipulating text to produce documents such as
class notes, letters and other written text. Not only to computer process
numbers they could also process word. Now this application used on personal
computer.

Today most word processor combines the editor and formatter in such a way
the document is WYSIWYG (What you see is what you get). We see on the
screen a page like a page of our document as we type whatever formatting
instruction we have given. Such as margin, spacing, font size, bold and Italic.
Two types of WYSIWYG word processor are
I) Word perfect 7 and
II) MS – Word 2007

Feature of Word processing:-

(i)Word wrap:
One feature of word processing is word wrap processor which allow us to type
continuously without thinking about where one line will end and the next one
begin on like a type writer which require use to press a return bar to begin a
new line.
A word processor does this automatically. As we near to the end of a line, the
computer determines whether the word we are typing is extending beyond the
margin, if so it hunts backwards until it find a separate space or a hyphen(-).

(ii)Deleting text:
Word processor allow us to make correction by deleting characters, entire word
of large block of text which we have selected, the delete key and back space
key are used for this purpose.

(iii)Inserting text:
If we insert a wrong text and we want to enter the right one then the word
processor in computer. We can simply move the insert point to the proper place
and insert the text.

(iv)Spelling check:
A word processor can even check our spelling. In some version we must
specified request that, this be done however in words as a type of computer we
can then correct each ourselves or ask the computer to help us to find the
correct spelling.

Page | 3
(v)Appearance:
Like a type writer a word processor gives us many choice of type face, we can
also adjust the size of the character and choose to print some character in Bold
face, Italic, underline, etc.

(vi) Tables:
With a word processor we can create an attractive table according to our need.
We can adjust the size and number of rows and columns, the style of separate
lines and borders.

(vii)Alignment:
We can align text in various way as we type; like left, right, center, justify.
Generally the text can be automatically centered by a word processor.

(viii)Indent:
We can indent (left or right) the first line of a paragraph or the entire
paragraph. We can create hanging indent where all lines of a paragraph are
indented, except the first one.

How to start MS – Word?

Step:-
 Click on Start button
 Click on All program
 Click on Microsoft office
 Click on Microsoft office word 2007

Page | 4
Title bar –
It appears on the top of the window and it displays the program name,
minimize, maximize and close button.
It is consist of the quick access tool bar (left side).
Quick access tool bar –
It provides access to commonly used commands such as save, undo, redo, etc.

Tabs –
Tabs are display just below the title bar. Basically there are 7 tabs found in MS
word. i.e.
1) Home
2) Insert
3) Page layout
4) References
5) Mailings
6) Review
7) View

Ribbons –
Each of the tabs consists of a ribbon which contains various groups and its
commands. Like clipboard group, font group, paragraph group, etc.
Working area –
It refers to the area where we can do our work in the Microsoft word.

Status bar –
It appears just below the scroll bar and it displays the view, tool bar and zoom
button.

Scroll bar –
Scroll means move. There are two types of scroll bar,
i.e., i) Horizontal scroll bar (left – right)
ii) Vertical scroll bar (Top – bottom)

Office button:-
It is a button indicates the MS-Word logo. It includes new, open, save, save as,
print preview, or exit.

Home Tab –

Page | 5
Clipboard group
Cut -
Using this option user can cut the select data.
Step
 Select the data
 Go to home tab
 Go to clipboard group
 Click on cut

Copy -
This option is allow us to copy the selected data.
Step
 Select the data
 Go to home tab
 Go to clipboard group
 Click on copy

Paste -
It will paste the cut or copy line.
Step
 Select or cut or copy the line
 Go to home tab
 G to clipboard group
 Click on paste

Format painter -
It enables us to format your picture and text.
Step
 Copy and paste a line or paragraph
 Change the format of the first line or record using font, font size, bold,
Italic, font color etc.
 Select the format line and click on format painter.
 Select another line or text.

Font group
Font family -
It enables us to choose font style from the different type of font available for
our document.
Step
 Select the data

Page | 6
  Go to home
 Click on font style
 Choose your font style
Font size -
Using this option user can change the font size.
Step
 Select the data
 Go to home tab
 Go to font group
 Click on font size
 Choose your font size
Bold -
It makes the text much thick in size.
Step
 Select the data
 Go to home tab
 Go to font group
 Click on bold
Italic -
It makes your text Italic.
Step
 Select the data
 GO to home tab
 Go to font group
 Click on Italic
Underline-
It will makes underline the select record.
Step
 Select the data
 Go to home tab
 Go to font group
 Click on underline
Grow font -
It will grow the font of the select record.
Step
 Select the line
 Go to home tab
 Go to font group
 Click on grow font

Page | 7
Shrink font-
It will shrink the font of select record.
Step
 Select the data
 Go to home tab
 Go to font group
 Click on shrink font
Strike through-
It will strike through the select record.
Step
 Select the data
 Go to home tab
 Go to font group
 Click on strike through
Subscript -
It makes the highlighted text become to the subscript.
Step
 Select the record
 Go to home tab
 Go to font group
 Click on subscript
Superscript-
It makes the highlighted text become to the superscript.
Step
 Select the record
 Go to home tab
 Go to font group
 Click on superscript
Change case-
It change your sentence either in upper case, lower case, sentence case,
capitalize case, toggle case.
Step
 Select lines
 Go to home tab
 Go to font group
 Click on change case
 Choose your suitable case
Text highlight color -
It will display the text highlight color.
Step

Page | 8
  Select line
 Go to home tab
 Go to font group
 Click on text highlight color
Text color -
It will display the text color.
Step
 Select the data
 Go to home tab
 Go to font group
 Click on text color
Clear formatting -
It will clear the formatting
Step
 Select the record
 Go to home tab
 Go to font group
 Click on clear formatting

Paragraph group
Bullet -
It start a bullet style.
Step
 Select the data
 Go to home tab
 Go to paragraph group
 Click on bullets
 Choose your bullet design
Numbering-
It start a number list.
Step
 Select the paragraph
 Go to home tab
 Go to paragraph group
 Click on numbering
 Choose your numbering design
Multilevel list -
It display multilevel list.
Step
 Select the data

Page | 9
  Go to home tab
 Go to paragraph group
 Click on multilevel list
 Choose your multilevel list
Indent-
Increase indent -
It increase the indent level of the paragraph.
Step
 Select paragraph
 Go to home tab
 Click on increase indent
Decrease indent -
It decrease the indent level of the paragraph.
Step
 Select paragraph
 Go to home tab
 Click on decrease indent

Sort -
It is alphabetical the select data in ascending order or descending order.
Step
 Select the paragraph
 Go to home tab
 Click on sort
 Arrange the order
Show or hide -
It show paragraph and display other hidden formatting symbol.
Alignment -
There are four types of alignment.
(1) Left (3) Center
(2) Right (4) Justify

Step
 Select the paragraph
 Go to home tab
 Go to paragraph group
 Choose alignment
Line spacing-
A change the space between line of the text.
Step

Page | 10
  Select the paragraph
 Go to home tab
 Click on line spacing
 Choose your suitable line spacing
Shading color-
It colors the background behind the select data.
Step
 Select the paragraph
 Go to home tab
 Click on shading color
 Choose your color
Bottom border-
It display a border in the bottom of the paragraph.
Step
 Select the paragraph
 Go to home tab
 Click on bottom border

Style group
Change style -
It change style of the paragraph.
Step
 Select the paragraph
 Go to home tab
 Click on change style
 Choose your style

Editing group
Find(Ctrl+F) -
It search a word, character, lines. It allow to located file or folder on your
computer.
Step
 Go to home tab
 Click on find
 Type your desire character, word or lines.
 Click on find
Replace(Ctrl+H) -
It replace the search word is called replace.
Step
 Go to home tab

Page | 11
  Click on replace
 Type your word in the replace box.
 Click on replace
Select all(Ctrl+A)-
Select all, select object, select text or object in the document.
Step
 Go to home tab
 Click on select
 Choose desire option

Insert Tab –
Pages group :-
Cover page
It insert a fully formatted cover page. In this cover page we will fill the title,
author, date, time etc.
Step
 Go to insert tab
 Click on cover page
 Select your cover page
 Type your record
Blank page
It insert a new blank page.
Step
 Go to insert tab
 Go to pages group
 Click on blank page
Page break
It start a new page at the required position.
Step
 Go to insert
 Go to pages group
 Click on page break

Table group :-
In this option user can create and insert table in the document.
Step
 Go to insert
 Click on table

Page | 12
We can draw a table using several options. Such as insert table, draw table,
excel, spreadsheet, quick table etc. When we insert a table it display another
two tabs that are design and layout.
Design tab –

Table style option group:-

(1) Header row
(2) Total row
(3) Banded row
(4) First column
(5) Last column
(6) Banded column

Table style group:-

Shading
It colors the background behind the select text or paragraph.
Border
It customizes the border of the select cell.

Draw border group :-

Line style
It change the style of the line use to draw border.
Step
 Go to design tab
 Click on line style
 Select your suitable line style
Line width
It change the width of the line use to draw border.
Step
 Go to design tab
 Click o line width
 Choose your desired form
Pen color
It change the pen color.
Step
 Go to design
 Click on pen color
 Choose your pen color

Page | 13
Draw table
It draws the border on the table.
Step
 Go to design tab
 Select the above option(line style, line width, pen color)
 Click on draw table
 Draw the table
Eraser
It erases the border of the table.
Step
 Go to design tab
 Click on eraser

Layout tab –

Table group :-
Select option
(1) Select cell
(2) Select column
(3) Select row
(4) Select table

Properties
It allow us to set the properties of table like (alignment, text wrapping)

Row and column group: -

(1) Delete
(2) Insert above
(3) Insert below
(4) Insert left
(5) Insert right

Merge group :-
Merge cell
It will merge the select cell into one cell.
Step
 Select the cell
 Go to layout tab
 Click on merge cell

Page | 14
Split cell
It will split the selected cell.
Step
 Select the cell
 Go to layout tab
 Click on split cell
 Type the row and column
 Click on OK
Split table
It will split the table.
Step
 Go to layout tab
 Click on split cell

Cell size group:-

Height
It set the height of the selected cell.
Step
 Go to layout tab
 Click on height
 Set the height

Width
It set the width of the selected cell.
Step
 Go to layout tab
 Click on width
 Set the width
Auto fit
1. Auto fit contents
2. Auto fit window
3. Fixed column width
Distribute Row
Distribute Column

Alignment group :-
Text direction
It change the text direction within the selected cell.
Step
 Select the cell

Page | 15
  Go to layout tab
 Click on text direction
 Choose the text direction
Cell margin
It customize the cell margin and spacing between the cell.
Step
 Select the table
 Go to layout tab
 Click on cell margin
 Arrange your requirement
Data group :-
Sort
It alphabetically the selected text or sort numeric data.
Step
 Select the column
 Go to layout tab
 Click on sort
 Select the order
Sort
It will alphabetically arrange the content of the table.

Formula
It add a formula to a cell to perform a simply calculation such as total, average
etc. Total = sum(left)
Average = Avg(left)
Step
 Select a cell
 Go to layout tab
 Click on formula
 Type - = Sum(left)
 Click on OK
Repeat header Row
Convert to text

Illustration group:-
Picture option
Using this option user can insert picture from existing file.
Step
 Go to insert tab
 Click on picture

Page | 16
  Choose picture
 Click insert

Format tab

Adjust group :-
Brightness
It will set the brightness of the picture.
Step
 Select the picture
 Go to format tab
 Click on brightness
Contrast
It will set the contrast of the picture.
Step
 Select the picture
 Go to format tab
 Click on contrast
 Choose your contrast
Recolor
It will set the color of the picture.
Step
 Select the picture
 Go to format tab
 Click on recolor
 Choose your color
Change picture
It will change the select picture.
Step
 Select the picture
 Go to format tab
 Click on change picture
 Choose your picture
Reset picture
It will reset the selected picture.
Step
 Select the picture
 Go to format tab
 Click on reset picture
Page | 17
Picture Style group :-
Picture shape
This option allow us to change the shape of picture.
Step
 Select the picture
 Go to format tab
 Click on picture shape
 Choose the picture shape
Picture border
This option allows us to give the border of the picture.
Step
 Select the picture
 Go to format tab
 Click on picture border
Picture effect
It apply a visual effect to the picture such as shadow, reflection, glow or 3D
rotation.
Step
 Select the picture
 Go to format tab
 Click on picture effect

Arrange group :-
Position
It will display the position of the shape.
Step
 Select the picture
 Go to format tab
 Click on position
Text wrapping
It set the text position with a picture such as in line with text, square, tight,
behind text, in front of text, top and bottom, through etc.
Step
 Select the picture
 Go to format tab
 Click on text wrapping
 Select the position of the text
Bring to font
Step

Page | 18
  Click here
 Bring the selected object infront of all other show that part of this hidden
behind another object.
Send to back
 Click here
 Send the selected object behind all other objects.
Align
In align the text in multiple selected object left, center, right, top, middle,
bottom etc.
Step
 Select the picture
 Click on align
 Choose the position
Rotate
It rotates or flip the selected object.
Step
 Select the object
 Click on rotate
 Choose the rotating
Group
It will group our picture.

Size group :-
Crop
Using this option we can crop the picture.
Step
 Select the picture
 Go t format tab
 Click on crop
Shape height
Using this option we can set of the height of the picture.
Step
 Select the picture
 Go to format tab
 Click on shape height
Shape width
Using this option we can set the width of the picture.
Step
 Select the picture
 Go to format tab

Page | 19
  Click on shape width

Clip art option

Using this option user can insert clip art into the document.
Step
 Go to insert tab
 Click on clip art
 Search the picture in the task pen.

Fomat tab
Same as format tab of picture option in illustration group.

Shape option
Using this option user can insert ready-made shape like line, circle, rectangle
etc.
Format tab –

Insert shape group :-

Insert shape
We will insert variety of shape.
Edit text
Using this option user can edit on the insert shape.
Step
 Select the shape
 Go to format tab
 Click on edit text
 Type your text

Shape style group

Shape fill
Using this option we can fill the color of the shape.
Step
 Select the shape
 Go to format tab
 Click on shape fill
 Select your fill color
Shape outline
It will give the outline of the shape such as weight pattern.
Step

Page | 20
  Select the shape
 Go to format tab
 Click on shape outline
Shape change
Using this option we can change the insert shape.
Step
 Select the shape
 Go to format tab
 Click on shape change

Shadow effect group

Shadow effect
Using this option we can give the shadow effect of the shape.
Step
 Select the shape
 Go to format tab
 Click on shadow effect

Nudge shadow up
Nudge shadow down
Nudge shadow right
Nudge shadow left

3D effect group :-
3D effect
It will display the 3D effect of the shape.
Step
 Select the shape
 Go to format tab

Till up
Till down
Till left
Till right

Arrange group
Size group

Smart art
It will insert a smart art graphics to visually communicate information.

Page | 21
Step
 Go to insert tab
 Click on smart art
 Choose the smart art style
 Click on OK

Design tab

Create graphic group: -

Add shape
Add bullet
Right to left
Layout
Promote
Demote
Text pane

Layout Group

Smart art style group: -

Change color

Reset group: -
Reset graphic

Format tab

Shapes group: -
Edit in 2D
Change shape
Larger
Smaller

Shape style group: -

Shape fill
Shape outline
Shape effect

Page | 22
Word art style group: -
Text fill
Text outline
Text effect

Arrange group
Size group

Chart
It inserts a chart to illustrate and compare data. There are various types of
chart available, such as line, pie chart, bar, area and surface chart.

Links group:-
Hyperlink
It creates a link to web page or a document with the current document.
Step
 Select your record
 Go to insert
 Click on hyperlink
 Link the record to any document
 Right click on the record
 Click on hyperlink
 Click on open hyperlink
 Click on remove hyperlink
Bookmark
It create a bookmark to assign a name to specific point in a document.
Step
 Open more than one page and insert some data
 Select the page and write a record
 Go to insert tab
 Click on bookmark
 Give the bookmark name
 Click on add
 Go to another page
 Click on bookmark
 Click on go to button

Header and footer group :-

Header

Page | 23
Using this option user can edit the header of the document. The content of the
header will appear at the top each printed page.
Step
 Go to insert tab
 Click on header
 Choose your suitable header
Footer
Using this option user can edit the footer of document. The content of the
footer will appear the bottom of each printed page.
Step
 Go to insert
 Click on footer
 Choose your suitable footer
Page number
Using this option user can insert the page number into the document.
Step
 Go to insert
 Click on page number

Header and footer group: -

Header
Footer
Page number
Insert group:-
Date and time- Using this option we can insert the date and time.
Picture - Using this option we can insert picture.
Clip art - Using this option we can insert the clip art.
Navigation group: -
Go to header
Go to footer
Previous section
Next section
Option group
Different first page
Different odd and even page
Show document text
Position group
Header from top
Footer from bottom
Page | 24
Text group :-
Text box
This option is allow us to insert the preformatted text box.
Step
 Go to insert tab
 Click on text box
 Choose your suitable text box

Format tab –

Insert shape group :-

Insert shape
We will insert variety of shape.
Edit text
Using this option user can edit on the insert shape.
Step
 Select the shape
 Go to format tab
 Click on edit text
 Type your text

Shape style group

Shape fill
Using this option we can fill the color of the shape.
Step
 Select the shape
 Go to format tab
 Click on shape fill
 Select your fill color
Shape outline
It will give the outline of the shape such as weight pattern.
Step
 Select the shape
 Go to format tab
 Click on shape outline
Shape change
Using this option we can change the insert shape.
Step
 Select the shape

Page | 25
  Go to format tab
 Click on shape change

Shadow effect group

Shadow effect
Using this option we can give the shadow effect of the shape.
Step
 Select the shape
 Go to format tab
 Click on shadow effect

Nudge shadow up
Nudge shadow down
Nudge shadow right
Nudge shadow left

3D effect group :-
3D effect
It will display the 3D effect of the shape.
Step
 Select the shape
 Go to format tab

Till up
Till down
Till left
Till right

Arrange group
Size group

Word art: -
This option is allow us to insert decorative text in our document.
Step
 Go to insert tab
 Click on word art
 Type your text
 Click on OK

Page | 26
Text group: -
Edit text – using this option we can edit text.
Step –
 Go to format
 Click on edit text
 Type your text
 Click on ok
Spacing- using this option user can change the spacing between the letters of
the text.
Step –
 Go to format
 Click on spacing
 Choose your spacing
Even height – It make all the letter exactly the same height.
Step
 Go to format click on even height
Vertical text – using this option we can vertically design the text.
Step –
 Selected the text
 Go to format
 Click on vertical text
Word art style group
Shape fill
Shape outline
change shape
Shadow effect group
Shadow effect
Using this option we can give the shadow effect of the shape.
Step
 Select the shape
 Go to format tab
 Click on shadow effect

Nudge shadow up
Nudge shadow down
Nudge shadow right
Nudge shadow left

3D effect group :-
3D effect

Page | 27
It will display the 3D effect of the shape.
Step
 Select the shape
 Go to format tab

Till up
Till down
Till left
Till right

Arrange group
Size group

Drop cap :-
It will create a large capital letter at the beginning of the paragraph.
Step
 Select the record
 Go to insert tab
 Click on drop cap
 Choose your suitable drop cap
Signature line
It insert a signature line that specified the individual who must sign.
Step
 Go to insert
 Click on signature line
 Click on OK
 Enter your data
 Click on OK
Date and Time
It insert the current date and time into the document.
Step
 Go to insert
 Click on date and time
 Choose your suitable date and time format
 Click on OK
Object
It will insert an object.
Step
 Go to insert
 Click on object

Page | 28
  Choose your document
 Click on OK

Symbols group:-
Equation
Using this we can insert the syntax of an equation.
Step
 Go to insert
 Click on equation
 Choose your suitable equation
Symbols
It will insert symbol that are not in our keyword.
Step
 Go to insert
 Click on symbol
 Choose your suitable symbol

Page Layout Tab –

Themes group:-
Themes
Change the page theme.

Color
Change the page color.

Font
Change the font.

Effect
It insert a page effect.

Page setup group :-

Margin
It selects margin sizes for the entire document or the current section.
Step
 Go to page layout tab
 Click on margin
 Select your margin
Orientation
It switch the page between portrait and landscape layouts.

Page | 29
Step
 Go to page layout tab
 Click on orientation
 Choose your suitable orientation
Size
Using this option user can choose paper size.
Step
 Go to page layout tab
 Go to page set up group
 Click on size
 Choose your suitable size
Columns
It split the text into two or more column.
Step
 Select the paragraph
 Go to page layout tab
 Go to page set up group
 Click on column option
 Select your suitable column
Breaks
Using this option user can break the page.
Step
 Go to page layout tab
 Go to page set up group
 Click on break
Line numbers
It add line number in the margin along side of each line in the document.
Step
 Go to page layout tab
 Go to page set up group
 Click on line number
Hyphenation
It turn on hyphen which allow word to break line between the specific of word.
Step
 Go to page layout tab
 Go to page set up group
 Click on hyphenation

Page background group :-

Watermark

Page | 30
It insert text behind the content on the page.
Step
 Go to page layout tab
 Go to page background group
 Click on watermark
 Choose your suitable watermark
Page color
It apply the background color of the page.
Step
 Go to page layout tab
 Go to page background group
 Click on page color
 Choose your suitable page color
Page borders
It apply or change the border of the page.
Step
 Go to page layout tab
 Go to page background group
 Click on page borders
 Choose your suitable border

Paragraph group :-
Indent
There are two types of indent.
1.Left indent
2.Right indent

1.Left Indent
Using this option we can set the margin of the left size of the page.
Step
 Go to page layout tab
 Click on right indent or click on left indent
 Arrange your indent
2.Right indent
Using this option we can set margin of the right side of the page.
Step
 Go to page layout tab
 Click on right indent or click on left indent
 Arrange your indent

Page | 31
Spacing
Using this option we can arrange the space between the paragraph. There are
two types of spacing.

Before spacing
Using this option we can arrange the spacing before the paragraph.

After spacing
Using this option we can arrange the spacing after the paragraph.
Step

 Go to page layout tab

 Click on after or before spacing
 Arrange your suitable spacing

Mailing Tab –
Mail merge-
Using this option we can send a message to more than one user with there field
name such as, name, address, phone number etc. At a time commands- create,
start, mail merge, write and insert field, review result, finish.
Step
 Click on start mil merge
 Click on step by step mail merge wizard
 Double click on the next button
 Click on type a new list
 Click on create
 Click on customize button
 Delete record
 Click on add
 Enter your file name and click on OK
 Enter your record and click on OK button
 For new column click on new entry
 Save your file name and click on save
 Click on close button
 Click on next write your letter
 Click on insert merge filed
 Insert your field name
 Click on preview result or click on next record
 Click on finish
Page | 32
  Click on individual document
 Click on OK

Review tab –
Proofing group :-
Spelling and grammar
It will check the spelling and grammar of the document.
Step
 Go to review
 Click on spelling and grammar checking
 Select the appropriate solution
 Click on change
Word count
It will count the page, words, character, paragraph etc.
Step
 Go to review tab
 Click on word count
Research - it will research a particular word. That means it will display the
meaning of a particular word as a noun, verb and adjective.
Thesaurus - It will suggest other word with a similar meaning to the user.
Translate
Language

Comment group:-
New comment
Delete
Previous
Next

Tracking group :-
Track changes
It will display any change in your document with date and time.
Step
 Select your record
 Go to review tab
 Click on track changes

Changes group: -
Accept
Reject

Page | 33
Previous
Next

Protect group :-
Protect document
It will protect your document.
Step
 Go to review tab
 Click on protect document
 Click on formatting and editing
 Click on editing registration
 Click on start enforcement
 Type your password for two times
 Click on OK

View tab –
Document view group :-
Print layout
It view the document as it will appear on the printed page.
Step -
 Go to view tab
 Click on print layout

Full screen reading

It display the document in full screen.
Step
 Go to view tab
 Click on full screen reading
 To close the full screen click on close button

Web layout
View the document as it will appear on web page.
Step
 Go to view tab
 Click on web layout

Show or hide group :-

Ruler
It will display the margin of the document.
Step

Page | 34
  Go to view tab
 Click on ruler for display
 Again click for hide

Gridlines
It will hide and show the gridline bar.
Step
 Go to view tab
 Click on gridlines for display
 Again click for hide

Document map
It will display document map of your document.
Step
 Go to view tab
 Click on document map

Thumbnails
It will navigate a long document through small pictures of each page.
Step
 Go to view tab
 Click on thumbnails

Zoom group :-
Zoom
It will zoom your page.
Step
 Go TO view tab
 Click on zoom button

100%
It will zoom your page in 100%.
Step
 Go to view tab
 Click on 100%

One page
It zoom the document that one page fit in the window.
Two page
It zoom the document show that two page will fit in the window.

Page | 35
Page width
It will set the page width.
Step
 Go to view
 Click on width

Windows group :-
New window
It will display a new window.
Step
 Go to view tab
 Click on new window
Arrange all
It will arrange all the window in one screen.
Step
 Go to view tab
 Click on arrange all
 Click on OK

Split window
It will split your window.
Step -
 Go to view tab
 Click on split

Macros group :-
Macro
Step
 Go to view tab
 Click on macro
 Click on record macro
 Type the macro name
 Click on keyboard
 Give your shortcut key using Alt or Ctrl
 Click on OK or Close
 Type something in your document and format the document without
selection
 Click on stop recording from macro commands
 Type your shortcut key

Page | 36
Microsoft Office Excel –
Microsoft Excel is a window based package in Microsoft office group.
Excel is mainly used for calculation. Whole information in excel is stored in the
form of tables. It is easy to understand or compare data stored in form of
tables. It is difficult to do page to page plain typing in Excel. Using Excel we can
create student mark sheet, employee salary sheet, purchase and sales report,
accounting statement etc.
Microsoft excel is an electronic spreadsheet program. It is powerful and easy to
use application. Spreadsheets are used for performing calculation, projecting,
estimated result, recalculating data. It helps us to enter data and understood
the trend of data changes. It can perform simple as well as complex
mathematical calculation.

Benefits of using spreadsheet: -

1. Data can be manipulated number of times.
2. In build mathematical function for analysis.
3. Data can be represented which is easy to understand.
4. Helpful for calculation etc.

How to open Ms – Excel:-

Click on start button
Click on all programs
Click on Microsoft office
Click on Microsoft office excel
MS-Office Excel Screen :-

Page | 37
Components of MS – Excel screen :-
1) Quick access tool bar
2) Title bar
3) Menu bar or tab bar
4) Ribbon

Formula bar-While performing calculation in excel cell formula is tight.

Result is display in cell but the formula is seen on formula bar on left side of bar
name box is displayed. Active cell address is shown in this box. It has two sides.
On the left side it display cells address and on the right side it display the
contain of a cell.

Work sheet -A grid of rows and columns are displayed below the
formula bar. This grid is called work sheet. We can create table in this sheet.
A workbook is an excel file that stores information that we enter. Each
workbook is contain in many sheets so we can organized various kinds of
related information in a single file.
A worksheet also commonly refers to as a spreadsheet. It is a regular grid of
rows and column used to enter data. There are many pages in a work sheet.
Whole work sheet can’t be printed A4 or letter size paper.

Status bar:- A horizontal bar which can display the current status of active
screen is the status bar.

Move around a worksheet :-

By using the arrow keys, we can move around the worksheet. Worksheet is the
collection of rows and columns. Every sheet contains 16384 column and
1048576 rows. Every column has got a heading columns start from A, B,
C………Z, AA, AB… Rows are numbered from 1 to 1048576 on each sheet.
Office button :-
a. New - This option is allow us to create a new sheet on the screen.
b. Open - This option is allow us to open the existing file of the document.
Step –
Go to office button
Click on open
c. Save -This option is allow us to save the recent file.
Step –
Go to office button
Click on save

Page | 38
d. Save as - This option is allow to save as the current document.
Step –
Go to office button
Click on save as
e. Print -Convert soft copy to hard copy.
f. Print preview -Set the print section before the printing.
g. Exit- Close the current program.

How to count total?

Total :
 = sum (1st cell address : last cell address) 
 Example : = sum (B1 : C1) 
Minimum :
 = min (1st cell address : last cell address) 
Maximum :
 = max (1st cell address : last cell address) 
Average :
 = avg (1st cell address : last cell address) 
Percentage :
= secure mark / total mark * 100
Home tab –
Clip board group:
Cut – it will cut the selected dat.
Copy – It will copy the selected data
Paste - It will paste the data
Format painter- It will copy the format.

Font group:
Font family
Font size
Bold
Italic
Underline
Grow font
Shrink font
Text color
Text highlighted color
Border -It displays a border in the bottom of the paragraph.
Step –
Page | 39
  Select the data
 Go to home
 Click on bottom border

Alignment group:
Top alignment:
It is use to data can be move top position.
Middle alignment:
It is use to data can be move middle position.
Bottom position:
It is use to data can be move bottom position.
Left alignment:
It is use to data can be move left side.
Right alignment:
It is use to data can be move right side.
Center alignment:
It is use to data can be move center.

Wrap text:
In this option use to over flow text converts to one cell.

Merge cell:
Using this option we can convert the selected cell into one cell.
Step –
 Select the cell
 Go to home tab
 Click on merge cell

Number group:
Using this option we can arrange different option like general number, time,
date, percent, etc.
Step –
 Select the table
 Go to home tab
 Click on number format
 Choose your format

Style group:
Conditional formatting:

Page | 40
Using this option we can highlight your select record, according to your
condition.
Step –
 Select the record
 Go to home tab
 Click on conditional formatting
 Click on highlighted cells rule
 Select your condition and give the condition.
 Click on OK

Format as table:
Using this option we can format your table.
Step –
 Select the table
 Go to home tab
 Click on format as table
 Choose the format

Cell style:
Using this option we can set the style of your cell.
Step –
 Select the table
 Go to home tab
 Click on cell style
 Select the style

Cell group:
Insert:
We can insert the row, column, cell and sheet.
Step –
 Go to home tab
 Click on insert
 Choose the row, column, cell and sheet.

Delete:
We can delete the row, column, cell and sheet or table.
Step –
 Go to home tab
 Click on delete
 Choose the row, column etc.
Format:

Page | 41
We can format different option such as row height, column width, visibility,
organize sheet etc.

Cell size group:

Row height:
It set the height of the selected row.
Step –
 Select the row and cell
 Go to home tab
 Click on format
 Select the cell size
 Click on row height
 Select the height
 Click on OK

Auto fit row height:

It undo the previous step.
Step –
 Select the cell
 Go to home tab
 Click on format
 Click on auto fit row height

Column width:
It set the column width.
Step –
 Select the column or cell
 Go to home tab
 Click on format
 Choose the column width
 Click on OK

Auto fit column width:

It undo the previous step.
Step-
 click the cell
 go to home tab
 click on format
 click on auto fit column width

Organise sheet group

Page | 42
Rename
Using this option user can change the sheet name.
Step-
 go to home tab
 click on format
 click on organize sheet
 click on rename sheet
 type the name (customize name)
Move or copy sheet
Using this option user can create a duplicate copy of the active sheet.
Step-
 Open the sheet
 Go to home tab
 Click on format
 Click on organize sheet
 Click on move or copy sheet
 Choose your sheet
 Click on create a copy option
 Click on ok
Protect sheet
Using this option we can protect our sheet.
Step-
 Go to home tab
 Click on format
 Click on protect sheet
 Type your password 2 times
 Click on ok
 Again type same password & click on ok

Editing group
Auto sum
Using this option we can calculate the total value, average, minimum,
maximum automatically.
Step-
 Go to home tab
 Click on auto sum
 Click on total, average, minimum, maximum
 Click on ok
Fill
Using this option we can fill the cell automatically.

Page | 43
Step-
 Set your cursor
 Click on editing group
 Click on fill
 Choose your up, down, left, right
Clear
Using this option used to delete the all data and clear all format.
Step-
 Go to editing group
 Click on clear
 Click on clear all or clear format
Sort & filter
Sort
Using this option we can arrange the table in either ascending (A-Z)order or
descending (Z-A)order.
Step-
 Select the table
 Click on sort & filter
 Choose your suitable
Filter
We can filter our table using this option.
Step-
 Select the table
 Click on sort &filter
 Click on filter
 Choose the drop down list
Find & select
Find & select are specific text formatting or type information within the
workbook. We can also replace the information with new text or formatting
text.
Step-
 Select the table
 Click on find &select
 choose your suitable option
Insert tab-
Table group
Pivot table:
In this table used to convert big table to small parts of table. It can easy to user
fill the table.
Step-
Page | 44
  select the table
 go to insert tab
 click on pivot table
 click on fill
 click on ok

Table:
Table is represent in row and column, Using this option we can design our
table.
Step-
 Select the table
 Go to insert tab
 Click on table

Illustration group
Picture
Using this option insert picture from existing file.
Step-
 Go to insert tab
 Click on picture
 Choose your picture
 Click on insert

Clipart
Using this option user can insert clipart in to the document.
Step-
 Go to insert tab
 Click on clipart
 Search the picture in task pane

Shape
Using this option user can insert readymade shape like line, rectangular,
triangle,etc.

Smart art
Using this option we can insert smart art graphic to visually communicate
information.
Step-
 Go to insert tab
 Click on smart art

Page | 45
  Insert suitable smart art
 Click on ok
Chart
Using this option we can make chart of a table. In this option used to graphics
represent of information statement. There are various types of chart ,bar chart,
line chart, area chart etc.
Design tab
Type group
Change chart type
In this option used to user can change the desired chart style.
Save as template
It is used to save the particular chart.

Data group :
Switch row& column
In this option used to switch row to column and column to row.

Chart layout group:

Chart style
This option is used to change the chart style.

Link group:
Hyperlink
This option used to user can link the one page to another page or link image.
Step-
 Select your record
 Go to insert tab
 Click on hyperlink
 Link the record to any document
 Right click on record
 Click on open hyperlink
 Click on remove hyperlink

Text group:
Text box
This option is used to insert the preformatted text box.
Step-
 Go to insert tab
 Click on text box
 Choose your suitable box

Page | 46
Word art
This option is allow us to insert decorative text in your document.
Step-
 Go to insert tab
 Click on word art
 Type the text
 Click on ok
Header & footer
In this option user can edit the header& footer of the document. The contain of
the header will appear on the top section and footer will be appear on the
button section.
Step-
 Go to insert
 Click on header & footer
 Insert the header& footer
Signature line
It will insert a signature line that specify the who is owner or verify the sign.
Step-
 Go to insert tab
 Click on signature line
Symbol
It will insert symbols that are not on your keyboard.
Step-
 Go to insert
 Click on symbol
 Choose your symbol

Page layout tab

Theme group:
Theme-In this option used to insert the different theme in your sheet.

Colors -In this option used to change the sheet color.

Font -In this option used to change the font style in your data.

Effect -In this option used to insert the different effect in your sheet.

Page setup group:

Margin
In this option used to setting the margin.
Page | 47
Orientation
In this option used to set up the page in landscape and portrait.
Size
In this option used to setting the page in different size (lette,A4,A3,A5).
Background
It will display the background of the excel sheet.
Step:-
 Go to page layout
 Click on back ground
 Select the background
 Click on insert
Break
It will break sheet of the screen.
Print area
We can print a specific selection of cells or area by using this option in a
worksheet.
Step –
 Select the cells or area
 Go to page layout
 Click on print area
 Click on set print area

Scale to fit group: -

Height
Width
Scale

Sheet option group: -

Gridlines
Headings

Arrange group :-

Formula tab
Formula and function group:
Formula
One of the most important features of spread sheet program are the ability to
convert text and perform simple as well as complex calculation very fast and

Page | 48
effectively. Formula means mathematical relationship between the number in
various cell. There are three types of formula present on spread sheet.
I) Text formula
ii) Numeric formula
iii) Logical formula

Function
We can use a function to perform calculation in one statement which is very
complex formula. There are several function are used in Ms-excel program.
Rules of function
 A function begin with or start with equal to symbol (=).
 The arguments are close with bracket ().
 The arguments are separated by comma (,).
 It allow a space.
 It close with the value in double quotation symbol(“ “).

Types of function
There are 5 types function available in a Excel program.
i. Mathematical function
ii.Statistical function
iii.Logical function
iv.Text function
v.Date and time function

i.Mathematical function
This function are used to solve mathematical problem like integer, square root,
factorial and many more.
ABS – It will findout the absolute value of a number.
 Syn :- =ABS(number) 
 Example :- =ABS(-25) 
O/P – 25
Integer – It display like integer value of a given number.
 Syn :- =Int(number) 
 Example :- =Int(25.05) 
O/P – 25
Even number – It display or find out the number up to the result even number.
 Syn :- =Even(number) 
 Example :- =Even(5) 
O/P – 6
Odd number – It display the number up to the result odd number.

Page | 49
  Syn :- =Odd(number) 
 Example :- =Odd(4) 
O/P – 5
Factorial – It returns the factorial value of a given number.
 Syn :- =Fact(number) 
 Example :- =Fact(5) 
O/P -1 x 2 x 3 x 4 x 5 = 120
Power – It find out the power value of a given number.
 Syn :- =Power(number,power) 
 Example :- =Power(2,3) 
O/P - 23 = 2 x 2 x 2 = 8
Mod- It returns the remainder value of a given number.
 Syn :- =Mod(number,diviser) 
 Example :- =Mod(10,2) 
O/P – 0
Square root – It display the square rot value.
 Syn :- =Sqrt(number) 
 Example :- =Sqrt(81) 
O/P – 9
Product – It display all the number to the given argument and return the
product value.
 Syn :- =Product(No.1, No.2, No.3 ……..)
 Example :- =Product(2,3,4) 
O/P – 2 x 3 x 4 = 24
ii.Statistical function -
Sum() – This function is used to calculate the total value.
 Syn :- =Sum(number or cell range) 
 Example :- =Sum(4,5,6) 
O/P – 15
Minimum – It find out the minimum value of the given cell range or number.
 Syn :- =Min(number or cell range) 
 Example :- =Min(4,5,6) 
O/P - 4
Maximum – It find out the maximum value of the given cell range or number.
 Syn :- =Max(number or cell range) 
 Example :- =Max(4,5,6) 
O/P – 6
Average – It find out the average value of the given number.
 Syn :- =Avg(number or cell range) 
 Example :- =Avg(4,6,8) 

Page | 50
 O/P – 6
Count – It count the number of cell in a given cell range.
 Syn :- =count(Cell range) 
 Example :- =Count(A1:A5) 
O/P – 5
Count if – It count the number of cell in a given cell range with a condition.
 Syn :- =Countif(Cell range,”Condition”) 
 Example :- =Countif(A5:A10,”>50”) 
O/P – 2
Median – It display the middle value of a given number.
 Syn :- =Median(No.1, No.2, No.3, ……) 
 Example :- =Median(6,7,8) 
O/P -7

iii.Logical function –
The logical function are used to verify a condition. If the condition is true then
the true statement is executed. If the condition is false then the false statement
is executed.
AND – It returns true if it is all condition are true and returns false if one or
more condition are false.
 Syn :- =AND(Condition1, Condition2) 
 Example :- =AND(40>20,10>30) 
O/P – False
OR – It returns true if anyone condition is true and returns false if all the
condition are false.
 Syn :- =OR(Condition1, Condition2) 
 Example :- =OR(40>20,10>30) 
O/P – True
IF – The function is used to returns true if condition is true otherwise it will
display false.
 Syn :- =IF(Cell address, condition, “Grade”) 
 Example :- =IF(A5>300,”A”,IF(A5>200,”B”,IF(A5>100,”C”))) 
iv.Text function –
Character – This function is used to find out the character value of
ASCII(American Standard Code for Information Interchange).
 Syn :- =Char(Number) 
 Example :- =Char(65) 
O/P – A
Code – It display the ASCII code of any character.
 Syn :- =Code(Character) 

Page | 51
  Example :- =Code(A) 
O/P - 65
Concatenate – It combine several string into one text.
 Syn :- =Concatenate(“String1”,”String2”,”String3”) 
 Example :- =Concatenate(“Happy”,”New”,”Year”) 
O/P – HappyNewYear
Proper – It convert text, string into the proper case.
 Syn :- =Proper(“Text”) 
 Example :- =Proper(“gold is YELLOW”) 
O/P – Gold is yellow
Length – It find out the length of the specified string.
 Syn :- =Len(“Text”) 
 Example :- =Len(“Gold is yellow”) 
O/P – 14
Left – It display the number of character from the left side of the string.
 Syn :- =Left(“Text”,number) 
 Example :- =Left(“GENIUS”,3) 
O/P - GEN
Right – It display the number of character from the right side of the string.
 Syn :- =Right(“Text”,number) 
 Example :- =Right(“GENIUS”,3) 
O/P – IUS
Upper – It convert text string into capital letter.
 Syn :- =Upper(“Text”) 
 Example :- =Upper(“hello”) 
O/P – HELLO
Lower – It convert text string into small letter.
 Syn :- =Lower(“Text”) 
 Example :- =Lower(“HELLO”) 
O/P – hello
Repeat – It repeat the text into a given number of time.
 Syn :- =Rept(“Text”,number) 
 Example :- =Rept(“Hyy”,3) 
O/P – HyyHyyHyy
v.Date and time function –
Now() – It display the current date and time.
 Syn :- =Now()
 Example :- =Now()
O/P – 9:34 28/03/2020
Day() – It returns the day of the month.

Page | 52
  Syn :- =Day()
 Example :- =Day(28/03/2020) 
O/P – Saturday
Today() – It display the current date.
 Syn :- =Today()
 Example :- =Today()
O/P – 28/03/2020 
Data tab
Sort and filter group:
Sort –
Sorting is the method of arrange text or number ascending or descending
order.
Step-
 Select the column
 Go to data tab
 Click on sort
 Select the order
Filter –
It can filter your table using this option.
Step-
 Select the table
 Click on sort and filter
 Choose the dropdown list
Advance –
Advance is a most useful option because operator can put the condition and
verify the data.
Step-
 Select the field name
 Copy and paste the field name in other row
 Give the condition
 Select the table
 Go to data tab
 Click on advance
 Select the field name and condition on cell range.
 Click on copy to another location
 Select the next line on copy to option
 Click on OK

Data Tools group:

Data validation -

Page | 53
Data validation option is used to verify in your data in excel sheet.
Step-
 Select the cell
 Go to data tab
 Click on data validation
 To give a value fill up the boxes below validation criteria(click on whole
number – click on between – enter the minimum and maximum value)
 Click on input message
 Give the title and input message
 Click on error alert
 Give the title and enter the error message
 Click on ok
Consolidate –
It combines the value from multiple range into new range.
Step-
 Select a plane column
 Go to data tab
 Click on consolidate
 Select a range in reference box
 Click on add
 Select again the range
 Click on OK

What if Analysis group:

Goal seek –
Using this option user can adjust the value in a specified cell until the formula
that is dependent on cell. Research the target value, it is good for single
variable formula.
Step-
 Click on Total value
 Go to what if analysis
 Click on Goal seek
 Enter your value
 Click on by changing cell
 Click on OK
Scenario manger –
It is a facility to create and save different set of input value for a given range in
the work sheet. In this data can we changes is called “Scenario manager”, it
identify by given name.

Page | 54
Step-
 Click on particular value
 Click on what if analysis
 Click on scenario manager
 Type your scenario name
 Click on OK
 Enter your value
 Click on OK
 Click on show button

Outline group:
Group –
It group the data in two way i.e., row and column.
Step-
 Select the table
 Go to data tab
 Click on group
 Again click on group
 Select the group
 Click on OK
Ungroup –
It will ungroup the selected row and column.
Step-
 Select the table
 Go to data tab
 Click on ungroup
 Again click on ungroup
 Select the ungroup
 Click on OK
Subtotal –
Using this option we can get the subtotal of the selected cell.
Step-
 Select the table
 Go to data tab
 Click on subtotal
 Click the field name from add subtotal
 Click on OK

Review tab
Proofing group:

Page | 55
Spelling
Research
Thesaurus
Translate

Comment group:-
New comment
Delete
Previous
Next
Show/ hide comment
Show all comment

Changes group: -
Protect sheet
It will protect our document with password
Step:-
 Go to review tab
 Click on protect sheet
 Type your password
 Click on ok
 Type the same password
 Click on ok

View tab
Workbook view group:
Normal
Page layout
Page break preview
Custom view
Full screen
Show or hide group:
Gridline
Formula bar
Heading
Zoom group:
Zoom
100%

Page | 56
Zoom to selection

Window group:
New window
Open a new window containing a view of the current document.
Arrange cell
It arranges all the open document at a time.
Freeze panes
Keep a part of the sheet visible while the rest of the sheet scroll.
Step:-
 Go to view tab
 Click on freeze panes
Split
It will split the window.
Hide
It hides the current window so it can’t seen.
Unhide
It unhides the current window.
View side by side
Synchronous scrolling
Reset window position
Switch window
It switch to a different currently open window.

Macro group:
Macro
Macro option is used to user can assign a shortcut key. The shortcut key can
user defines.
Step:-
 Go to view tab
 Click on macro
 Click on record macro
 Type a macro name
 Click on keyboard
 Enter your shortcut key
 Using alt or ctrl
 Click on assign
 Again give that shortcut key
 Click on ok

Page | 57
MS –Power Point
Ms- Power Point 2007 is a computer application produce by Microsoft .
One of the world leadership computer Base software service and solution .
Ms- Power Point is a part of a set of inter related application now as ms-office .
Ms- Power Point is a component of ms – office and also it is a powerful
presentation software. It is used to create professional presentation this can be
reproduce on transference paper and slide , Photo print etc . It allow you to
create a personal or individual presentation.

What is presentation ?
A Presentation is simply the way and idea or thought that is communicate to
another person . we are being present to different thought idea and subject in
your school , college and home presentation . is actually a type of
communication where you put your thought and idea and feeling that are
accepted by the audience .

How to open Power Point :-

 Click on start button
 Click on all program
 Click on Microsoft Office
 Click on Microsoft Office PowerPoint

Components of Ms- PowerPoint Screen :-

(1) Quick access toolbar

(2) Title bar

Page | 58
(3) Office button
(4) Menu bar / Tab bar
(5) Ribbon
(6) Status bar
(7) Task bar
(8) slide

On the left side on window, below ribbon, out line and slide tab are displayed.
Outline tab display only text in a slide. Slide tabs display all slide in sequence .

Home tab :-
(1) Clip board group :-
(i) Cut :- Using this option user can cut the selected data.
(ii) Copy :- This option is allow us to Copy the selected data.
(iii) Paste :- It will paste the cut or copy line.
(iv) Format Painter :- Enable us to format our text.

(2) Slide Group :-

(i) New Slide :- It will display a new slide on the screen.
Step-
 Go to home tab
 Click on new slide
 Choose the slide
(ii) Layout :- It will change the layout of the selected slide .
Step-
 Go to home tab
 Click on layout
 Choose your suitable layout
(iii) Reset :- It will change the set of the selected slide.
Step-
 Go to home tab
 Click on reset
 Select the slide
(iv) Delete :- It will remove the selected slide form the presentation .
Step-
 Select the slide
 Go to home tab
 Click on delete

Page | 59
(3) Font Group :-
(i) Font :- Change the font style in selected data.
(ii) Font size :- It will change the size of the selected data.
(iii) Bold :- It makes the text much thick in size .
(iv) Italic :- It makes your text Italic .
(v) Underline :- It will makes underline the selected record.
(vi) Grow font :- It will grow the font of the select record .
(vii) Shrink font :- It will shrink the font of the selected record .
(viii) Text color :- It will display the text color .
(ix) Character Spacing :- It will adjust the spacing between character .
Step :-
 Select the data
 Go to home
 Click on character spacing
 Choose your suitable spacing .(very tight , tight , normal , loose , very
loose , etc)
Text shadow- it will highlight the text and give a shadow behind it.
Step-
 Select the text
 Go to home tab
 Go to font group
 Choose your suitable

(4) Paragraph Group :-

(i) Bullets :- It start a bullet style .
(ii) Numbering :- It start a number list .
(iii) Text direction :- It will display the direction of the text . Such as –
Horizontal, Vertical (stacked), rotate 90o, rotate 270o .
(iv) Alignment :- There are four types of alignment . left , right , center , justify .

(5) Drawing Group :-

(i) Shape fill :- Using this option we can fill the color of the shape .
(ii) Shape outline :- It will give the outline of the shape . such as - width ,
dashes , pattern .
(iii) Shape effect :- Using this option we can give the effect of the cell .
(iv).Arrange
(v). Quick styles

Page | 60
(6) Editing Group :-
(i) Find :- It search a word , character , lines . It allow to located file or folder on
your computer .
(ii) Replace :- It replace the search word it called replaced .
(iii) Select all :- Select all , select object , select text or object in your document.

Insert Tab :-
(1) Table Group :-
(i) Table :- It will insert a table in our document .
Step :-
 Go to insert tab
 Click on table
When we insert a table it display another two tabs . That are Design and
Layout .

Illustrations Group :-
(i) Picture :- Using this option user can insert picture from exiting document.
(ii) Clip art: - Using this option user can insert clipart into the offline system .
(iii) Shape: - Using this option user can insert ready-mate shape . Like line,
circle, rectangular etc.
(iv) Smart Art :- Using this option user can insert a Smart art graphic to visually
communicate information .
(v) Chart :- Using this option we can make chart of a table . There are various
types of chart available in ms-Power Point.

 All of these option are same as illustration group of ms-word.

Link group
Hyperlink:- It will create a link to webpage from a picture or a program.

text group
text box:- It is used to allow insert the preformatted text box.
Wordart:- Insert decorative text in your document.
Header & footer:- Using this option user can add header &footer in your
suitable section.
Date & time:- In this option used to user can insert current date & time in your
document.
Slide number- it will apply a numbering on the slide.

Page | 61
Design tab -
Page setup group
Page setup:-
This option is used to set the page of the document.
Step:-
 Click on design tab
 Click on page setup
slide orientation- This option is used to choose the orientation between
portrait and landscape.
Themes group
Themes:-
(1)insert theme
(2)color
(3)insert-different color
(4)font-insert font style
(5)effect-different effect add in our document

Background group
Back ground style:-
It will display the back ground style for the selected slide.
Step:-
 Select the slide
 Go to design tab
 Click on back ground style
 Choose your background style
Hide background graphics- it will hide the background graphics of the slide.
Step
 Go to design tab
 Go to background group
 Click on hide background graphics

Animation tab
Preview group
Preview:-
It will display the preview of the animation and slide transaction.
Step:-
 Select the slide
 Go to animation tab
 Click on preview

Page | 62
Animation group
Custom animation:-
Using this option we can animate the individual object on the slide.
Step:-
 Go to animation tab
 Click on custom animation
 Go to task pane of custom animation
 Choose your animation
Animate:-
It will display different animation for the selected slide.
Step:-
 Select the slide
 Go to animation tab
 Click on animate
 Choose your animation

Transaction to this slide group -

Transaction speed:-
Using this you can dedicate how first to animate the transaction between the
preview slide & current slide.
Step:-
 Select the slide
 Go to animate tab
 Click on transaction speed
 Choose your transaction speed
Apply to all:-
It will set the transaction between the slides.
Step:-
 Go to animation tab
 Click on apply to all
Advance slide:-
On mouse click
Automatically after

Slide show tab

Start slide show
From beginning:-
It will start slide show from the beginning of the slide.
Step:-

Page | 63
  Go to slide show tab
 Click on from beginning
From current slide:-
It will start slide show from the current slide.
Step:-
 Go to slide show tab
 Click on from current slide
Custom slide show

Setup slide group:-

Set up slide show
Hide slide

Monitors groups:-
Resolution
Review tab
Proofing group: -
1. Spelling
2. Research
3. Thesaurus
4. Translate
5. Language

Comment group: -
1. Show markup
2. New comment
3. Edit comment
4. Delete
5. Previous
6. Next

Protect group: -
Protect presentation- It will protect our presentation.

View tab
Presentation view
Normal:- It will display the normal view.
Step:-
 Go to view tab

Page | 64
  Click on normal view
Slide shorter:- It will display the slide in serial order.
Step:-
 Go to view tab
 Click on slide shorter
Note page:- Using this option user can prepare notes about the active slide.
Step:-
 Go to view tab
 Click on note pad
 Type your notes
Slide show:- It will display the slide show.
Step:-
 Go to view tab
 Click on slide show
Notes page: -Using this option user can make a note about the active slide.
Step-
 Go to view tab
 Go to presentation view group
 Click on slide show
Slide master
Handout master
Notes master

Show or hide group:-

Ruler
Gridlines

Zoom group:-
Zoom
Fit to window

Color/Gray scale:-
Color
Gray scale
Pure black and white

Window group: -
New window
Arrange windows
Switch windows

Page | 65
Cascade
Move split

Macros group:-
Macros

Page | 66