MIC-Mission Information Communication, Bhopal PC-Package 1

Pc Package
Unit -1
Overview of windows operating system 8.1
Windows 8.1 is a personal computer operating system that was produced
by Microsoft and released as part of the Windows NT family of operating systems.
It was released to manufacturing on August 27, 2013, and reached general
availability on October 17, 2013, about a year after the retail release of its
predecessor. Windows 8.1 was made available as a free upgrade for retail copies of
Windows 8 and Windows RT users via the Windows Store.
Windows 8.1 aimed to address complaints of Windows 8 users and reviewers on
launch. Visible enhancements include an improved Start screen, additional snap
views, additional bundled apps, tighter One Drive (formerly SkyDrive)
integration, Internet Explorer 11, a Bing-powered unified search system, restoration
of a visible Start button on the taskbar, and the ability to restore the previous
behavior of opening the user's desktop on login instead of the Start screen. Windows
8.1 also added support for such emerging technologies as high-resolution
displays, 3D printing, Wi-Fi Direct, and Mira cast streaming, as well as the Reefs
file system.

Windows 8.1 received better positive reception than Windows 8, with critics
praising the expanded functionality available to apps in comparison to 8, its One
Drive integration, along with its user interface tweaks and the addition of expanded
tutorials for operating the Windows 8 interface. Despite these improvements,
Windows 8.1 was still criticized for not addressing all digressions of Windows 8
(such as a poor level of integration between Metro-style apps and the desktop
interface), and the potential privacy implications of the expanded use of online
services. As of August 2018, 7.36% of Windows computers are running Windows
8.1.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

 MIC-Mission Information Communication, Bhopal PC-Package 2

Basic Operations
How to start a computer:-Step 1: Right-click on the Windows 8.1 taskbar, then
choose Properties.
Step 2: Click on the Navigation tab, then under the Start screen section, check the
box next to "When I sign in or close all apps on a screen, go to thedesktop instead
of Start."
How to login/sign in a computer-
1. On an admin account, open the control panel. This is accessed by the settings section
of the Charms bar.
2. Click on User Accounts in the list.
3. Click 'Manage User Accounts'.
4. Click the 'Advanced' tab at the top of the window.
5. Tick the box in the 'Secure sign-in' box at the bottom and click 'OK'.

How to logoff a computer-

1. Save your work. Logging out of Windows will close your programs, so make sure
any important work you are doing is saved.
2. Open the Shortcut Menu. Press ⊞ Win + X to open this menu. ...
3. Sign out. Hover your mouse over "Shut down or sign out" and then click "Sign out".
...
4. Log in with another account.
Hibernate
This option was designed for laptops and might not be available for all PCs. (For
example, PCs with Instant Go don't have the hibernate option.) Hibernate uses less
power than sleep and when you start up the PC again, you’re back to where you left
off (though not as fast as sleep).
1. Use hibernation when you know that you won't use your laptop or tablet for an
extended period and won't have an opportunity to charge the battery during that
time. First check to see if this option is available on your PC and if it is, turn it
on.
To hibernate you’re PC:
2. Open power options:
 For Windows 10, select Start, then select Settings > System > Power &
sleep > Additional power settings.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 3

 For Windows 8.1 / Windows RT 8.1, swipe in from the edge of the screen,
tap Search (or if you're using a mouse, point to the upper-right corner of the
screen, move the mouse pointer down, and then click Search), enter Power
options in the search box, and then tap or click Power options.
 For Windows 7, click the Start button, click Control Panel, click System and
Security, and then click Power Options.
3. Select Choose what the power button does, and then select Change settings
that are currently unavailable. Under Shutdown settings, select
the Hibernate checkbox (if it's available), and then select Save changes.
Now you’ll be able to hibernate your PC in a few different ways:
 For Windows 10, select Start, and then select Power > Hibernate. You can
also press the Windows logo key + X on your keyboard, and then select Shut
down or sign out > Hibernate.
 For Windows 8.1 / Windows RT 8.1, move your mouse to the lower left-hand
corner of the screen and right-click the Start button or press Windows logo
key + X on your keyboard. Tap or click Shut down or sign out and
choose Hibernate. Or, swipe in from the right edge of the screen and then
tap Settings. (If you're using a mouse, point to the lower-right corner of the
screen, move the mouse pointer up, and then click Settings.) Tap or
click Power > Hibernate.
 For Windows 7, click the Start button, click the arrow next to the Shut
down button, and then click Hibernate.
Shutdown
Launch the Charms bar, click on the Settings charm, and then select the Power
icon. You should see at least three options: Sleep, Shut down, and Restart.
Click on Shut down to exit Windows. If you're at the desktop, you can
easily shut down by holding down the Alt key and pressing F4.
Personalizing desktop
Desktop Background:-
 Press the Windows ( ) key + C, or swipe in from the right edge of the screen
to open your Charms, then select Settings.
 Tap or click Personalize.
 Select a background image, color and accent color.
1. Screen Saver:-
Step 1: Right-click Control Panel on the desktop and choose Open to access
it. Or you can directly double-tap it.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 4

Step 2: Choose Appearance and Personalization in Control Panel.

Step 3: In Appearance and Personalization window, click Change screen

saver under Personalization.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 5

Step 4: As the Screen Saver Settings window shows up, click the down
arrow under Screen saver and choose an object from None, 3D
Text, Blank, Bubbles, Mystify, Photos and Ribbons in the list.

Step 5: Make more settings to the selected screen saver. (Optional)

 Regarding to screen saver of 3D Text or Photos, you can make more settings
by clicking Settings.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 6

 For example, in Photos Screen Saver Settings, you can tap Browse to choose
a folder where your own pictures are, select a slide show speed
from Slow, Medium and Fast, and click Save to save the changes.

Step 6: Set/change waiting time. (Optional)

You can set or change the waiting time for the screen saver. In other words,
the time determines when the chosen screen saver appears after you leave the
computer.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 7

Step 7: Click OK to bring the settings into effect.

Themes
Step 1: Open Search bar with the composite key of Windows key+F,
enter theme in the empty box and tap Settings.

Step 2: From the search results, choose Change the theme to move on.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 8

Step 3: As the Personalization window pops up, choose a theme from

Windows Default Themes and High Contrast Themes, as the following picture
shows.

Step 4: Click the close button to exit the Personalization window when the
theme has been altered.
Setting Date and Time
Choose Start > Control Panel > Clock, Language, and Region > Date and
Time.
Or
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 9

Click the clock in the taskbar's notification area; then click Change Data and
Time Settings.
Or
Right-click the taskbar clock and choose Adjust Date/Time.
Or
Choose Start, type date and time in the Search box, and then press Enter.
On the Date and Time tab, click Change Date and Time, adjust the date and
time as needed, and then click OK.

Taskbar
On the Taskbar tab, you'll be able to choose where your taskbar is located,
whether it stays there or not, the size of the icons on it, which icons appear
where, and whether you use Peek to get a preview of your desktop. Let's go
through these one by one:
"Lock the taskbar" - If you select this, your taskbar will stay where you place
it, and it won't allow you to move it somewhere else or change its size. If you'd
like to have a movable or hidden taskbar you should uncheck this.
"Auto-hide the taskbar" - This option hides the taskbar until you hover your
mouse pointer over the area where it's hidden. Then it slides into view. Once
you move away from it, it hides again.
"Use small taskbar buttons" in Windows 8.1 or "Use small icons" in Windows
7 - This can make your taskbar less obtrusive, by changing the size of the
icons on it and therefore the width of the taskbar itself.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 10

"Taskbar location on screen" - This lets you put the taskbar on the side or top
of your screen instead of the bottom, which is the default. Click or tap the
dropdown menu and choose your location. If your taskbar is unlocked, you
can also simply drag the taskbar elsewhere with your mouse or with your
finger.

"Taskbar buttons" - This lets you choose how application icons behave. You
can choose from "Always combine, hide labels" (each application shows only
one icon regardless of how many instances you have running, but the icons
are stacked to show that there's more than one of them, and they are icons
only, no text), "Combine when taskbar is full" (works like "Never
Combine" until you fill up the taskbar, and then the icons stack), and "Never

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 11

Combine" (just keep squeezing in the icons for as many applications as you
open).

"Show Windows Store apps on the taskbar" (this option is available only in
Windows 8.1) - It allows Windows 8.1 users to view the Windows Store apps
they open on the taskbar, alongside desktop applications. This is very useful
when you are working with both modern apps and classic desktop programs.

"Use Peek to preview the desktop when you move your mouse to the Show
desktop button at the end of the taskbar" in Windows 8.1 or "Use Aero Peek
to preview the desktop" in Windows 7 - If you select this, you can move your
pointer over the "Show Desktop" button on the far right of the taskbar. In
Windows 7, this button is vaguely delimited by a faint border, while in
Windows 8.1 it's just a blank space at the end of the taskbar. If you hover your
mouse over the "Show Desktop" button, it makes all the open applications on
your desktop transparent so you can see how the desktop looks, without
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 12

minimizing or closing everything. If you click or tap the button everything on

your d esktop will be minimized. Click or tap again to put it all back.

If you're using a mouse (this does not work on touch screen devices) you can
right click on the Show Desktop button to quickly enable or disable the Peek
at Desktop feature.

In both Windows 8.1 and Windows 7, you can resize the taskbar as you would
resize any window, by hovering over the upper margin till you see the "resize"
cursor appear and then dragging the margin up or down. Note that the taskbar
must be unlocked to do this, and it has minimum and maximum values beyond
which it can't be dragged.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 13

How to add toolbars to the Windows taskbar

You can add toolbars to the taskbar if you like. To do that, right click or press
and hold on a blank space on the taskbar and choose Properties , then
the Toolbars tab.
The choices that appear will be different depending on which programs you
have installed. These are the toolbars that are available by default in both
Windows 8.1
Creating, renaming, and deleting Files
With Windows XP, you can create a file using different programs such as
WordPad or Notepad.

To create a file using Notepad:

Click Start.
Choose All Programs Accessories
Notepad.
Notepad opens.
Type, "This is my new document".
Choose File Save from the menu bar (Ctrl
+ S).
The Save As dialog box appears.
Save your file to the desktop.
Name your document new document.
In the Save as type drop-down box, be sure
your document is saved as a text document.
Click Save. Your file is now saved to the desktop.
Once you've created a file, you can rename it.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 14

To rename a file:

Locate your file (in this case, the file is located on

the desktop).
Right-click the file icon.
Choose Rename.
The filename is highlighted in blue, ready to be
retyped.
Type a new name, then press Enter.
The file is renamed.
You can also select Delete from the menu to delete a file.

To delete a file:

Locate your file (in this case, the file is located on the desktop).
Right-click the file icon.
Choose Delete.
A Confirm File Delete dialog box appears asking you if you are sure you want
to send the file to the Recycle Bin.
Choose Yes.
The file is moved to the Recycle Bin.
Get into the habit of periodically saving changes to documents you're working
on in case of power outages or other problems.

Folder

When you first start using Windows XP, you may only create a few files. Over
time, you'll create MANY files. To keep your files organized, create folders.
Windows XP uses various folders to store and manage files. To become more
familiar with the structure of a Windows XP folder, let's open a folder
called My Documents.
To open and view the contents of the My Documents folder:

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 15

Double-click the My Documents icon on the desktop.

The My Documents folder opens.
OR
Right-click the My Documents icon (on the desktop).
Choose Open.
OR
Open the Start menu and choose My Documents.
Your My Documents folder looks something like this:

Recycle Bin
Locate the Recycle Bin icon on the Desktop.

Find the file you just deleted and select it by

Clicking on it once. From the Menu Bar,
Select File -> Restore
The file will have been restored to the directory it was deleted from. If you do
not remember which
Directory the file was in when it was deleted, you can search for it by using
the Search Feature.
NOTE: University machines will not restore a file after the machine has been
restarted.
Accessories
MS-paint
Press Windows+ R to open Run dialog, input mspaint in the empty box and
click OK.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 16

Step 1: On the Start screen, right-click the bottom left corner to access the
Quick Access Menu and choose Search on it.
Step 2: Type paint in the box, choose Apps and click Paint in the pop-up result.

Notepad
Press Windows+ R to open Run dialog, input notepad in the empty box and
click OK.
Step 1: On the Start screen, right-click the bottom left corner to access the
Quick Access Menu and choose Search on it.
Step 2: Type notepad in the box, choose Apps and click Paint in the pop-up
result.

WordPad
Press Windows+ R to open Run dialog, input WordPad in the empty box and
click OK.
Step 1: On the Start screen, right-click the bottom left corner to access the
Quick Access Menu and choose Search on it.
Step 2: Type WordPad in the box, choose Apps and click Paint in the pop-up
result.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 17

Windows Media Player

You can play audio and video files by using Windows Media Player. You can
choose different skins for the player from the available list or download more
skins from Microsoft Windows site.

Calculator

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 18

Windows Calculator
Window provides a simple calculator for doing arithmetic calculations. If you
are required to use calculator frequently, you can create its icon on your
desktop or in Quick Launch area by dragging the icon by holding the mouse
on it from above location to your desired location for prompt and convenient
access to this tool.
Language setting
Press the Windows key + C, and click on Settings.
Click on "Change PC settings".
Click on "Time and Language".

Go to Region and language and click on the + button to add a new language.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 19

Select the language of your choice and follow the onscreen instructions:

Disk Defragmenter:

With continuous use of computer, the files used again and again become fragmented
as these are written and rewritten on a very fast revolving hard disk. Due to
fragmentation of files, the seek time of the hard disk increases and its efficiency
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 20

comes down. Defragmentation of files results in reducing the seek time and restoring
the efficiency of the hard disk. Defragmentation of a drive may take hours depending
upon the volume of data stored on the disk. However, to maintain efficiency of the
hard disk and computer it is recommended to defragment the hard disk once every
2-3 months.

Disk Cleanup:
Over a period of time due to internet surfing and use of other applications and
programs a large number of files are created in the system, which have not
been used by the system for long. This tool deletes such unnecessary files
from the hard disk and creates space for other useful data/information. On left
click on the icon a small window asking you to select the drive for cleanup is
opened. After you select a drive, the tool opens another window displaying
the maximum space that can be cleared from your hard disk and asks you to
select the type of files to be deleted. You should be careful while selecting the
files to be deleted so that no file types which are likely to be used by you in
future are deleted.

Windows Update
Swipe in from the right side of your screen and select “Settings.”
Click on “Change PC settings,” then select “Update and recovery.”

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 21

Select “Choose how updates get installed.”

Click on the dropdown menu below “Important updates,” then select “Install
updates automatically.”
Place a checkmark next to “Give me recommended updates the same way I
receive important updates", then click on “Apply.”
Protecting Your Computer Against Viruses
Step 1: Download/save all files & print this document.
Step 2: Disconnect your computer from the network.
Step 3: Disable system restore.
Step 4: Scan with Malware bytes.
Step 5: Install Anti-Virus Software.
Step 6: Enable System Restore.
Step 7: Reconnect your computer to the network.

Using internet in windows

Step 1: To open Internet Explorer, click the tile on your Start screen.
Step 2: If, when you have finished browsing, you press the Windows key to
return to the Start screen, next time you open Internet Explorer you will see
the last webpage that you viewed.
Step 3: To go to another website, click your mouse in the Address Bar at the
bottom of the screen, or tap it with your finger if you are using a touchscreen.
Now type the website address or a subject you wish to search for.
Step 4: As soon as you start typing, the search engine will try to guess what
you want to find and will display tiles for possible sites that you have
previously visited or added to your Favorites.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 22

Step 5: If you don’t want to use any of these tiles, press the Enter key when
you have finished typing and you will see some search results from Bing
which is the Microsoft search engine and very similar to using Google. You
can now choose a site by clicking on one of the blue links.

Step 6: Web pages always open full screen. To move backwards or forwards
through pages you have visited, move your cursor over to the left or right hand
side of the screen to reveal a left or right arrow to click on. The Backspace key
will also take you back to the previous page.

Step 7: When you click on a link, you will see the Address bar appear at the
bottom of the screen.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 23

Working with browsers

Which is presenting this article content in a rich text/graphical format on your

computer screen. A web browser or frequently called as browser is an
application software that is installed on a computer to provide access to the World
Wide Web. It fetches the web pages from the server along with the necessary
files like, images, flashes, videos etc., interprets them and then displays it on the
screen. All you have to do is simply type the URL (Uniform Resource Locator)
of a webpage in the address bar and the browser will bring the web page on your
screen.

WWW

The World Wide Web (WWW) is a network of online content that is formatted
in HTML and accessed via HTTP. The term refers to all the interlinked HTML
pages that can be accessed over the Internet. The World Wide Web was originally
designed in 1991 by Tim Berners-Lee while he was a contractor at CERN.

URL

URL is an acronym for Uniform Resource Locator and is a reference (an address)
to a resource on the Internet. A URL has two main
components: Protocol identifier: For the URL http://example.com,
the protocol identifier is http. Resource name: For the URL http://example.com,
the resource name is example.com.

Search Engine

A search engine is a software program or script available through the Internet that
searches documents and files for keywords and returns the results of any files
containing those keywords. Today, there are thousands of different search
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 24

engines available on the Internet, each with their own abilities and features. The
first search engine ever developed is considered Archie, which was used to search
for FTP files and the first text-based search engine is considered Veronica.
Today, the most popular and well-known search engine is Google. Other popular
search engines include AOL, Ask.com, Baidu, Bing and Yahoo.

Searching information on Wikipedia

Wikipedia uses a powerful search engine, with a search box on every page. The
search box will navigate directly to a given page name upon an exact match. But,
you can force it to show you a page of search results instead, to see what else
Wikipedia has that includes your search string. The maximum search string is
300 characters long.[1] However, search can instantly search all 45,883,161
pages on the wiki when the search is kept to a simple word or two.

Wikipedia's searches can be made domain-specific (i.e., search in desired

namespaces). The search engine also supports special
characters and parameters to extend the power of searches and allow users to
make their search strings more specific.

Advanced features of the Wikipedia search engine include multi-word proximity-

searches (in which the user indicates how close the words in a phrase might be),
wildcard searches, "fuzzy~" searches (handles typo-correction and questionable
spelling), and several wiki-oriented operators and parameters for weighting and
filtering. Search can also handle regular expressions, a sophisticated, exact-
string, and string-pattern, search tool that is not offered by most public search
engines.

Search can also filter results by template names used, category membership, or
pages linking to a specific page.

Subscribing and reading newspaper online

1. You tend to get more disciplined about newspaper reading every morning.
2. You have access to real local news, which has a potential to impact your
everyday life.
3. You get to know about cultural events within your geography, which helps
you connect to your fellow denizens.
4. You get to know offers through ads and classifieds.
5. No one really disturbs you when you are holding a newspaper aloft.
6. You can share a part of your newspaper with your family member or a
fellow commuter.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 25

7. A lot of people work hard to bring out the newspaper to you everyday -
from the mission-carrying reporter till the early-rising newspaper boy.
8. Finally, you can sell off the old newspapers at the end of every month, and
make some cool petty-cash.

Using Google Maps

One of the early signs that Google might expand beyond search in all sorts of
interesting and unexpected directions was the Google Maps release in 2005.
Borne out of a series of acquisitions, the Google Maps project has grown over
the years to encompass satellite imagery, millions of points of interest, street
views, turn-by-turn navigation, traffic conditions, public transportation, and a
good deal more.

Google Maps boasts more than 1 billion active users today, making it the most
popular navigation software in the world. It gets millions of us where we need to
go every day, but are you sure you’re getting the most out of it? It’s easy to miss
new features or hidden options. That’s why we’ve compiled this guide on how to
use Google Maps. It’s time to take your first step on the road to mastery with our
Google Maps tips and tricks.

Step to Follow for How to Book Train Ticket Reservations Online using IRCTC

Step 1 Log in to your IRCTC account (If you don’t have a Irctc account then you
will need to create one)

Step 2 After logging in to your account, you will be automatically directed to a

page where you will be asked to fill in your journey details. Journey details
include information like From Station Code, to station Code, Date of Journey.

Step 3 After filling in your journey details click on find trains, the site will show
you a complete list of train between that particular pair of destination.

Step 4 Now choose best train and the class you wish to travel in. After choosing
these option the site will show the seat availability in the particular category.

Step 5 Once you see the ‘Book Now’ option click on it and you will be redirected
to the page where you will be asked to submit passenger details. Passenger details
include Passenger’s name, age, sex, birth preference, food preference (for some
trains), senior citizen and ID card number. You will also need to fill a authenticate
phone number on which your ticket details would be sent.
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 26

Step 6 After filling in the details the page will ask you to conform the details,
once the details are submitted, you will be redirected to the payment gateway
page.

Step 7 Here at the payment gateway you will be asked to choose the payment
method. As per the chosen payment option you will be asked to fill in the card
details or the wallet details and make the payment.

Step 8 Finally after the payment is made you will receive a confirmation mail as
well as a confirmation message on the registered mail ID and phone number.

How to pay electricity bill online

1. Find your last electric utility statement. ...

2. Sign on to your online banking account. ...
3. Look for a Bill Pay feature through your bank. ...
4. Find the instructions to add a Payee. ...
5. Find the link that says, “Make a Payment.” .
6. Verify the amount and click “Submit” when you are done.

How to pay service tax online

Step-1

To pay taxes online, login to http://www.tin-nsdl.com > Services > e-

payment: Pay Taxes Online Provide proper link of e-payment

Step-2

Select the relevant challan i.e. ITNS 280, ITNS 281, ITNS 282, ITNS 283,
ITNS 284 or Form 26 QB demand payment (only for TDS on sale of
property) as applicable.

Step-3

Enter PAN / TAN (as applicable) and other mandatory challan details like
accounting head under which payment is made, address of the tax payer
and the bank through which payment is to be made etc.

Step-4

On submission of data entered, a confirmation screen will be displayed. If

PAN / TAN is valid as per the ITD PAN / TAN master, then the full name
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 27

of the taxpayer as per the master will be displayed on the confirmation

screen.

Step-5

On confirmation of the data so entered, the taxpayer will be directed to the

net-banking site of the bank.

Step-6

The taxpayer has to login to the net-banking site with the user id / password
provided by the bank for net-banking purpose and enter payment details at
the bank site.

Step-7

On successful payment a challan counterfoil will be displayed containing

CIN, payment details and bank name through which e-payment has been
made. This counterfoil is proof of payment being made.

Booking gas refill online

 Once you have logged in, you will now see all the information about
your Indane Gas connection
 On the right-hand side of the screen, you’ll find an option “Order
Your Refill”, please click on this option
 Confirm all the details and select “Online Payment Option” and
click on “Book Now”
 Accept the terms and conditions on the page by clicking the box
provided

To download a free ebook, follow the steps below:

1. Sign up and activate a free account on Free-eBooks.net.

2. Use the search bar to find the ebook you need or browse the
categories.
3. Choose the format of the eBook to download: TXT or PDF. ...
4. Enjoy reading your free eBook!
5. FreeBookCentre.net.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 28

Unit-2
OFFICE PACKAGE: - Microsoft company is design office package. Office
package are use to operate office’s. Office package are manage to the huge
organization. Office package are used in advanced option our office are more
attractive.
Office package are several integrated tools. For example
word processing, spreadsheet, presentation software, database management software
etc tools of arrange in increasing order. One tool to another tools are easily transfer
data.
M.S OFFICE:- Ms office process start
Start

All programs

MS Office
Office activity and there software: - MS office are used in many software. They
are helped to run the MS Office. For example
1) Word Processing
2) Spreadsheet
3) Presentation Graphics
4) Database.
1) WORD PROCESSING: - We have save some document then save with .doc
extension computer are used in word processing then computer work in type
writer word processing. Word processor is just like another software package
with the facilities of a word processor in our office or home we need not use
a pen or paper. Word processing it has prepared in text, numerical value, latter
etc document in our computer system. It helps in word processing there are
time consume. That is the way to use word processing.
There is several works in work processing.
1) Typing:- With the help of keyboard any document type in our system.
2) Editing:- Editing of text is one of the most important and powerful
characteristics of a word processor.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 29

3) Formatting:- You can design your paragraph like spacing between two lines
in a paragraph and spacing between two paragraphs besides the specification
of the place where you would like to begin your paragraph from.
4) Saving:- We have prepared our document to reuse in future then document
save in hard disk.
5) Printing:- All types of processing in document to attach printer then printout
have done.

2) Spreadsheet:- Spreadsheet programs are basically designed to work with a

lot of mathematical operation, to arrange data in a tabular form, to create chart
and colorful graph.
A spreadsheet program consists of worksheets which is a
page divided into rows and columns. Rows and columns are arranged horizontally
and vertically respectively. Intersection of each row and column contain one value
which may be a number, text or formula. A number of spreadsheet package like lotus
and excel are in vogue.
1) Spreadsheet creation:- Each row and column contain one value which may be a
text or number are type and calculation of number.
2) Database:- To arrange related information for many types. To collect all the
related information is called data.
3) Chart creation:- Chart is a graphical presentation of numerical data.

PRESENTATION GRAPHICS:- PowerPoint is a component of Microsoft suite

which is used to create presentation on screen, transparency, 35mm slides, photo
print etc. with the help of this program, you can in corporate sound and color with
your thoughts. It is especially used in seminar, conference and educational
programmers by officers, teachers, managers and other professionals. Slides,
handouts and speaker’s notes are also prepared for presentation.
Advantages:-
1) Slides are like the pages we use in presentation. Slides may include titles, text,
graphs, drawing object and clipart.
2) Handout master has comment on any one topic.
3) Presentation software is used in DTP.

DATABASE:- Database system assembles and organizes data. Data is the entry of
real wizard that is called record or information. It is called data. All the data
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 30

information is called database. To manage the database software is called database

management system (DBMS).
Many uses of DBMS like Banking sector, management system,
railway reservation etc.
Advantages:-
1) To manage “file wise data”.
2) To present database record is real.
3) To prepare reporting in data file.
INTRODUCTION AND COMPARISON OF VARIOUS OFFICE SUITES:-
Microsoft office XP suite offers you at least six types application programs are.
WORD:- M.S Word is, among all, the most popular and useful member of the suite.
On this application software, you can make out most of the needs pertaining to word
processing and desktop publishing. Ms Word provides the users with the following
features that help them full easy with the gram of text.
1) Built in templates and wizards that help you create example documentation
just by following the steps.
2) Spelling checker helps you correct your spelling errors committed during
typing and thesaurus helps you choose one of the many synonyms suggested.
3) Mail merge helps you merge two files document and database especially used
for a mass correspondence.
4) Table that helps you arrange our data in a tabular form.
5) Column setting by which you can base our write up on two or more columns.
6) Autocorrect feature saves you from those errors we often connect while
speedy typing.
EXCEL:- M.S Excel is another application you use quite often in order to organize
and manipulate data especially numeric ones. Ms excel incorporate a tremendous
number of feature which help you operate on simple as well as complete numeric
data. In Ms excel you can exploit these features-
1) Template that you can use to standardize data entry files that may contain
complex formulae.
2) Charting and mapping tools that allow you to graphically represent your data.
3) The ability to quickly sort and filter lists of information.
4) Importing and exporting tools that help you upscale your data into excel or
out of excel and into access or another database application.
POWERPOINT:- When time comes to mark a presentation, whether it is to
prospective clients or your own board of directors, PowerPoint is the application that
you will securely like to have on your slide. With PowerPoint you will be able to get
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 31

your point across whether it is through a slide show of your presentation on computer
or by using printed overhead slides, PowerPoint will take a combination of the
results of yours efforts in word and excel and add some of its gavel effect to really
get your point across. PowerPoint features include-
1) The ability to add multimedia sound and video to your presentation.
2) Animation effects for true incremented display of feature graphics.

STAR OFFICE:- Star office is the product from sun Microsystems. The suit include
star office writer, star office calk, star office impress, star office base and star office
draw.
Star office writer helps you to snap out a quick memo or craft an
in-depth report with a table of contents, diagrams and inches, star office writer marks
it simple. Star office calc spreadsheet lets you calculate, analyze and share your data
quickly and easily. Star office impress is a full featured presentation tool like Ms
PowerPoint. Star office enables you to easily create “Self-contained” database
document with all relevant data, table definition, report and forms. Star office draw
helps you bring your communication to life with easy-to-create organizational chart,
network diagrams, floor plans and sketches and lots more.
LOTUS OFFICE:- Lotus organizer, the suite personal information manager (PIM)
program, has an uncluttered interface that allow the user to tab between e-mail,
calendar and other useful categories.
1) This option to control the smart suit or windows.
2) Cell data can be extracted from tables and spreadsheet and saved in HTML
format.
3) One more solution is to print the document same as to outpoint.
4) Lotus smart suite is open to some step.
Start

Display List

Select Program Option

Select Lotus Office.

To select lotus office then to open same options.
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 32

 Lotus 1,2,3.
 Lotus 1st slide.
 Lotus free lesion.
 Lotus word program esa ls fdlh,d option dks select djrs gsa

OPEN OFFICE:- Open office is a complete office automation package that comes
with nearly all distributions of Linux operating system. Open office may be
alternative to Microsoft office under Linux environment. Some features of open
office are really mind blowing. For example, you do not need to open different
application separately rather you can open all under one window.

INTRODUCTION TO M.S-WORD:- Microsoft is one solution to your at least six

kinds of problems of office. Ms-word is, among all, the most popular and useful
member of the suite. Microsoft Company has development Ms Office. It is used in
window to the word processing. You can create right from simple document like
letters to complex document like memos, resumes and reports.
Aria of use and features aria of use:-
To start Ms-Word.
Start

All Program

Select MS-Office

Select MS-Word

Open Window in MS-Word

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

 MIC-Mission Information Communication, Bhopal PC-Package 33

1) Click start button.

2) Take the pointer to program.
3) Select Ms-Word or Ms-Office.
Inside Ms-Office folder click Ms-Word.
1) Title Bar:- The top most bar of the window is called title bar. Microsoft word
is written on this bar. On its right side there are three buttons namely minimize
and close.
2) Ribbon :- consisting of the same three buttons highlighted-minimize,
maximize and close. These buttons are for operating the window.
3)
Ribbon Tab Command Groups
Name

Home Clipboard, Font, Paragraph, Styles, and Editing

Insert Pages, Tables, Illustrations, Apps, Media, Links, Header & Footer, Text,
and Symbols

Design Document Formatting and Page Background

Page Layout Page Setup, Paragraph, and Arrange

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

 MIC-Mission Information Communication, Bhopal PC-Package 34

References Table of Contents, Footnotes, Citation & Bibliography, Captions, Index,

and Table of Authorities

Mailings Create, Start Mail Merge, Write & Insert Fields, Preview Results, and
Finish

Review Proofing, Language, Comments, Tracking, Changes, Compare, and

Protect

View Views, Show, Zoom, Window, and Macros

4) Ruler:- Ruler is used in paragraph writing to set the indent.

5) Status Bar:- The last bar of the window is called status bar. For ex- page no,
line no, column no etc.

FEATURES OF M.S-WORD:- Microsoft word processing helps us in the above

ways just because of its excellent features.
1) Mail Merge:- It is the feature that people get help from the most suppose you
have 100 client in your office and you have a circular to send to all your client.
2) Spelling and Grammar check:- You keep on writing with no fear of spelling
and grammar errors.
3) Use of Thesaurus:- This is to help you with the problems of word meaning
and likewise you can have a number of synonyms and other related words,
even antonyms.
4) Hyperlink:- Hyperlink is a colored and underlined text or a graphic that you
click to go to a file, a location in a file, an HTML, page on the world wide
web or an HTML page on an intranet.
5) Inserting header and footer:- It is a usual practical to have different header
and footer on odd and even pages in the books. Odd page may contain chapter
name of the book as header and so the footer.
6) Table and drawing feature:- Tables are mainly used to manipulate data in rows
and columns. It is basically used to create report in Ms-Word contains rows
and columns. Each box of a table intersecting row and column is called a cell.
7) Auto correct:- You can use the autocorrect feature to automatically detect and
correct typos, misspelled words, grammatical errors, and incorrect
capitalization

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 35

WORKING WITH M.S-WORD:- File operation include creating a new file

opening an existing file, saving a file, printing and closing a file. When you open
Microsoft word a window namely document 1 opens by default, where you can
continue doing your work. How ever you can create a document by doing this.
Select file menu

Select new option

Open task pen

Select blank document

Click new blank document button on the standard toolbar.
Or click file new. After that new document task pane appears as one.

Click blank document under new in the new document.

tabs and Command’s:- There are 8 tabs in Microsoft.
Home
Home Tab Most of those frequently used commands are located in the Home Tab.
When you open Microsoft Word 2007 you will notice that instead of toolbars and
drop down menus, you will see what is called a Ribbon. The Ribbon is located close
to the top of the Word window. The Ribbon is organized into a set of task‐oriented
tabs, and each tab on the Ribbon contains groups of commands. The Home Tab

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 36

contains the most frequently used commands in Word. To get to another tab on the
Ribbon click that particular tab.

Insert

Besides adding text to a document, you may want to add images, links to web sites,
charts, or other objects to your Word document. The Insert Ribbon is one of the
most heavily used Ribbons and contains a variety of features that will allow you to
enhance any document. The Insert Ribbon is broken up into ten different group tabs
which are:
 Pages-Allows cover pages, blank pages, and page breaks to be added to the
document.
 Tables-Clicking the down arrow will open up a dialog box that will allow the
user to insert tables, draw new tables, import Excel spreadsheets, and by
clicking on the Quick Tables option (which opens up another dialog box) you
can add a variety of pre-built items to the document.
 Illustrations-This group tab has options for adding images, clip art, charts, and
more.
 Apps-Opens up a variety of apps that can be used along with Word.
 Media-Allows the user to insert video clips from a variety of sources.
 Links-The most commonly used item here is the Hyperlinks function, which
allows or objects to be converted into URL links to addresses on the Internet.
 Comments-Allows the use of comments on the side of the workspace.
 Header & Footer-All three functions on this tab will open dialog boxes to give
users many different options for headers, footers, and page numbering.
 Text-This is not the same as using regular text in Word. Text boxes are objects
that are in essence, mini-Word documents, and the other features offer text-
like objects such as signatures, WordArt, and more.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 37

 Symbols-The two functions here, Equation and Symbol, both have down
arrows that when clicked will open up dialog boxes showing a wide variety
of equations and symbols that can be inserted into a document.

Page Layout Tab

The Page Layout Tab holds all the options that allow you to arrange your
document pages just the way you want them. You can set margins, apply
themes, control of page orientation and size, add sections and line breaks,
display line numbers, and set paragraph indentation and lines.
Document Themes
• On the Page Layout Tab, in the Themes Group, click the Themes button. A
gallery opens.
• Hover your mouse pointer over the many themes in the Themes
gallery. Word enables you to preview the themes in your document via the
Live Preview feature. To make the change permanent, click the theme you
want to see.

References Tab
You can add a footnote to your document from the References tab. It contains
resources for researchers and anyone in the professional field. The References Tab
allows you to now create a table of contents, footnotes, citations, cross‐references,
select MLA or APA or ISO formats and so on. You can also turn your Works Cited
into a collection of records and use them in the future.

Review Tab
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 38

Spell Check can now be found in the Review tab. You will also find Word
Translation tools, a Track Changes tool, a Thesaurus tool and so on. Spell Checking
• On the Review tab, in the Proofing group, click Spelling & Grammar and
• Follow through as you would in previous versions of Word. Using the Thesaurus
• Click on the word that you want to check in the dictionary
• In the Proofing group, click the Thesaurus button. A pane opens on the right‐
hand side of the main window. The word is automatically entered and the definition,
if it can be found, is also shown as well. Adding Comments

• Click where in the document you would like to add a comment.

• In the Comments group, click the New Comment button
• Type your comment in the balloon that appears.
• Click anywhere in the document to get back to your work on the document.
The view tab will be mostly used with your complete document, usually to see how
it will look like. There are other important commands like the documents view and
the show/hide ruler option. These are the groups that we have in the view tab of
Microsoft Office Word 2007 and their respective commands.

View Tab

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 39

The view tab | Source

Documents View Group
 Print layout – this command will let you view the document as it will appear
on the printed page. I personally find it good to use while typing and then
checking on how the output will look like.
 Full screen reading – this allows you to access your document in full screen
reading view by hiding most of the toolbars; this helps you to maximize the
space available for reading or commenting on the document.
 Web layout – this command will let you view the document as it would appear
as a web page.
 Outline – you will be able to view your document as outline and show the
outlining tools.
 Draft – you will be able to view the document as a draft and be able to edit the
text. Some elements of your document for instance headers and footers will not
be present in draft mode view.
Show / Hide Group
 Ruler –this command is for showing or hiding the ruler used for measuring or
lining up objects in the document.
 Gridlines – gridlines are used for aligning objects in a document. This
command will show or hide the gridlines.
 Message bar – this command opens the message bar which helps you to
complete any required action in the document.
 Document map – this turns on or off the document map. The document map
allows you to navigate though a structural view of the document.
 Thumbnails – you can turn on or off the thumbnails pane using this command.
You can use the thumbnails pane to navigate along document through small

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 40

pictures of each page. While in thumbnails, you can switch to document map
and vise versa.
Zoom Group
 Zoom – Use this tool to open the zoom dialog box where you will be able to
specify the zoom percentage you want for your page. You can also use the zoom
controls in the status bar at the bottom of the window to quickly zoom the
document.
 100% - use this command to zoom the document to 100% of the normal size.
 One page – this command is used to zoom the page in such a way that an entire
page fits in the window.
 Two pages – use this command to zoom two pages such that they fit in the
window.
 Page width – this command zooms the document so that the width of the page
matches the width of the window.
Window Group
 New window – this command opens a new window containing a view of the
current document.
 Arrange all – use this command to tile open program windows side-by-side on
the screen.
 Split – this command splits the current window into two parts so that you can
view different sections of the document at the same time.
 View side by side – use this command to view two documents side by side so
that you can compare their contents.
 Synchronous scrolling – this synchronizes the scrolling of two documents so
that they scroll together. In order to use this feature, you must turn on the view
side by side command.
 Reset window position – this command resets the window position of the
documents being compared side by side so that they share the screen equally.
This command can only be used when the view side by side command is
activated.
 Switch Windows – you can use this command to switch to a different currently
open window.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 41

Macros Group
 Macro – use this command to view the list of macros from which you can create,
run, or delete a macro. By opening the macro dialog, you can be able to view
macros, record macros, and pause recording macro.
DIFFERENT PAGE VIEW AND LAYOUT:- Ms-Word lets you view your files
in six different ways. They are normal, online layout, page layout, print preview,
outline view and master document.
1) NORMAL VIEW:- This view appear by default. It is the standard
window for typing, editing and formatting.
2) WEB LAYOUT VIEW:- In web layout view, you can see background,
text is wrapped to fit the window, and graphics are positioned just as
they are in a web browser.
3) PRINT PREVIEW:- This view is used to see how the document will
look like on the paper after printing. It can also show you multiple
pages on the screen.
4) OUTLINE VIEW:- Outline view the structure of your document.
APPLY VARIOUS TEXT ENHANCEMENTS:- You can add special effects to
the font of text by using advanced text formatting. You can underline text in several
ways, write in subscript or superscript, and leave space between two characters. You
can also add animation.
ALIGNING PARAGRAPH:- Paragraph is by default aligned left side as we use
for writing English or Hindi on our copy. If required, you can change it easily to
right side or justify between both sides.
To align in different ways:-
1) Use align left button to align text or graphics from left side.
2) Use align right button to align text or graphics from right side.
3) Use align center button to align text or graphics in the center.
4) Use align justify button to justify text or graphics at both ends.

PARAGRAPH AND PAGE FORMATTING:-

Paragraph Formatting:- Ms-Word understands text, graphics, line that end with a
paragraph marker as a paragraph. If you press enter key it means you have written a
paragraph. An every enter key press Ms-Word adds a paragraph marker at the end
of the paragraph. You can view paragraph marker button which is usually not seen
on the screen, by selecting paragraph marker button on the standard toolbar.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 42

Page Formatting:- You just set your page on a word-processor leaving margins top,
bottom, left and right. This feature of a word-processor would never trespass the
area, you have set as no writing zone. Besides, you can format the page adding
border, shading etc. It looks like a nice page header and footer, page numbering. End
note and so on can automatically be printed on every page by setting the same.

TEXT EDITING USING VARIOUS FEATURES:-

Bullets:- We use bullets and numbering basically for making a list or arranging the
contents in order. You have many choices in number and bullets as well.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 43

Numbering:- To insert numbering, do this. Position your insertion point on the line
where you want to insert numbering.

Auto Formating:- To auto format a table do this.

1) Click the table.
2) On the table menu, click table auto format.
3) In the format box, click the format you want.
4) Select the option you want.
5) Click ok.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 44

PRINTING AND VARIOUS PRINT OPTION:-

PRINT PREVIEW:- You can see your output on the screen before it goes to final
print. It will make you observe the layout etc. To do this follows the steps.

a) Click the file menu and choose print preview or select print preview button
from the standard toolbar.
b) Print preview window look like.
c) If you want to print it click the printer icon quite left below the menu bar.
d) Click on close button to close its.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 45

UNIT-3
ADVANCED FEATURE’S OF M.S-WORD

SPELL CHECK:- You can check spelling and grammar error and correct them
according in the document. It is one more powerful tool of Ms-word which makes
you write correct English in your document. To use spelling and grammar check.

Step 1:- Click tools menu and select spelling and grammar or select spelling button
from the standard toolbar or press F7 together from the keyboard.
Step 2:- Click on the word or sentence you find most appropriate in the suggestion
box.
 Click change to change this selected word only.
 Choose change all to change all similar texts in the whole document.
 Select ignore button to make no changes.
 Select ignore all buttons to by pass all the similar words found in the
document.
 Select add button to include that very word in Ms-word dictionary like Patna,
Mathura etc. These words are not included in the standard dictionary as they
are nouns and bear no meaning.
Step 3:- If you find no appropriate word in the suggestions box, you can directly edit
the word and choose change button.
Step 4:- You can use undo button to cancel the last spelling check you have done.
Step 5:- Click cancel button to stop the error search.
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 46

Step 6:- To check grammar with the spelling, click check grammar checkbox.

THESAURUS:- This tool is a big storage area containing lacs of words with their
synonyms like you find in a dictionary of the largest volume dictionary in the
traditional market.

To use thesaurus, do this.

Step 1:- Select the word whose alternative you want.
Step 2:- Click the tool menu, point to language and then select thesaurus or press
shift +f7 keys together from the keyboard. The screen you will find while working
on word-processor is similar to the one. The box displays several different buttons.
Let’s see what do they result.
Replace- It replaces the word you have selected of your choice.
Look up- It shows you the meaning of the concerned word.
Previous- It takes you back.
Step 3:- Now, you click the replace button to find synonyms and get it replaced.

FIND AND REPLACE:-

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 47

Find the text:- You can search a text in a document and replace with other too.
To search a word, do this
Step 1:- Click edit and select find. Alternatively you can press Ctrl +F on the
keyboard find and replace dialog box appears.
Step 2:- Type the text in find what text box, you want to search.
Step 3:- Click the find next. Continue repeating the same to find the text in the whole
document.
Step 4:- Click on cancel to close it.
Step 5:- To search in a more advanced way click on more.

Replac the text:- To replace the text, do this.

Step 1:- Click the edit menu and select replace or press Ctrl +H together on the
keyboard.
Step 2:- Type the text in the find what box you want to replace.
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 48

Step 3:- now, type the text in the replace with box which you want to replace with.
Step 4:- Click the replace button.
Step 5:- In case you want to replace the new text with all a like words you have typed
in the find what box, click replace all.

HEADERS AND FOOTERS:- Header and footer may be text or graphics, printed
on top and bottom in a document. Header is printed on top margin area where as
footer is printed on bottom margin area. They contain important information.

To insert header and footer, do this.

Step 1:- Click the view menu and select header and footer option.
Step 2:- Word highlights panes of header and footer at the top and bottom
respectively.
Step 3:- Type either the text you want or insert auto text like page no. date etc inside
the header or footer pane as required from insert auto text button on header and footer
toolbar.

INSERTING PAGE NUMBERING:- Page numbering is used to insert page no.

at the top or bottom, left or right in a document. To do this, follow the steps a head.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 49

Step 1:- Click the insert menu and select page number.
Step 2:- Specify the location of page numbering from the drop-down box of position.
Step 3:- Set alignment whether left, right, center and so on.
Step 4:- Select the check box of show number on first page.
You can insert page number with the help of header and footer
also. To know it, see header and footer.

INSERTING PICTURES:- To insert a clip from the picture.

Step 1:- Click insert, point to picture and then select clip art.
Step 2:- After that insert clip art task pane appears. In the insert clip art task pane, in
the search text box, type a word or phrase that describes the clip you want or type in
all or sound of the file name of the clip.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 50

INSERTING SYMBOLS:- To insert symbol in your document.

Step 1:- Click the insert menu and select the symbol.
Step 2:- After that insert symbol task pane appear. You need give a word or a symbol
to click, and then insert our document.

WORKING WITH COLUMN:- You can set up two to three columns having equal
or different width and design there too.
To set-up equal width columns, do this.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 51

Step 1:- Select the part you want to divide in columns. To make the entire document
column based no need to select.
Step 2:- Click the format menu and select columns. After you select it, a window
appears.
Step 3:- Select your choice from presets section. To add vertical line between two
columns, click check box of the line between.
Step 4:- In the apply to drop-down list, select where from you want to set the columns
out of three options available there as follows-
 This section- The columns will be set in the very section only.
 This point forward- The column will be set a head of the current insertion
point only.
 Whole document- The column will be set in the whole document.
 Click ok.

Indent:- It is used into the setting of paragraph. Paragraph is by default aligned left
side as we use for writing English or Hindi on our copy. If required you can change
it easily to right side or justify between both sides.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 52

To align in different ways the following icons are used.

Step 1:- Use align left button to align text or graphics from left side.
Step 2:- Use align right button to align text or graphics from right side
Step 3:- Use align centre button to align text or graphics in the centre.
Step 4:- Use aligns justify button to justify text or graphics at both ends.

CREATING & WORKING WITH TABLE INCLUDING:-

Create a Table
Creating a table in Word 2013 is very easy. Do the following to create a table.
Step 1
Open Word 2013 and put your mouse pointer where you want to create a table.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 53

Step 2
Click the Insert tab, and choose the Table button. This option displays a
simple grid when your mouse pointer hovers over the grid cells, it makes the table
in the table which appear in the document.
You can make your desired table by hovering the mouse pointer over the grid in the
form of rows and columns.

Step 3
Your table is inserted in your Word document. Now click the square representing
the lower-right corner of your table; Word goes into a table design mode
that provides several options for working with the table.

Step 4
This step is optional, use only when you want to create a fancy table. Click the
table style button and select more options. And click your own desired table style.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 54

Step 5
Now you will see the stylish table in your document.

Delete table
Deleting a table in Word 2013 is also very simple. Do the following to do that.
Step 1
Click the existing table in your Word document.
Step 2
Go to the Layout Tab and choose the delete table button and click over delete table
option. It deletes the entire table from the document.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 55

Note: Now the entire table is deleted from your Word document.

MARGINS & SPACE MANAGEMENT IN DOCUMENT:-

Margins:- Apart from the margin set by Ms-word itself, you can also set margins to
your convenience. To set margins, do this.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 56

Step 1:- Click the file menu and select page setup. By default margins tab is available
on page setup dialog box.
Step 2:- Specify margins- top, bottom, left, right by clicking and spinning on the
concerned box.
Step 3:- Specify the gutter space by spinning the gutter spinner box. Gutter is the
extra space especially left for the binding purpose.
Step 4:- Click checkbox of mirror margins, to arrange the left and right margin in a
way that it’s inside and outside margins remain of the same width.
Step 5:- 2 pages per sheet prints two pages in a sheet and the margin outside and
inside remain the same.
Step 6:- Select all that you want and click ok.

Paper Size:- Click the page option and open the paper setup dialog box on our
display screen. Many sizes of pages are display.

Layout:- If you can select this option on page setup, open dialog box to set the
header, footer, vertical alignment and line number.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 57

ADDING REFERENCE AND GRAPHICS:- Ms-word provides you with the

facility of drawing. You can draw some basic shapes, pictures etc. with the help of
features incorporated in it. You can also edit or manipulate already created.
1) Drawing Toolbar:- In Ms-word, you can draw different shape newly or even
modify existing drawing. To create a shapes, do this
 Click drawing button on the standard tool bar or click view menu and select
check box before drawing from toolbar. Any of the above ways will display drawing
toolbar on the screen.
2) Word Art:- Word art is used to design the text in banner and poster form. It
is used to prepare placard poster etc.

To insert word art, do the following

Step 1:- Click insert and point to picture then click word art or select word art button
on the drawing toolbar.
Step 2:- Select the desired style from word art gallery.
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 58

Step 3:- Click ok.

MAIL MERGE:- Mail merge is a feature used for mass correspondence. Mass
correspondence means a letter to multiple clients with their address. Mail merge can
be used to create form letters, mailing labels, envelopes, directories and mass e-mail
and fax distribution. You can do this in two ways. The first way is that you use mail
merge wizard and the other is that you do it on your own.
Step 1:- Starting mail merge wizard first of all you have to start mail merge wizard.
To start mail merge wizard. Do this

Step 2:- Click tools, point to letters and mailing and select mail merge wizard.
Alternatively, display task pane if it is not displayed by clicking view task pane.
After that task pane displays click task pane drop-down list and select mail merge.

ENVELOP & MAILING LABLES:- Mail merge can be used to create form letter,
mailing label, envelopes, directories and mass e-mail and fax distribution.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 59

Step 1:- First windows start of the wizard, select letter radio button and click next,
starting document.
Step 2:- After that new window of the wizard appears. There are 3 options in this
step regarding setting up your letters. Be noted here that when ever you realize that
you have left something in the previous step of the mail merge process, you can get
back to the previous step by clicking previous button. Select use the current
document radio button and select next select recipients.

IMPORTING AND EXPORTING TO AND FORM VARIOUS FORMAT: - At

times, you need your document file to save in a different format. There are many
format provided by Microsoft word.
1) Text File:- You can open a duplicate copy of a file to preserve the contents
of the original file when you open a copy of some file the original file is not
affected.
2) Rich Text File:- You have a lot of fonts in various sizes like plain font,
cursive etc. You select the font style set its size, make emphatic it by choosing
different font faces like bold, underline and italics.
3) HTML:- HTML stand for hyper text marks language. Its true fact is too
linked up the different pages are easily hyper lined. To click this page opens
the hyperlink page. Ms-word help to create the web text and HTML page.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 60

UNIT-4
M.S-EXCEL
INTRODUCTION TO AREA OF USE:- MS-Excel is a window based
spreadsheet package which can be used to make calculation and derive analysis on
the basis of produced data in a tabular form. In addition to exhibiting detailed
account of annual budget and profit or loss in a table, it can be presented in different
graphical forms. With the help of this package, various sorts of formulae and
functions pertaining to the mathematical and accounting operation can be used for
related purposes. This package also avails different facilities of graphics and
provides up with many features for text editing and printing.
256- Column’s
65536- Rows
Start

All Programs

Ms-Office

Ms-Excel
Step 1:- Click the start button on the task bar of windows desktop.
Step 2:- Point to programs/ all programs and select Microsoft office and select
Microsoft excel.

M.S-EXCEL WINDOW:- Ms-Excel appears two windows are-

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 61

1) Application window
2) Document window
1) Title bar:- Title bar is the topmost bar located on the document window which
display name of the worksheet. File in excel are called workbook. XLS is given its
extension.
2) ribbon:- This bar located at the top window provides the user with many tabs and
sub tabs home, insert, page layout, formulas, data, review, view, help.
4) Formula bar:- Formula bar display text, formula or any kind of data typed by us.
5) Name bar:- Name box display current cell address.
6) Status bar:- Status bar is the horizontal area in excel on bottom of the worksheet
window which display different message depicting various information. For
instance, it lets you know whether you should simply type the text or edit it.
7) Sheet bar:- A tab near the bottom of a worksheet window that display the name
of a sheet.
Concept of workbook & worksheet:-
1) Worksheet:- Worksheet also known as spreadsheet, is the primary
document that we use in Microsoft excel to store and work with data.
A worksheet consists of cells that are organized into columns and rows.
A worksheet is always stored in a workbook.
a) Moving cell pointer:- In the worksheet, cell pointer can be moved very
easily with the keyboard. The movement of pointer involves eight keys
of the keyboard- four arrows key, home, end, pgdn, pgup keys.
i) Page down  Down on screen.
ii) Page up  Up on screen.
iii) Home key  Move cell pointer.
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 62

iv) Ctrl + Home key  First column.

v) Ctrl + End  Last column.

2) Workbook:- In Microsoft excel, a workbook is the file in which you

work and store your data. Each workbook contains by default three to
maximum 255worksheet. It makes you organize various kinds of
related information in a single file.
3) Mouse Pointer:- In Microsoft excel, it is used in mouse pointer.
Worksheet to used mouse, move in a different position for different
mouse pointer display.

USING WIZARD:- To create a chart do the following steps:-

Step 1:- Select the data range for instance A2:Q6.

Step 2:- Click insert and select chart or select chart icon on the standard toolbar.
Step 3:- After you perform the step two, chart wizard appears. The chart creating is
perform in four steps

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 63

Step 1:- Chart Type

Lets you basically select different types of chart and their sub-type for example,
clustered column from column chart type. You can select it the following way.

 Select appropriate type of chart from chart type box.

 Then, select sub-type of the earlier selected chart from the chart sub-type box.
 Click press and hold to view sample for preview of the chart
Step 1:- Chart source data
Let you specify data range and series.
Step 3:- Chart option include several tab menu.
Step 4:- Final step
In this step you specific the location of chart. Chart can be inserted in a separate
sheet or it can be placed in the data sheet also.
Various Data Type:- Ms-Excel are used in mathematical calculation. There are
several date types are used
1) Numerical value
2) Date
3) Time
4) Alfa numeric

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 64

1) Numeric value:- Number includes 0 to 9 and mathematical operations like $,

%, +, _, etc.

2) Date:- Date format provides with different types of format to the date type of
the data. For instance April 30, 2013, 20/4/2013 or 15 April, 2013.

3) Time:- Time format provides with different types of format to time like 12
hours or 24 hours clock system. In MS-Excel these format type of display.

HH:MM:SS - 11:30:03
HH:MM - 11:30
HH:MM:SS: AM/PM -11:30:50 Am

4) Alpha Numerical:- These Data Type are insert in character

value. These types of value are not use in mathematical calculation.

USING DIFFERENT FEATURES WITH DATA TYPE:-

MS-Excel are used in different types of Data.

1) Text or String :- User many types of Data are store in String Data type. Like
Name, Address, City etc. This data types are use in function with a text.
2) Value :- Excel are mainly used to insert different types of value. User can
insert one or more values. These types of values are insert in one or more
values are used to insert Table, Graph, Chart etc. To select column or row
with the help of data type to format the value. Use the format cell to set the
value. Decimal, Present and Special Character are used.

INSERTING, REMOVING, RESIZING OF ROW AND COLUMN:-

INSERTING:- MS-Excel to insert the column several steps are follows.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 65

Step 1:-To active the Insert Menu to select the row or column.
Step 2:-To select the row or column then click down the pointer on these place to
insert Row or Column.

REMOVING:-MS-Excel to resize the row or column, steps are there

Step 1:-To select the row or column, then resize.

Step 2:-To select the format menu, then select the row or column you can resize.

Step 3:-Click Row then change the height and similarly click column, then change
the width,

Step 4:-Open the dialog box, to resize the row and column.

WORKING WITH DATA AND RANGE:- In MS-Excel, selection of more than

one cell is called Range and a group of selected cells is called Block. Block is created
to complete such operation which requires more than one cell
To select a range, do the following:-
Step 1:- Position the mouse pointer before range.

Step 2:- Click the mouse and drag to the last cell of the range.

Step 3:-To select entire column or row click the heading of column or row
respectively.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 66

DIFFERENT VIEW OF WORKSHEETS:- worksheet view also known as

spreadsheet. These are several view to display the worksheet.
1) Normal view:-Normal view of the worksheet is by default Display, Title bar,
Menu bar, Tool bar and control the use of the view menu.
2) Page Break Preview:- click the option of Page Break Preview. If you can see
the preview of Page Break. Page Break to convert the next page.

COLUMN FREEZING:- To use this option, Excel worksheet are divided into four
parts. There are several steps are:-
Step 1:- click the cell pointer of this position or column of the Excel worksheet to
freeze the column.

Step 2:-click menu bar to select window menu option and then to click the freeze
option.

Step 3:- click the freeze option then divide the worksheet in four parts.
Step 4:-not use the freeze option of your worksheet then click unfreeze option.

LABELS:-worksheet of MS-Excel to display the characters of A, B, C, D etc, than

is called column labels. Row or Column to use the label option several types are
there.

Step 1:- to Active the Insert menu then to select the Name option to open the Drop
Down list, to select the label i.e., to open the dialog box.
Step 2:- to select the dialog box and Add the range of the label type.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 67

HIDING:-to hide the worksheet of this option. To apply this option several step are
there.
Step 1:-to open the worksheet.

Step 2:-click the window menu to select the hide option then hide of your worksheet.

Step 3:-as same as the previous worksheet then click the white option of the window
menu.

Step 4:-to click this option then open or show the worksheet

SPLITTING:-if you can apply the splitting option in your document then partition
the worksheet .Several steps are there:-

Step 1:- to click this position in your worksheet , to select the cell pointer then to
split the column.

Step 2:- to click the window menu and to select split option then window are divide
into four parts

Step 3:-main use of this option are to split the column and always show the column,
Data related all information show in different types.
Step 4:- to remove the split option in the window menu to select the resplit option of
your worksheet.

CELL FORMATTING INCLUDING BORDER AND SHADING:-

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 68

Border:- to set range of the border in the worksheet, several steps are,
Step 1:- to select the cell or range all sides border are insert.

Step 2:- click the format menu to select the cell, then open the dialog box of format
cell.

Step 3:- click the dialog box then open the border tab and to display the border.
Step 4:-to select only one border and click the apply button. If you can see the border
of excel sheet.

Shading:-to set the shading in your worksheet, several steps are there.
Step 1:-to select the cell or range then to insert the shading.

Step 2:- click the format menu to select the cell option the open the dialog box of
formal cell.

Step 3:-click the dialog box then open the shading tab and to display different color.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 69

Step 4:-to select only one color then click ok button.

MULTIPLE WORKSHEET CONCEPTS & CREATING MULTIPLE

WORKSHEETS:-
MS-Excel is a window based spreadsheet package which can be used to make
calculations and derive analysis on the basis of produced data in tabular form. In
addition to exhibiting detailed account of annual budget and profit or loss in a table,
it can be presented in different graphical form. With the help of this package, various
sorts of formulae and functions pertaining to the mathematical and accounting
operation can be used for related purposes. This package also avails different
facilities of graphics and provides us with many features for text, editing and
printing.

MS-Excel if you can work, multiple worksheet also. To insert multiple worksheet,
then worksheet insert several step are there
Step 1:- to Active insert menu then to select the worksheet.

Step 2:-to select worksheet option, if you can use multiple worksheet your document
to insert.

Step 3;- And then to work multiple worksheet.

CELL REFERENCING:- Intersection of row and column creates a rectangular

shape called cell. Each cell contains a specified address which describes the number
of column and row like A1, A2, B4, etc. If includes text, numeric, formula etc.
For ex:- combination of 1 row and 1 column as known as cell of Address A1.
Cell Addressing are divide into 2 types
1) Relative Address:- Relative address are used no any sign. Cell Reference is
copy to another cell reference then change the row number. Once you type data of

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 70

any sort, you can edit it any moment you wish to make changes as required and then
press enter.
For ex:- for instance to add values of cell, though cell 5, we use formula like
=c1+c2+c3+c4+c5
2) Absolute Addressing:-at times you need to copy formula of a particular cell. To
copy formula of a cell, do this-
Select the cell containing the formula you want to copy click copy on the standard
toolbar select the cell you want to paste the arrow to the right of paste and click
formulas.

WORKING WITH DIFFERENT CHART TYPE:-

Chart is a graphical presentation of numerical data. Range of data pertaining to

number is called Data series. Each value of dates series is called data point. Data
series can be put into columns and rows.

Type of charts:-
1) Column chart
2) Bar chart
3) Line chart
4) Pie chart
5) Area chart
6) Doughnut chart
7) Reader chart
8) Surface chart
9) Bubble chart
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 71

10) Stock chart

11) Cylinder chart
12) Cone chart
13) Pyramid chart

1) Column chart:- a column chart shows data changes over a period of time or
illustrates comparisons among items. Categories are organized horizontally,
values vertically, to emphasize variation over time.

2) Bar chart:- a bar chart illustrate comparisons among individual items

categories are organized vertically, values horizontally, to focus on comparing
values and to place less emphasis on time.

3) Line chart:-a line chart shows trends in data at equal interval

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 72

4) Pie chart:-a pie chart shows the proportional size of items that make up a data
series to the sum of the items.

5) Area chart:-an area chart emphasizes the magnitude of change over time.

6) Doughnut chart:-Like a pie chart, a doughnut shows the relationship of parts

to a whole, but it can contain more than one data series.

7) RADAR chart:-in a radar chart each category has its own value axis radiating
from the center point.
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 73

8) Surface chart:- surface chart shows travels in values across two dimensions
in a continuous curve.

9) Bubble chart:-a bubble chart is a type of XY (scatter) chart. The size of the
data maker indicate the value of a third variable.

10) Cylinder chart:- this chart represent value of data series in cylindrical
form.

11) Pyramid chart:-this chart represents value of data series in pyramid

shape.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 74

VARIOUS TYPE OF FUNCTION:- Built- in formulae are generally called

function. Function is an abbreviated form of formula. For instance, to add values of
cell 1 through cell 5, we use formula like= c1+c2+c3+c4+c5. However with the use
of function, we can calculate in a very short way like=Sum(c1, c5). In Excel, there
are following functions:-
a) Mathematics
b) Statistics
c) Date and Time function
d) Text function
e) Logical function
f) Financial function.

Mathematical function:-
1)ABS()
2)SUM()
3)SQRT()
4)MOD()
5)COS()
6)TAN()

Statistical function:-
1)AVERAGE()
2)COUNT()
3)MAX()
4)MIN()

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 75

Data and Time function:-

1)TODAY()
2)NOW()
3)DATE()
4)TIME()
5)MONTH()

Text function:-
1)LEFT()
2)RIGHT()
3)MID()
4)UPPER()
5)LOWER()

Logical function:-
1)IF()
2)AND()
3)OR()
4)NOT()

Mathematical function:-
ABS():- This is another mathematical function which returns integer or absolute
value of the number .The absolute value is one without sign.
Syntax :-ABS(number cell)
=ABS(-25)->25

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 76

SUM():- This is a mathematical function which derives total values of the given
range.
For ex:- (12, 12)->24

MOD():- Returns the remainder after no. is divided by division. The return has
the same sign as division. If division is 0. MOD returns
For ex:-MOD(10,3)->1

SQRT():- return a position square row.

For ex:- =SQRT(25)->5

Statistical Function:-

Average():-This mathematical function returns arithmetic’s mean of the given

number or range
For ex:- =Average(25, 5)->15

Max():- return the largest value in a set of values.

For ex:- =Max(12,4,80,23)
=80

Min():- return the smallest number in asset of values.

For ex:- Min(12, 4, 80, 23)
=4

COUNT():-counts the number of cells that contains numbers and numbers within
the list of argument.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 77

Date and Time function:-

DAY():- returns the day of a date, represented by a serial number. The day is
given as an integer ranging from 1 to 31.
For ex:- Day(“15- Aug”)->15

DATE():- return the serial number that represents a particular date.

For ex:- DATE(year, month,day)

NOW():- return the current system date and time

For ex:- NOW()
=11/15/04 10:54

Today():- returns the current system date.

For ex:- Today()
=11/15/04

Text Function:-
LEFT():- returns the first character or characters in a text string, based on the
number of characters you specify.
For ex:- LEFT(“package”, 3)
=pac

RIGHT():- returns the last character or characters in a text string, based on the
number of character you specify.
For ex:- RIGHT(“package”, 3)
=age

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 78

Logical function:-

If():-returns one value if a condition you specify evaluates to TRUE and another
value if it evaluates to false.
For ex:- If(12>10)
=TRUE

AND():- =AND(12>10, 13>12)

=TRUE

OR():- OR(12>10, 13>12)

=TRUE

NOT():- NOT(12>10)
=FALSE

PRINTING OF WORKBOOK AND WORKSHEET’S WITH VARIOUS

OPTION:-
When you complete a worksheet, you can better preview how your worksheet looks.
To preview an embedded worksheet this

Step 1:-click the file menu and select print review or select print preview button on
the standard toolbar

Step 2:-then open the dialog box of print preview and click the ok button.

PAGE SETTING:- apart from the margins set by MS-Excel itself, you can also set
margins to your convenience. To set Margins, do this,

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 79

Step 1:- click the file menu and select Page setup. By default margins tab is available
on Page setup dialog box.

Step 2:- specify margins- Top, Bottom, Left, Right, by clicking and spinning on the
concerned box.

Step 3:- specify the gutter space by spinning the gutter spinner box. Gutter is the
extra space left for the binding purpose.

Step 4:- click check box of mirror margins, to arrange the Left and right margin in a
way that its inside and outside margins remain of the same width.

Step 5:- 2 pages per sheet prints two pages in a sheet and the margin outside and
inside remain the same.

Step 6:- select all that you want and click OK.

DATABASE CREATION:- to create database in excel sheet to use worksheet. One

workbook are added many worksheets and to create huge database. Firstly to select
the field, then enter data. To display database are as follows:-

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 80

SORTING:- to sorting the data in the database. Two type of database sorting
1) Ascending sorting:- Ascending sorting of your data when number
are in increasing order.
2) Descending sorting:- descending sorting of your data when number
are in descending order.
Several steps are there.

Step 1:- to select the field then sorting the list.

Step 2:- click the tool menu then select the sort option. Click the
ascending or descending, then click ok button.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 81

FILTERING A DATABASE:- to use the filling in a database, then to add the filter
in a database. Several steps to apply filter

Step 1:- firstly to select the field then to apply the filter.

Step 2:-click the menu bar and select the Data menu. Menu bar to select the filter
option then to open the list, to select the filled to apply the filter.

CREATING AND USING MACRO:- Several steps are there,

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 82

Step 1:- to Active tools menu and to click the macro option, to open the page and
then o select the record new macro.

Step 2:- to open the Dialog box, and then to filled the name to define the key in the
macro.

Step 3:- click the Ok button, then start recording, complete the macro record, then
to stop the recording click OK.
Uses of macro:- to use the macro method, make the macro. To record the topic and
text are used macro option. To write the text again and again then macro text are
record to create the shortcut key of macro. To press the key then automatic type the
text.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 83

UNIT 5
M.S PowerPoint

Introduction:- PowerPoint is a component of Microsoft suite which is used to create

presentation on screen transparency, 35MM slides, photo print etc. With the help of
this program, you can incorporate sound and color with your thoughts .It is
especially used in seminar, conference and educational programs by officers,
teachers, managers and other professionals. Slides, Handout and speakers notes are
also prepared for presentation.

1) Click start menu.

2) Select All Programs
3) Select Microsoft Office
4) Select PowerPoint.

Various features of Ms-PowerPoint:- PowerPoint comes with the layouts that

contains text placeholder. You can add text using the slide exclusively for text
addition or you can use text box to add text outside the placeholder.
1) Ms PowerPoint 4.0
2) Ms PowerPoint 4.5
3) Ms PowerPoint 97 to 2000

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 84

Working with Ms- Power point:- PowerPoint is a component of Microsoft suite

which is used to create presentation on screen transparency , 35 MM slides, photo
print etc. With the help of Handouts provides support to presentation Handouts can
be distributed amongst audience before you start presenting it on screen or projector.

Creating New Presentation:- You can create a presentation in these ways.

Step 1:- Auto Content Wizard provides you instructions. Following them you can
prepare a presentation of your choice.

Step 2:- Design Template provides you so many built-in designs. You can create
your presentation just by selecting any of them.

Step 3:- Blank Presentation lets you choose your own placeholder, create
background of your presentation and design it in the way you design. In this method,
you are given different layout of slides.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 85

Working with Presentation:- To create the presentation, work with the help of
slide. Several steps are there.

Step 1:- to active the slide select file menu, then select the new option. The Slide
Layout is display in your window.

Step 2:- to select any one Layout click the button.

Step 3:- to insert a new slide, click New Slide on the standard toolbar, and click the
layout you want for the slide.

Step 4:- click the option slide of file menu option, then select the Page Setup,
available. Slide of Page Setup are set. To formatting the slide option then click.
1) Moving slide:-
a) Click the View menu and select slide sorter.
b) Now, select the slide you want to move.
c) Click the Edit menu and select cut or, click the cut button on the standard
toolbar, or press ctrl+x together on the keyboard
d) Now, click at the place you want to move the slide.
e) Then, click the Edit menu and select paste button on the standard
toolbar. Or, press ctlr+v together on the keyboard.

2) Copy slide:-
a) On the slides, select the text you want to copy, right click

b) To Active the Edit menu, to select the copy option and then
points are move. To these place are paste the document.

3) Deleting slide:-
a) Select the slide you want to delete.
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 86

b) Click the Edit menu and select Delete, or , just press Del key.

4) Inserting slide:- To Insert the slide of your presentation firstly click the insert
menu then select the New slide option.

5) Create Duplicate slide:-

a) Click the View menu and select slide sorter.
b) Then, select the slide you want to make a duplicate of.
c) Click the Edit menu and select Duplicate, or, press Ctlr+D
together on the keyboard.

i) Slide Design View:-

a) Click from Design template under New in the New presentation
task pane. After that slide Design task pane appears.
b) In the slide Design task pane, click a design template that you
would like to apply.

ii) Slide Layout View:-

a) If you want to keep the default title Layout for the first slide,
start working in the slide.
b) If you want a different Layout for the first slide, click format
and select slide, click format and select slide Layout. After that
Slide Layout task pane appears, click the Layout you want.
c) To insert a new slide, click New slide on the standard toolbar,
and click the layout you want for the slide.

2) Graphics & Picture Wizard:- To click the Insert menu and open the Picture
wizard several steps are there:

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 87

Step 1:- To active the Insert tab and then to select the wizard.

Step 2:- To open the List, to select the clipart option then open several windows.

Step 3:- Click the form file option select the Image.

Step 4:- To enter the chart of your document click the organization chart.
Step 5:- To add the diagram , auto shape etc.

Slides & its Different view:-several steps are there.

Step 1:- To Active View tab.

Step 2:- To select the view on View menu.

Step 3:- Firstly to display normal view. To see the slide on Normal View.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 88

Step 4:- Next is slide shorter view.

Step 5:- Slide show view are there to show the presentation.

Step 6:- select Slide show option then Next is Notes page view. And type the text on
Notes page, then show the slide on down the page.

Working with Notes & Handout:-

Notes:- To create Notes pages, do these.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 89

Step 1:- click the view menu and select Notes Pages.

Step 2:- Type the text of your choice in the Notes text box below the Slide.

Handout:- You can also print your slides as handouts-with two, three, four, six or
nine Slides On a page that your audience can use for future reference. Handouts
show only the slides, they didn’t include any corresponding notes. To print handouts
do this,

Step 1:- Open the presentation you want to print.

Step 2:- Click the file menu and select print or press cltr+p on the keyboard.
Step 3:- Print dialog box appears.

Sounds and movies to a slide:- To connect the text , slide, sound and Movies also
in your presentation. And also connect video clipper in your slide.
1) Movies:- To insert movie file in your presentation.
Step 1:- To select the Blank Slide.

Step 2:- To click the insert menu then select movie and send option.

Step 3:- To open the dialog box then select the movie file, to click the insert button.

Step 4:- To play the Slide show.

Step 5:- You don’t know movie file in which directory, then click the start menu,
select find option and search movie file. Extension .WAV

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 90

Sound:- To Insert sound file in your presentation slide, and you dont know the sound
file in which directory, then to select start menu click the find option and search
sound file in Extension .AVI. to insert sound file in option.
Step 1:- To active the Insert menu, select the sound from file option, to open the
dialog box, to select the sound file and insert slide the sound. To see the speaker in
your slide then click the sound play.
Step 2:- Click slide show and select sound effect, on the Slide Show menu, click
slide Transition. To open the dialog box and set the Time click the sound effect. To
slide show then automatic show the sound.
Step 3:-Click slide show and select custom Animation. After that custom Animation
task pane appear.

Working with Power Point object & Presentation of Slide Show:-

Slide Show View display each slide of the presentation at one time on the full
screen. Slide show view can be set some timing so that two slides can automatically
be displayed at a fixed interval. If timing is not set, slides can be displayed one after
another at every click. Slide show View also displays thing like graphics and
animated, items at the specified time or by clicking outline view.

1) Inserting Drawing:- To insert the drawing.

Step 1:- To select the slide then to insert the drawing.

Step 2:- To Active the drawing Toolbar in View menu.

Step 3:- With the help of slide, different drawing tool are insert.

2) Insert Clipart:- To insert a clip.

Step 1:- Click Insert menu, point to picture, and then click clip Art.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 91

Step 2:- In the insert clip Art task pane, type a word or phase that describes the clip
you want or describes the clip or some of the file name of the clip, in the search text
box.

3) Insert Picture:- Click Insert menu point to picture and then click clipart.

Printing Slides:-To print the slides do the following,

Step 1:- Click file and select print, or click print icon on the standard toolbar. Or
press ctlr and p together from the keyboard.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 92

Step 2:- Click the radio button of current slide in print range section to print current
slide. To print a specific slide, type the slide serial no. in the slides text box.

Step 4:- To print more then one copy of slides, select the number of choice from
number of copies small box
Click ok.
Outlook Express
Outlook Express is a POP3- and IMAP-compatible mail client with a built-in
newsreader. It is available with Internet Explorer for Windows XP or as a stand-
alone client for Mac OS 8.1 to 9.x (it is no longer available for Mac OS X). You can
configure it to retrieve email from your account via POP or configure it as
an IMAP client to access your mail on an IMAP mail server.

Outlook is an e-mail software program by Microsoft that enables users to send and
receive e-mail on their computer. There are two versions of Outlook; Microsoft
Outlook Express and Microsoft Outlook.
Microsoft Outlook Express is a slimmed down version of the Microsoft Outlook
software family and was first included with Windows 98 and included with all
versions of Windows up to Windows XP. With the introduction of Windows Vista,
Microsoft introduced Windows Mail.
Microsoft Outlook is a commercial product available in a stand-alone version or part
of the Microsoft Office package. This program is a much more full program with
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 93

better corporate support and additional features not found in the free edition. Below
is an example of Microsoft Outlook.

How to use Outlook Express to send and receive your mail

Email Configuration

1. Launch Outlook Express. You should see a link, displayed below, titled "Set up a
Mail account." Click this link to open the Internet Connection Wizard. If you do not
see the link, you can access the Internet Connection Wizard by going up to the
"Tools" menu and selecting "Accounts...." Next click on the "Add" button and select
"mail."

2. Select "Create a new Internet mail account." Click "Next >."

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 94

3. Enter your name. This will appear in the From field in any outgoing message that
you send. Click "Next >."

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 95

4. Enter you email address. Click "Next >."

5. Next, you will need to enter your E-mail Server Names. First select "POP3" from
the drop-down menu. (This should be selected by default.) Next enter the server

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 96

name, "mail.domainit.com" for the incoming mail server. The outgoing mail server
should be provided to you by your Internet Service Provider. Click "Next >."

6. Enter your "Internet Mail Logon." Your Account name is your email address, and
the password is the one that you specifyed when you registered this email account.
Leave the "SPA" checkbox blank. Click "Next >."

7. If your ISP requires you to use authentication for it's outgoing server, you need to
enter that information provided to you by your ISP. To do so, go to the "Tools" menu
and click on "Accounts." Select your email account and click on the "Properties"
button.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 97

8. Next, click on the "Servers" tab in the Properties dialog. Check the checkbox "My
server requires authentication." Then click on the "Settings..." button to the right of
that checkbox."

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 98

9. Click on the "Log on using" button and enter the information provided to you by
your ISP. Click "OK."

10. You're all done! To begin sending and receiving email, click on the "Send/Recv"
icon in the toolbar.

How To Receive And Sent Mail In Outlook

Step 1: Open the Mail Setup dialog box

1. Click Start, click Run, type Control in the Open box, and then click OK.
2. Depending on the version of Windows running on your computer, do one of the
following:
 Windows XP:

If you are in the Category View, click User Accounts, and then click Mail.

If you are not in the Category View, double-click Mail.

 Windows Vista:

Click User accounts, and then click Mail.

3. The Mail Setup dialog box opens.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806

MIC-Mission Information Communication, Bhopal PC-Package 99

Step 2: Start the New Profile wizard

1. Click Show Profiles.

2. Click Add to start the New Profile wizard.

Step 3: Create a profile

1. In the Profile Name box, type Test, and then click OK to name the new e-mail
profile.
2. Follow the steps appropriate for your version of Outlook:
 Microsoft Office Outlook 2010
1. Click to select the manually configure server settings check box.
2. Click Next.
3. On the Choose Service page, click Internet E-mail.
4. Click Next.
5. Fill in the boxes in the Internet E-mail Settings dialog box. Make sure
that the Account Type setting is set to POP3.

Note Enter the information from your ISP or from your e-mail
administrator in the Incoming mail server box and in the Outgoing
mail server (SMTP) box.
6. Click next, follow the prompts to finish setting up your account, and
then click Finish.
7. Your new profile is created. Go to step 4.
 Microsoft Office Outlook 2007
1. Click to select the manually configure server settings check box.
2. Click Next.
3. On the Choose E-mail service page, click Internet E-mail.
4. Click Next.
5. Fill in the boxes in the Internet E-mail Settings dialog box. Make sure
that the Account Type setting is set to POP3.

Note Enter the information from your ISP or from your e-mail
administrator in the Incoming mail server box and in the Outgoing
mail server (SMTP) box.
E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806
MIC-Mission Information Communication, Bhopal PC-Package 100

6. Click next, follow the prompts to finish setting up your account, and
then click Finish.
7. Your new profile is created. Go to step 4.

E-mail Id-micbhopal@yahoo.com Web-www.mic.bhopal.com Ph-0755-4272238,8602009806