Basic Course
Fundamental of Computer
English & Nepali Typing
Windows fundamental 98/2000/2003/xp/Windows vista
Desktop fundamental
Files & Folders
MS-Dos
MS-Notepad
MS-WordPad
MS-Paint
MS-Word
MS-Excel
MS-Power point
Virus Scanning
CD-Write
Internet & E-mail
What is a Computer:-
Computer is a man made machine in which task the instruction from the user process and provide the desired result as out put .that is called Computer.
Computer is an electronic machine which can solve our arithmetical and logical type problem that is called computer.
Various part of computer.
Monitor
Key board
Mouse
Printer
C.P.U. (Central processing unit)
The various categories of computer are as follow.(one of the basic of size)
Micro Computer. (Personal Computer.)
Mini Computer.
Main mini frame Computer.
Supper Computer.
*Personal computer.
The computer which is processing data base management and spread sheet Calculation.
*Mini computer.-
Mini computer is a medium size general purpose computer .it is grater than micro computer and smaller than main frame computer in size.It is used for processing in small organization and LAN servers.
*Main frame computer:-
Main frame computer is the high storage capacity and high speed. It is used for the data processing long organization and as nods well in WAN servers.
*Supper computer.
Supper computer is the most fastest, expensive and most power full Computer weather for casting, Bio-Medical research and weapon design.
Type of computer (one the basic of function)
Analogue Computer
Digital Computer
Hybrid Computer
Analogue Computer:- The machine which perform task in the system of
Speed acceleration wheel or wave is known as analogue Computer.
For Example:- Radio , Telephone etc.
Digital Computer: – The machine which performs task in the number is
known as digital Computer. For Example:- Calculator
Hybrid Computer:- The machine which perform task the both analogue
and digital system is known as hybrid Computer. For Example:- Aero plane
Generation of Computer
First generation of Computer:- (1940-1955)
- 1st generation of very hug size.
- Limit storage capacity
- Slow speed
- Use of vacuum tube
- Over heat Problem
Second generation of computer:- (1956-1964)
- 2nd generation of used transistor
- High level programming language
- Faster speed
- Storage capacity in increase
Third generation of Computer:- (1965-1971)
- 3rd generation of used integrated circuits
- Use of high programming language
- Small in size
Fourth generation of computer:- (1971- present)
- 4th generation of used to microprocessor
- Use of V L S I C ( very large scale integrated circuits)
- Faster performance
Fifth generation of computer:-
- 5th generation of used to Artificial intelligence
- 5th generation of used to tries to infuse intelligence In to Computer
Storage capacity of computer
The storage capacity of computer is expressed in bytes.
0,1 = 1bit
4 bit = 1 nibble
2 nibble = 1byte
1 byte = 1 character
1024 byte = 1 kb (kilo byte)
1024 kb = 1 Mb (mega byte)
1024 Mb = 1 Gb (giga byte)
1024 GB = 1 Tb (tera byte)
IPO-CYCLE
Hard ware:- The All physical part of computer. Which can be seen and touched is known as hard ware. It is just the machine of the Computer.
Three types of hard ware
- Input device
- Processing device
- Out put device
- Input device:- Input device are used to give instruction to the computer.
– key board
– Mouse
– Digital camera
– CD ROM
– Light pen
– Scanner
-Touch screen
2. processing device:- processing device are used to process the input data to designed out put is called processing unit . CPU is a processing unit
It contains three units.
- Airthmetical and logical unit(ALU)
- Control unit (CU)
- Memory unit(MU)
- Airthmetical and logical unit(ALU):- The unit that perform mathematical and logical order instruction given by input unit is known as Arithmetical and logical unit.
2. Control unit (CU):- The unit that control all the computer including input or out put is called control unit .this unit sends the input data for Execution valuated units as the input instruction if user gives data to save CU reminds disk to save is user order is print the data.
3. Memory unit (MU) :- The unit that is used to operate computer store data for future use in memory. we can store data temprorary and permanents.
Two types of Memory unit (MU)
- primary units
- secondary units
- Primary units:- The memory which is used to run any application and other various routines as well as to store temporary and data called primary memory.
- RAM (Random Access Memory)
- ROM(Read Only Memory)
a) RAM:- It is store data temprorary before we save the data to the storage device. When computer is on but when computer turn off it loss all the data. So it is also known volatiles memory.
b) ROM:- It is a memory that one store data cant be change removed or add. But can be record. So it is also known non volatile memory.
- Secondary Memory:- The memory which is used to store computer software for future used known as secondary memory.
There are many secondary memories.
* Hard disk:- Hard disk is a also power full storage device then others. It is fixed to computer case with pains and it is not problem device .hard disk can be found in different storage capacity in a market 40GB, 60GB, 80GB, 120GB, 160GB, 180GB, 250 GB,300 GB and So on…
* Floppy disk:- floppy disk is a portable storage device .it is small in size chef and easy to use .it can storage 1.44 MB data.
* Compact disk:- Compact disk is round shaped portable storage device that can be store 600MB to 800MB data. It needs compact disk drive to be used several types of compact disk drive can be fount in the market.
Audio CD
Video CD
Blank CD
Game CD
Program software CD
*Gip disk:- Gip disk is a portable storage device. Like floppy which can store 100 to 200 MB data.
3. Out put device:- The device through which computer gives out put is known as out device .
Monitor
Printer
CD write etc………..
Software
Software:- A set of instructions is well defined manner is called a program .and one or more program in well defined manner is called software.
Two types of software
1.) System software
2.) Application software
1.) System software:- A software required for running user programs is
known as system software.
a) O/S software (operating system software)
b) Utility software
c) Compiler software
a) O/S software (operating system software) :-Operating system software
is program which control over all operation activities Language of the computer .
it is a main point between the computer and operator for the example:-
Unix , Linux ,Windows etc……….
b) Utility software:- A software used for mange files and folder working
with files and folder drives and testing program is known as utility software
for Example:- Anti-virus ..
c) Compiler software: – A soft ware that convert the computer language in
to machine language in to computer language is known as compiler
software for Example:- c language …c++ language…
2) Application software:- A software written for special or specific purpose
is known as application software. It needs O/S software to run for
example:- MS-Word , MS-Excel, MS- page maker etc…………….
Describe the key board
Alphabetical keys (A to Z)
Numbering key (0 to 9)
Function key (f1 to f12)
Helps key (delete, caps lock, numbering, etc………………..
What is operating system?
A computer system consists of hardware and software. hardware like the system unit. which does all of the processing the key board. Through which one enters the data and commands: the display screen; the printer; the disk drive are the very important parts of a computer system. the hardware cannot do anything without software control. Software provides the instruction that tell the hardware exactly what to do.
In general, an operating system is program that provides an interface between the user, the application program, and the computer. It control input to the computer and output from the computer. The operating system act as a link between user and the computer hardware. Ultimately a computer system works using binary signal. Actually an operating system hides the complexities of the user. The operating system means that you do not have to work directly with binary arithmetic.
Different type of operating system
- Standalone OS
- Network OS
- Unix OS
- Novel OS
- Windows NT/2000 Server
- Linux OS
- MS Dos OS
MS DOS (Disk Operating system)
MS DOS:- Microsoft disk operating system. Ms dos is operating program. It is developed by Microsoft Company of America in 81and designed for a very old CPU like intel80x86. It is used to operate the computer. So it helps user to create new file by name and save or store data, create directories, copy files or directory from one drive ot another drive.
f
There are two kinds of Ms-Dos
- Internal dos command
- External dos command
1. Internal dos command: – Internal dos commands are pre-loaded in your memory (RAM) when you switch on a DOS-based computer. They are actually located inside the file called command.
Example: Date, time, cls, copy con, type, dir, Ren, Del, copy etc…..
2.External command: – Those commands are made of file that are held on the disk and
loaded in to the your computer memory (RAM) only as and when required. It is called external command
Example: – edit, attrib, delete, sys, mem, move, etc….
How to open dos command.
- Click on start button
- Click on run or you will get a dialogue box shown below.
- Type command or type cmd in run box
- Click on ok or Enter key.
- Ms dos will be display on the screen.
- Type cd \ enter button
C :\>
Not :- c= alphabetical
: = colon
\ = back space
> = grater than
How to exit front dos prompt.
- C:\> exit enter button
Date command: – this command is used to set & display the date.
Syntax:- date DD-mm-YY press enter button
Example: date 14-10-2008 press enter button
How to see date
C :\> date press enter button
Note:- if user want to change the current date one should type first dd(date) then mm (month) and (YY) year. For example:- How to see date.
Time command: – By using this command we can set & display the time.
Syntax: – time HH:MM:SS press enter button
Exam: – time 6:50:55 press enter button
How to see current time
C :\> Time enter (to display current time)
Note:- if user want to change the current time one should type first hour then minute and second with microsecond. Example:- 7:52:55:55
Cls: – It helps to clear the screen.
Syntax: – c:\> cls press enter button
Exam: – c:\> cls press enter button
Copy con command:-This command is called create file .it is used to store data. Particular drive.
Syntax: – copy con file name. Extension name enter button then
Type our massage F6 enter
Exam: copy con samir. Sha press enter button then
Samir is a boy.f6 enter
Type command:-This command used to display created the massage or file.
Syntax: – Type created file name enter button
Exam: – Type samir. Sha enter button
Ren command:- It is used to change the file name of create file without changing its massage contained in file.
Syntax:- c:\> ren old file name new file name (press enter button)
Example:- c:\> ren samir pravaker (press enter button )
Del command:- This command is used to unnecessary file are deleted from computer.
Syntax:- c:\> del file name (press enter button)
Example :- c:\> del Arman (press enter button)
Ver command:- It is used to show the version of the operating system.
C:\> ver (press enter button)
Dir command
Dir command:-This command is used to display files directory data, time and bytes.
1) c:\> dir samir.sha press enter button (to display only samir name )
2) c:\> dir c: press enter button (to display all name list of c:)
3) c:\> dir/p press enter button (to display all name list of c drive page by page)
4) c:\> dir/ah press enter button (to display only hidden name list)
5) c:\> dir/a press enter button ( to display hidden and unhidden list name )
6) c :\> dir/ar press enter button ( to display only reading name list )
7) c:\> dir/as press enter button (to display system file name)
8) c:\> dir/w press enter button (to display all name list in width )
9) C :/> dir c: /o: n/p press enter button (to display all name list of in ascending order)
10) C :/> dir c: /o:-n/p press enter button (to display all name list of in descending order)
11) C :\> dir * .kc press enter button (to display all name list having extension .kc)
12) c :\> dir samir.* press enter button (to display all name list having name samir)
# Copy command: – by using this command we can copy file name one drive to another drive.
Syntax: copy source drive target drive (press enter button)
Exam: c :/> copy c: samir.sha D: (press enter button)
Result: – now the massage of samir will be transfer in to D:
# Md: – we can create new directory.
Syntax: md new directory name (press enter button)
Exam: c :/> md Nepal (press enter button)
#Rd command:- It helps to remove or delete empty directory.
Syntax: – Rd directory name (press enter button)
Exam: – c :\> Rd Nepal (press enter button)
Note: – Nepal directory will be delete.
# Cd command :- It helps to this command we can open created directory.
Syntax: – cd directory name (press enter button)
Exam: c :/> cd Nepal (press enter button)
C :/> Nepal>
# Cd… command: – it helps to close the directory one by one.
Syntax: – c :/> directory name> cd…..or cd (press enter button)
Exam: c :/> Nepal >cd…. (Press enter button)
External command
Edit command: it is used to simple type of document, such as latter, easy, any official document. It is also crate new file, copy text massage, save file or modify the massage.
How to open edit command
Syntax: – c:\> edit (press enter button)
Process the menu bar
File menu
Save document: – It is used to save the data or document.
Click on file menu
Click on save } ctrl +s
Type file name exam: ram in dialog box (note: you will get a dialog box)
Click on ok box.
Close: – It is use to close the document.
Click on file menu
Click close box }ctrl +w
Save as: – It is used to save the data another file name.
Open your file or document
Click file menu
Click on save as (ctrl+5)
Type another file name box exam. Ram (Note:- you will get a open dialog box)
Click on ok box.
Open document: – It is used to open the data.
Click on file menu
Click on open option (ctrl+O) {Note:- you will get a open dialog box.)
Type your file name, or choose file name. exam: Ram
Click on ok box
New:- To arrange a new screen.
Click file menu {ctrl+N)
Click on new
Print:- It helps to print the data.
Click on file menu {ctrl+N)
Click on print option .
You will get a open print dialog box.
Click on ok box
Note:-waiting some time
Exit:- This option used to exit from the edit command.
a) Click on file.
b) Click on exit.
Edit menu
Cut :- To cut the latter.
Block the text which you want to cut
Click on edit menu
Click on cut option
Copy text: – To make duplicate text. Or this option used to copy the text of the document.
- Block the text which you want to copy
- Click on edit menu
- Click on copy text ] ctrl +c
- Choose the cursor position where you want to copy.
- Click on edit menu
- Click paste option ] ctrl +v
Clear: – To clear the text or data.
- Block the text which you want to clear
- Click on edit menu
- Click on clear option
Search menu
Find text:- To find the word or text.
- Place the cursor start of text
- Click search menu
- Click find text ] ctrl +f
- You will get a find dialog box.
- Type word or text in find what box exam :Ram
- Click on ok
Note: you get your text on the highlight.
Repeat last find:- This option is used to repeat the last find.
Click on search menu
Click on repeat last find
You get your last find text on the highlight.
Replace: – To change find word in another word required text.
- Place the cursor start of text
- Click search menu
- Click on replace
- Type required word find what box exam:- boy
- Type change word in replace with box exam :- girl
- Click on replace box
Option menu
Setting:- It helps to set tab key.
– Click on option menu
– Click on setting
– Type setting tab example:- 8
– Click on ok box
Colours:- It helps to set the latter color and back ground colour.
– Click on option menu
– Click on colour
– Set the color which you want to colour
– Click on ok box
Attrib:- It used to make file or directory hidden and unhidden read only and directory system.
How to make hidden file?
Syntax:- c:\> attrib +H file name (press enter button)
Exam:= c:\> attrib +H millan (press enter button)
How to make unhidden file?
Exam:= c:\> attrib -H millan (press enter button)
How to make read only file?
Syntax:= c:\> attrib +R file name (press enter button)
Exam:= c:\> attrib +R millan (press enter button)
Edit millan (press enter button)
Press any key
You cannot modify read only file
How to make unread only files?
Syntax:= c:\> attrib -R file name (press enter button)
Exam := c:\> attrib -R millan (press enter button)
c:\> edit -R millan (press enter button)
How to make system file name?
Syntax:= attrib +S file name (press enter button)
Exam:= attrib +S millan (press enter button)
How to make un system files?
Syntax:= c:\> attrib -S file name (press enter button)
Exam:= c:\> attrib – S millan (press enter button)
Label: – It used to change volume label drive name
Syntax:- c:\> label drive name (press enter button)
Example:- c:\> label samir (press enter button)
How to display label name?
Example:- c:\> vol (press enter key)
Move command: – Which is used to move file one drive in to another drive one by one.
Syntax: – c :\> move file name target drive name (press enter button)
Example c :\> move ram c: (press enter key)
Xcopy: – This command used to copy sub directory all it files one the target directory except main directory.
syntex : – c:\> xcopy file name address, name or place (press enter button)
examp : – c:\> xcopy ram parkas (press enter button)
examp : – c:\> xcopy ram d: parkas (press enter button)
Deltree:- This command is used to delete directory and its sub directories or files once.
Syntax:- c:\> deltree directory name (press enter button)
example:- c:\> deltree Nepal (press enter button)
Change the desktop
How to change the themes option.
- Click on right button on the free desktop area.
- Click on properties
- Click on themes option
- Select the themes option in themes list box from the position of drop down list.
- Click on apply box
- Click on ok button or enter button.
How to change the desktop option.
- Click on right button on the free desktop area.
- Click on properties
- Click on desktop option
- Select the properties option in background from the position of drop down list.
- Click on ok button or enter button.
How to set the screen sever option.
- Click on right button on the free desktop area.
- Click on properties
- Click on screen sever option
- Select the any one screen sever option in screen sever box from the position of drop down list.
- Click on apply box.
- Click on ok button or enter button.
How to change the desktop colour.
- Click on right button on the free desktop area.
- Click on properties
- Click on appearance option
- Select the choice colour in schemes colour from the position of drop down list.
- Click on ok button or enter button.
Note: – you are not change the setting option.
File and folder
File :- File is a collection (stores) our data.
File is a collection of information data.
Folder : – Folder is collection (stores) our File.
Text :- Action of the file the not read is to text.
How to create new file folder.
- Right click on free desktop area.
- Click on new option
- Click on folder option
- Click Type file name example : samir
- Press enter button
How to rename file or folder.
- Click on right button on the file or folder
- Select rename option
- Type new file name example:- pravaker
- Press enter button
How to copy file or folder.
- Click on right button on the file or folder that you want to copy
- Click on copy
- Right click on free desktop area
- Click on paste
How to moving file and folder.
- Click on file and folder that you want to move. Exam Right, Left, up, down.
How to change folder icon figure.
- Click on right button icon figure
- Click on properties option
- Click on customize option
- Click on change I con box
- Choose any on Icon figure
- Click on ok
- Click on apply box
- Click on ok.
How to delete file and folder.
- Select the file and folder that you want to delete
- press delete key
- press “ y ” key for yes
- press “ N ” key for no
How to find file and folder.
- Click start bar
- Click on find or search option
- Click on file and folder
- Types your file name:- example samir
- Click on look in box and choose all hard drive
- Click on search box
How to create I con of shut cut.
- Click on right button on the free desktop area
- Click on create shut cut option
How to restore deleted file and folder recycle been.
- Double Click on the recycle been
- Select on file and folder . which you won’t to restore.
- Right click on file or folder figure
- Click on restore option
How to change mouse pointer sign.
- Click on start button
- Click on setting option
- Click on control penal option
- Double click on mouse figure
- Click on pointer option
- Click on brows box
- Choose any one pointer sign
- Click on open box
- Click on apply box
- Click on ok
How to set any picture or figure in desktop screen.
– Click on right button on the free desktop area
– Click on properties option
– Click on desktop
– Click on browser box
– Choose any one picture , Which you want to set picture.
– Click on open .
– Click on apply box.
– Click on ok box .
Calculator
Calculator:- The calculator accessories allows you to perform simple math metical as well as complex static and scientific calculation .It use to same way simple calculation, among other futures ,allow you to convert from decimal, to hexadecimal and binary etc.
How to open calculator.
- Click on start bar
- Click on program
- Click on Accessories option
- Click on calculator option
Or
- Click on start bar
- Click on run
Note:- It will be display run box dialog box.
- Type calc
- Click on ok or enter button
NOTEPAD
Notepad:- Notepad is a simple software editor program. it is also windows branch. it is used to create simple document, simple write a latter and also make a bio-data. It is same as word pad.
Extension name .txt
How to open Notepad.
– Click on start bar
- Click on program
- Click on Accessories option
- Click on notepad option
Or
- Click on start bar
- Click on run
Note:- It will be display run dialog box.
- Type notepad
- Click on ok or enter button
File menu
Save document :- It is used to save the data.
- Type the massage on the screen
- Click on file menu
- Click on save }ctrl +s
- It will be display save dialogue box.
- Type file name and choose drive name exam: d: ram
- Click on save box
Save as:- It is used to save the data another file name.
- Open your file or document , type your massage
- Click file menu
- Click save as
- It will be display save dialogue box.
- Type another file name and choose drive name exam: d: shyam
- Click save box or press enter button
Open document: – It is used to open the data.
- Click on file menu
- Click on open option }Ctrl+O
- It will be display Open dialogue box.
- Choose drive name or type your file name. exam: d: Ram
- Click on open box or press enter button
New: To arrange a new screen.
- Click file menu
- Click on new option
Page setup: – To set paper size, and margin
or orientation.
- Open your file, document or type your text.
- Click on file menu
- Click on page setup
- It will be display page setup dialogue box.
- Click on margin and choose paper margin size
- Click on ok
Note: – if you want to proof paper size and margin than see print preview
Print :- It helps to print the data.
Open your file, document
Click on file menu
Click on print option }Ctrl+P
It will be display Print dialogue box.
Click on print box
Note :- computer will be should print the data.
Exit:- To out the note program.
Click on file menu
Click on exit option
Edit menu
Undo text: – It used to recall delete text.
- Click on edit menu
- Click undo text ] ctrl +z
Cut :- To cut the latter r text.
- Block the text which you want to cut
- Click on edit menu
- Click on cut option
Copy text:- To make a duplicate text.
- Block the text which you want to copy
- Click on edit menu
- Click on copy text ] ctrl +c
- Choose the cursor position where you want to copy.
- Click on edit menu
- Click paste option ] ctrl +v
Delete:- To delete selected text.
- Block the text which you want to delete
- Click on edit menu
- Click on delete
Select all: – To select all the text which you want to.
- Click on edit menu
- Click on select all option ] ctrl +A
Find text: – To find the word or text.
- Place the cursor start of text
- Click edit menu
- Click find text ] ctrl +f
- It will be display find dialogue box.
- Type word or text in find what box exam :Ram
- Choose one direction example: up, down
- Click on find next box
Replace: – To change find word in another word required text.
- Place the cursor start of text
- Click edit menu
- Click on replace
- It will be display Replace dialogue box.
- Type required word find what box exam:- boy
- Type change word in replace with box exam :- girl
- Click on replace box
Go to: – It helps to go page number line.
- Click on edit menu
- Click go to option
- It will be display go to dialogue box.
- Type page line number exam: 10
- Click on ok box
Format menu
Font:- It helps to change font name , font style, font size.
Click on format menu
Click on font option .
It will be display Font dialogue box.
Choose font name, font style, font size
Click on ok box
MS -PAINT
What is MS-Paint?
Paint is a application software program. Is a developed by micro soft company of America. It helps to drew image or any picture drawings. It can use the tool bar.
Extension name .bmp
How to open the MS-Paint.
Click on start menu
Click on run
It will be display Run dialogue box.
Type on pbrush in Run dialogue box.
Click on ok or press enter button
Or
Click on start bar
Click on accessories
Click on MS-Paint
Function of the working tools
Free form select:- To select object with free form.
Select :- To select object with rectangular shape.
Eraser:- To erase any object.
Fill with color:- To choose the pre used color.
Magnifier:- To magnify the object.
Pencil:- To draw any object.
Brush:- To draw any object with different brush shape or to paint any object.
Air brush:- To spray required color any where inside the creating area.
Text:- To write required text.
Line :- To draw straight line.
Curve:- To draw curve line.
Rectangular:- To draw rectangular object.
Polygon :- To draw multisided object.
Ellipse:- To draw ellipse and oval shaped object.
Rounded rectangular: To draw rectangular object with rounded corner.
Word Pad
Word pad:- Word pad is simple software package it is developed by Microsoft company of America
It helps to create data, simple typing, make bio-data, official typing etc…working. It is a same as not pad
How to open MS word Pad
- Click start bar
- Click on run
- It will be display Run dialogue box.
- Type WordPad in Run dialogue box.
- Click on ok or enter button
Or
- Click start bar
- Click program option
- Click on Accessories
- Click WordPad
Note:- It is a same as a notepad. It helps to use all notepad Menu bar option.
MS. Word
Microsoft word: – Ms Word is a very big software package. It is developed by Microsoft Company of America. It is used to create formatting and information data typing document table, bill ,Create simple designing graphic in also prints envelopes table.
How to open Ms Word
- Click start bar
- Click on run
- Type winword
- It will be display Run dialog box.
- Click on ok or enter button
Or
- Click on start bar
- Click on program option
- Click on Accessories
- Click on Microsoft word
Introduction of some parts.
Title bar:- It display the name of the fill that is opened and the option for closing minimizing ,maximizing the application windows.
Menu bar:- It is the first row, which represents the various option like file, edit, format etc…clicking on each of this menu option invoked a submenu offering a set of command option.
Tool bar:- It is tool bar contains a set of button that allows a user to work faster by clicking on a button that is symbolic of a specific command.
Status bar:- It is a viable at the button of the screen .it display details of the document like page number, total number of page ,line number, column number etc….
Vertical scroll bar:- It is used to move the document up and down.
Horizontal:- It is used to move the document left and right .
Drawing toolbar:- It enables a user to select various drawing option for document.
Cursor Movement
The cursor is moved by using the following keys from Keyboard.
Page setup :- One page up.
Page down :- Go to page down.
up arrow :- Move one line up
Down arrow :- Move one line down.
Left arrow :- Move one character left.
Right Arrow :- Move one character Right
End key :- Move End of line.
Home key :- Move to Beginning of the document.
File menu
Save document: – It is used to save the data.
- Click on file menu
- Click on save }ctrl +s
- Type file name and choose drive name exam: e: ram
- Click ok or, click save box.
Close: – It is use to close the document.
- Click on file menu
- Click close box }ctrl +w
- Press ‘y’ for save
- Press ‘n’ for not save
Save as: – It is used to save the data another file name.
- Open your file or document
- Click file menu
- Click save as
- Type another file name choose drive name exam. E: Ram
- Click save box or ok
Open document: – It is used to open the data.
- Click on file menu
- Click on open option
- Type your file name. exam: Ram
- Click ok or open box
New:- To arrange a new screen.
- Click file menu
- Click on new
- Click on blank option
- Click ok
Page setup: – To change paper size, and margin or orientation.
- Open your file, document or type your text.
- Click on file menu
- Click on page setup
- Click on margin sub menu and choose margin. (left, Right, Top, Button, Gutter)
- Click paper size sub menu and choose (exam:- A4 size, latter size,custom size)
- Choose the orientation
- Click on ok
Note: – if you want to proof paper size and margin than see print preview
Print preview:- To see actual page and multiple pages.
- Open your document ,file or type your text
- Click on file menu
- Click on print preview
- Click close box or press esc key
Save as webpage: – It uses to save the data in webpage.
- Open your document ,file or type your text
- Click on file menu
- Click on save as webpage
- Type your file name in save as webpage example:-. Shyam
- Click save box.
File search: – To search the file and folder.
- Click on file menu
- Click file search . { ctrl+f}
- Type file and folder name in search text example :- Arman
- Click on go box.
Web page preview: – To see the actual page in web page.
- Open your file ,document or type your text
- Click on file menu
- Click on web page preview
Print: – It is used to data or document print.
- Open your file ,document or type your text
- Click on file menu
- Click on print option {Ctrl+P}
- Choose print name and page number etc.
- Click on ok
Note: – printer should be ready.
Send to: – To send files or document in Email, Floppy, pen drive etc.
- Click on file menu
- Click on send to option
- Choose floppy directory or email massage
Properties:- It use to display information document. Summary, title, status etc….
- Open your document or file
- Click on file menu
- Click on properties
- Type on summary, status, title, etc……
- Click on ok click close box
How to see properties.
- Open your document or file
- Click on file menu
- Click on properties
- Then you will see the summary of your file
- Click on close box
Exit:- To out the word document.
- Click on file menu
- Click exit option
- Press ‘y’ for yes
- Press ‘n’ for no
Edit menu
Undo text: -It used to recall delete text.
- Click on edit menu
- Click undo text ] ctrl +z
- It is used to return to the previous data or documents.
Cut or move text:- To move text one place in to another place.
- Block the text which you want to cut
- Click on edit menu
- Click on cut or move text option
- Place the cursor position where you want to move text
- Again click edit on menu
- Click on past option
Copy text: – To make duplicate text.
- Block the text which you want to copy
- Click on edit menu
- Click on copy text ] ctrl +c
- Choose the cursor position where you want to copy.
- Click on edit menu
- Click paste option ] ctrl +v
Del or Erase: – To delete selected text.
- Block the text which you want to delete
- Click on edit menu
- Click on del or erase
Clear: – To clear the text or data.
- Block the text which you want to clear
- Click on edit menu
- Click on clear option
- Click on contents del
Select all: – To select all the text which you want to.
- Click on edit menu
- Click on select all option ] ctrl +A
Find text: – To find the word or text. It is used to search any character.
- Place the cursor start of text
- Click edit menu
- Click find text ] ctrl +f
- Find it will be display find dialog box.
- Type word or text in box exam :Ram
- Find next box
Replace: – To change find word in another word required text.
- Place the cursor start of text
- Click edit menu
- Click on replace
- Type required word find what box exam:- boy
- Type change word in replace with box exam :- girl
- Click on replace box
Go to: – It helps to go page number, line number.
- Click on edit menu
- Click go to option
- Type page line number exam: 10
- Click on next box.
- Click on close box.
View menu
Normal view: To see normal screen.
- Click on view menu
- Click on normal option 2
Out line view: – To display an out line view the document.
- Click on view menu
- Click on out line view option 2
Web layout: – To display a web layout view the document.
- Click on view menu
- Click on web layout 2
Print layout /page layout: – To solve the any problem in screen to display actual.
- Click on view menu
- Click on print layout/page layout. 2
Tool bar:- To display any hide tool bar, which helps to work easily and more efficiently however ,the flowing toolbar are must usable toolbar. As for example:- Stander bar, format bar, drowning bar etc.
- Click on view menu
- Click on tool bar
- Choose formatting bar, stander bar, drowning bar etc.
Ruler bar: – To wide display ruler in document.
- Click on view menu
- Click on Ruler (actual) 2
Zoom: – To make screen size small and big.
- Click on view menu
- Click on zoom option
- Click on zoom screen size exam :-(90,150)%
- Click on ok
Full screen: – To make full screen.
- Click on view menu
- Click on full screen after
- Click on close screen
Header and footer text:- To write main topic in document. In which appears in every page at the top pf the document is called header and footer.
- Click on view menu
- Click header and footer
- Type in word header box exam: ….BPCI….
- Press close
- Type footer text exam: – ….PCL…
- Click close box in header footer
How to remove header and footer.
- Click on view menu
- Click header and footer
- Delete the header text from current box
- Click on close button from current button
Insert menu:-
Page break:- It helps to insert a page break, column break.
- Choose the cursor position
- Click on insert menu
- Click on break option
- It will be display dialog box.
- Click on page break
- Click on ok.
Page number: – It helps to insert automatic page number which all pages at time
- Open your file
- Click on insert menu
- Click on page number
- Click on position box and choose one option. (header and fooder)
- Click on alignment box and choose one option exam:- center (left, right)
- Click on formative box and choose number style (format page number box eg.1,2,3)
- Click on ok .
- Click on ok.
To remove page number.
- Click on view menu
- Click on header and footer
- Delete the page number
- Click on close button
Auto text:- It helps to store our text required text which is used again.
- Click on insert menu
- Click auto text
- Type your text exam: – Md samir
- Click add box
- Click ok
Word art text: – To make design the text.
- Click on insert menu
- Click on picture
- Click word art box
- Choose any style design
- Click on ok
- Type word or text
- Click ok
How to color in word art text.
- Active the text
- Click fill color auto shape sub menu
How to modify your word art text.
- Double click on the text which you want to modify
- Type your text or insert your text
- Click on ok
Auto shape:- It is used to make design the shape figure.
- Click on insert menu
- Click on picture .
- click on auto shape .
- Choose any one shape figure
- Press left mouse button brow
How to add text in auto shape box.
- Click mouse right button in auto text shape figure
- Click on add text
- Type your text or document.
- Click on ok .
How to insert picture in document.
- Click on insert menu
- Click on picture
- Click on clip art
- Click organize clips option
- Click on office collection
- Choose any one picture exam: animal
- Choose any one picture copy
- Choose the cursor position which you went to set picture.
- Click on paste
How to delete picture word art text.
- Active the picture or word art text
- press del key.
- Click on yes box.
File: – To insert another file massage or text.
- place the cursor where you want to insert massage or text
- click on insert menu
- click on file
- choose file name which you massage insert
- click insert box
Text box: – To add the text in box.
- click on insert menu
- click on text box
- type your text
- click auto side in box
Insert symbol: – To insert symbol sign in document.
- place the cursor where you want to insert symbol
- click on insert menu
- click symbol
- choose symbol font exam: simple sign
- choose any one sign figure
- click insert box
- click close box
Date and time: – It is used to set date and time.
- click on insert menu
- click on date and time
Note: choose place where you want too.
Hyperlink:- It is used to link one file to another file.
- Open your file or type your text
- Block the text
- Click on insert menu
- Click on hyperlink option.
- Choose one file name. which you want to hyperlink.
- Click on ok
- Press ctrl your text or word click your mouse which you want to hyperlink.
- click on yes box
Diagram: – It used to make a design.
- Click on inert menu
- Click on diagram
- Select a diagram and click one diagram option
- Click on ok
How to insert object.
- Click on insert menu
- Click on object option
- Click create new option
- Click any one object type option
- Click on ok
Or
- Click on insert menu
- Click on object
- Click create from file
- Create file name or click brows option and choose any one file name
- Click insert box
Format menu
Font: – It is used to change font name, size, style and color.
- Block the required text or document.
- Click on format menu
- Click on font option
- It will be dialog box display.
- Choose font name , size ,style and color, underline.
- Click on ok .
Super script: – To make power up text.
- Block the text or number which you want to make super script.
- Click on format menu
- Click on font
- Active the super script box
- Click on ok .
Remove: – inactive
Subscript: – To make power down to text.
- Block the text or number which you want to make subscript
- Click on format menu
- Click on font option.
- Active subscript box
- Click on ok .
Strikethrough: – To cut the latter middle.
- Block the latter
- Click on format menu
- Click on font option.
- Click on strike through (active ) exam :
Ram
Remove:- inactive.
Hidden text: – To hide the text or document.
- Block the letter which you want to hide
- Click on format menu
- Click on font option.
- Click on hide box (active)
- Click on ok .
How to display hidden text.
- Select all text or document ] ctrl +A
- Click on format menu
- Click on font
- Inactive the hidden box
- Click on ok
How to set character spacing.
- Block the text or document.
- Click on format menu
- Click on font option.
- Click character spacing sub menu
- Click on position and spacing box and choose Spacing exam: lower, Raised, expended etc.
Animation or text defect:- To make design the text screen.
- Block the text
- Click on format menu
- Click on font
- Click animation / text effect sub menu
- Choose any one animation box exam :- shimmer
- Click on ok
Bullets and numbering: – It helps to insert number style.
- Click on format menu
- Click on bullet and numbering
- Click on number submenu
- Choose number style exam:-1,2,3,4
- Click on ok
- Type your text and press enter key .(to insert next number)
Custom bullet style (sign): – To insert bullet style sign.
- Click on format menu
- Click bullet and numbering
- Click bulleted submenu
- Choose any one custom sign
- Click customize box
- Click bulleted box
- Choose the symble font or Number:- symbol sign.
- Choose any one style
- Click on ok
Note: – type your text enter button key to Insert next bullet style.
How to set line spacing.
- Block the text
- Click on format menu
- Click on paragraph
- Click on line spacing box and choose
one position exam: double line ,
- Click on ok
How to set text Alignment.
- Block the text or document.
- Click on format menu
- Click on paragraph
- Click alignment box and choose one alignment box exam: center
- Click on ok
Or
Ctrl +l = left
Ctrl +R = right
Ctrl + C =center
Ctrl + J = justify
Boarder and shading:- TO change table line style and column
- Block the table or document.
- Click on format menu
- Click on boarder and shading
- Choose boarder line style and color
- Click on all box
- Click on ok
Shading and color:- To fill the table shading and Colour.
- Block the table or document.
- Click on format menu
- Click on boarder and shading
- Click shading sub menu
- Choose any one color
- Click on ok
Page boarder line: – To fill the boarder line.
- Select the text or document.
- Click on format menu
- Click boarder and shading
- Click page boarder sub menu
- Click art box and choose boarder style
- Click ok
- Click ok
Columns: – It helps to set news paper style.
- Click on format menu
- Click on column option.
- Type your column number of column box. Exam : 3 ,
- Click on ok
- Type your massage and press ctrl + sift + enter to next column
How to write your text normal mode.
- Keep the cursor area of document
- Ctrl +sift +end key
- Click on format menu
- Click on column
- Choose any one column box e.g,:-1
- Click on ok
Drop cap: – It helps to make big first latter of paragraph.
- Block the paragraph
- Click on format menu
- Click drop cap
- Choose one drop cap style
- Click on ok
Text direction: – It helps to change direction of text.
Take the text box where you want to text direction.
- Type your text
- Active on the textbox
- Click on the format menu
- Click on text direction
- Choose one of text direction
- Click on ok
Change case: – It change latter style .Exam:- capital, small, title etc.
- Block the text or document.
- Click on format menu
- Click on change case
- Choose any one case style Exam: lower
- Click on ok
Tab setting: – To set tab key position to make a bio-data
- Click on format menu
- Click on tab setting option.
- Type tab setting number exam : – 3.0
- Click on ok
Back ground: – To change screen color.
- Click on format menu
- Click on back ground option.
- Choose any one color. {Red, white, yellow}
- Click on ok
How to set text or document screen background.
- Click on format menu
- Click on back ground
- Click on printed watermark option
- Click on text water mark option
- Type your text box exam:- bpci
- Choose any one color
- Choose any one layout box
- Click on apply box
- Click on close box
Theme: – It is used to change the background, color and style.
- Click format menu
- Click on theme option.
- Choose the any one them style
- Click on ok
Frame: – It is use to create a new frame.
- Click on format menu
- Click on frame
- Click any one frame style exam:- new frame left
How to delete frame.
- Click on format menu
- Click on frame
- Click on delete frame
Tools menu
Spelling and grammar: – To check the spelling and grammar.
- Type your sentence
- Click on tools menu
- Click on spelling and grammar
- Click on correct order or click change box
- Click on ok
- Click on close
Set language: – To set any country language.
- Click tools menu
- Click language
- Click set language
- Choose country name exam: Nepal
Thesaurus: – To set antonym, synonym.
- Type your sentence
- Select the word
- Click on tools menu
- Click on language
- Click on thesaurus
Word count:- To count the word latter in your document.
- Type your text
- Click tools menu
- Click word count and close box
Auto correct:- To correct wrong word and set any paragraph in document.
- Click tools menu
- Click auto correct
- Active the all box
- Type small word in replace box exam: N
- Type long word as required exam: Niit birgunj center
- Click add box
- Click on ok
- Type first latter N press enter
Protect document (Read only):- To lock the document not modify your document.
- Type your text open your document
- Click tools menu
- Click protect document
- Click limit formatting to selection of style.
- Click start enforcing protection
- Type enter new pass word option exam:- 999999
- Click ok
- Re type enter pass word to conform exam:-999999
- Click on ok
- Click on save
How to remove protect document.
- Open your protect document
- Click tools menu
- Click unprotect
- Type lock pass word exam:-999999
- Click on ok
- type your text
Protect document (Read only):- To lock the document not modify your document.
- Type your text or open your document
- Click tools menu
- Click on option
- Click on security
- Type enter new pass word to open exam:- 999999
- Click ok
- Re type enter pass word to conform exam:-999999
- Click on ok
- Click on save
Again how to lock file or document.
- Open your document or file
- Click on file menu
- Click on save as
- Click on tools menu
- Click on security option
- type on pass word to open box exam:1234
- Click on ok or enter button
- Re enter pass word to open box exam:1234
- Click on ok or enter button
- Click save as box
How to delete pass word in your document.
- Open your document or file
- Click file menu
- Click save as
- Click tools menu
- Click security option
- Pass word to open box to delete
- Click on ok
- Click on ok
- Click save as box
Mail merge:- This option is a very useful feature of Microsoft word. It helps you to quickly produce a personalized latter for each person in your mailing list.
- Click on tools menu
- Latter or mailings option
- Click on mail merge option
- Click on latter option in selected document type
- Click on starting document
- Click on use the current document
- Click on recipients
- Click on type a new list
- Click on create option
- Type all information in enter address information box
- After that all data save (save address list box exam: ram)
- Click on save box
- Choose insert box example: 1) address field 2) database field
- After that one by one insert all data example: first name, last name
Address, city ,country
- After that you write a full latter
To
Dealer’s first name and last name
Company name
Address
City
State
Postal code
Country
Phone number
Sub: With reference to your letter dated(Refrence)
Dear(Dealer’s first name)
This is to information you that our company is holding the annual meeting of all the dealers at hotel surya conference room. Friend Colony new Delhi on the 17th of January ,2009. you are requested to attend the meeting at 7pm sharp. Dinner will be served at 10pm.
Sincerely
Vikash Gupta
Marketing Director
(Dreamtech publishing House)
- Click on tools menu
- Click on letter and mailing
- Click on show mail merge tools box
- After that click on first record tool box
- Click on next tool box
- Then you have print the latter (which you want to)
Table menu
How to create bill, table.
- Click on table menu
- Click insert table
- Click table
- Type number of columns or rows exam:4, 4
- Click on ok
How to new insert columns.
- Block the document
- Click table menu
- Click insert
- Choose right columns left columns
- Click on ok
How to insert new rows.
- Block the rows
- Click table menu
- Click on insert
- Click on above rows, below rows
- Click on ok
- Or
Press the cursor last cell
Press tab key
How to delete rows and columns.
- Block the row ,columns which you want to delete
- Click table menu
- Click on delete
- Choose row and column
- Click on ok
Merge cell:- To clear the rows or columns.
- Block the cells
- Click the table menu
- Click the merge cell
- Click on ok
Split cell:- To make divide the cell one or more.
- Block the cells
- Click the table menu
- Click split cell
- Type your number rows 3 or column 5
- Click on ok
Split table: – To divide the table in two.
- Place cursor cell where you want to split table
- Click table menu
- Click split table
- Click on ok
Show and hide table:- To show and hide grid lines.
- Click on table
- Click on show and hide grid lines
Short:- To display text and number ascending or descending order.
- Block the text number or table
- Click table menu
- Click on short
- Choose text on number in text
- Choose ascending or descending order
- Click on ok
Formula:- It helps to find the value.
- Type the data
| s. num. | Particular | Rate | Quantity | Amount |
| 1 | C p u | 6000 | 5 | |
| 2 | Monitor | 4500 | 5 | |
| 3 | Mouse | 200 | 5 |
- Put the cursor required cell
- Click on table menu
- Click on formula
- Type the formula exam:- =(6000*5)
- Click on ok
How to change table boarder and shading.
- Select the table
- Click on table menu
- Click on table auto format
- Choose the any style of format
- Click on ok
How to change table auto format.
- Select the table
- Click on table menu
- Click on table properties
- Choose the table properties
- Choose the table arrange style
- Click on ok
MS Excel
MS Excel: – Ms Excel is spread sheet program it is developed by Microsoft Company. In excel we can create formatting data graph, salary sheet, bill, Mark sheet. Etc
How to open Ms excel
- Click on start bar
- Click on run
- Type excel
- Click on ok or enter
Or
- Click start bar
- Click on program
- Click on Microsoft excel
Mathematical operators
- + = Addition
- – = subtraction
- * = Multiply
- / = Divide
- % = percentage
- Sqrt = to find out squire root exam:(100)
Function key
- > = grater than
- < = less than
- >= = grater than equal to
- <= = less than equal to
Introduction of some part
Work book:- Excel is a work book. work book is a collection of work sheet. By default there are three work sheets in a work book.
Work sheet:- work sheet is the combination of row and columns. In work sheet there are 65,536 (1 to 65,536) row or 256(A to iv) column.
Rows:- Row is the horizontal line of the cells in work sheet name as 123….
Columns:- column is vertical line of the cells in a work sheet named as A,B,C,D,E
Cell:- Cell is the rectangular block in a work sheet . It is the meet point of row and column.
Cell Range :- Cell Range is the rectangular block of the grouped cells cell range is donate By colon (:) sign like A5:d5, c3:g3…..
Cell Address:- Cell Address of any cell is known as cell has its own address donated by column name and row number like A3:b3
How to remove greed lines.
- Click on tools menu
- Click on option
- Click on view box
- Click an active the greed line box
- Click on ok
How to create table (bill).
- Block the rows and column number
- Click on format menu
- Click on cells
- Click on boarder box
- Choose line style
- Click on out line and inside box
- Click on ok
How to increase and decrease column width.
- Block the column
- Click on format menu
- Click on column
- Click on width
- Type width number
- Click on ok
How to increase and decrease rows height.
- Block the rows
- Click on format menu
- Click on rows
- Click on height
- Type height number
- Click on ok
How to insert new column.
- Block the column which you want to insert the just left side
- Click on insert menu
- Click on column
How to insert new Rows.
- Block the rows which is you want to insert the just above
- Click on insert menu
- Click on rows
How to delete rows and column.
- Block the rows and column
- Click on edit menu
- Click on delete
How to fill color in table cell.
- Block the cell
- Click on format menu
- Click on cell
- Click on pattern box
- Choose any color
- Click on ok
How to hide columns.
- Block the column
- Click on format menu
- Click on hide
- Click on ok
How display the hidden columns.
- Block the all cell (ctrl +A)
- Click on format menu
- Click on unhide
How to set text alignment.
- Block the area
- Click on format menu
- Click on cells
- Click on alignment box
- Choose horigental and vertical alignment
- Active the merge cells box
- Click on ok
How to remove sheet name.
- Block the sheet name
- Click on format menu
- Click on sheet
- Click on rename
- Type on new sheet name exam: ram
- Press enter key
How to insert new sheet.
- Click on insert menu
- Click on work sheet
How to copy sheet.
- Block the sheet name
- Click on edit menu
- Select move or copy sheet
- Active the create a copy box and ok
How to delete sheet.
- Block the sheet name
- Click edit menu
- Click on delete sheet
- Click on deleted
How to hide the sheet.
- Block the sheet name
- Click on format menu
- Click on sheet
- Click on hide
How to display the hidden sheet.
- Click on format menu
- Click on sheet
- Click on un hide
- Choose any one sheet name
- Click on ok
How to protection sheet name.
- Block the sheet name
- Click on tools menu
- Click on protection
- Click on protection sheet
- Type protection name ex: 123
- Type re protection name ex: 123
- Click on ok
How to unprotect sheet.
- Block the protect sheet
- Click on tools menu
- Click on protection
- Click on un protection
- Type protection name ex:123
- Click on ok
How to create graph (chart).
- Create the data
| India | Pakistan | |
| 0-10 | 50 | 55 |
| 10-20 | 110 | 111 |
| 20-30 | 160 | 170 |
| 30-40 | 201 | 220 |
| 40-50 | 250 | 255 |
- Block the data
- Click on insert menu
- Click on chart
- Choose one chart ex: column chart
- Click in next box
- Choose one series ex: column
- Click on next box
- Choose put the required title area
- Click on finish box
How to change column color.
- Block the column
- Double click on the select chart
- Click on pattern box
- Choose one pattern style, color, texture etc.
- Click on ok
How to show value in chart.
- Block the chart
- Click the right button on selected chart
- Click on chart option
- Click on data label box
- Active the show value box
- Click on ok
How to show the data in chart.
- Block the chart
- Click the right button on selected chart
- Click on chart type
- Click on data table box
- Active the show data table box
- Click on ok
How to change chart.
- Active the chart
- Click on chart menu
- Click on chart type
- Choose any one graph style
- Click on ok
How to insert gridlines in chart.
Active the chart
Click right button on chart
Click on chart option
Click on gridlines
Active the two button of gridlines.
Click on ok.
How to remove chart gridlines.
- Active the chart
- Click on chart menu
- Click on chart option
- Click on grid line
- Un active the major grid line
How to change the legend area.
- Double click on the legend area
- Click on placement box
- Choose one place exam: left
- Click on ok
How to remove background pattern in chart.
- Double click on the chart area
- Click on pattern box
- Active the none box
- Click on ok
Bill
| Item name | quty. | Rate | Amount | Less% | Vat %13 | Other | Net amount |
| Copy | 32 | 12 | |||||
| Pen | 15 | 10 | |||||
Multiply formula :- b2*c2 / =sum(b2*c2)
Percent formula:- d2*5% / =sum(d2*5/100)
Vat formula :- =sum(d2-e2)*13%
Net amount formula:- =sum(d2+f2+g2)-e2
Data form:- It helps to the data from in which we can add new data easy method.
- Create the formula data
| Item name | quty. | Rate | Amount | Less% | Vat %13 | Other | Net amount |
| Copy | 32 | 12 | 384 | 30.80 | 40 | 20 | 414.80 |
| Pen | 15 | 10 | 150 | 15 | 18 | 10 | 163 |
- Block the data
- Click on data menu
- Click on form
- Put the new data
Data short:- It helps to manage in ascending and descending order
- Active the data
- Click on data menu
- Click on short
- Click on short by box
- Choose on box
- Active the ascending or descending box
- Click on ok
Sub total: – To calculation the current sub total amount.
- Active the data
- Click on data menu
- Click on sub total
- Choose any one function exam: sum
- Click on ok
Goal seek:- To show the required value in data.
- Crete the formula data
| Item name | quty. | Rate | Amount |
| Copy | 32 | 12 | 404 |
| Pen | 15 | 10 | 150 |
- Block the cell which you want change
- Click on tools menu
- Type change the value in to value box example:- 500
- Type the changing call in by changing cell example:- c7
- Click goal seek
- Click on ok
- Click on ok
Auditing:- It helps to checked the formula.
- Keep the cell point in the cells
- Click on tools menu
- Click on auditing option
- Click on trace precedents
How to remove auditing arrow.
- Click on tools menu
- Click on auditing
- Click on remove all arrow
Filter:- It helps to filter the data from source the data.
- Block the data
- Click on data menu
- Click on filter
- Click on auto filter
- Click on one filter sign exam:- math
- Choose one number exam:- 60
- Click on ok
How to clear auto filter.
- Click on data menu
- Click on filter
- Click on auto filter
- Click on inactive filter
Freeze pane:- It helps to lock the rows number.
- Choose the cell pointer
- Click on windows menu
- Click on freeze panes
- Click on ok
How to delete freeze panes.
- Click on windows menu
- Click on unfreeze panes
Basic salary sheet
| s. no. | Name | B. salary | Working day | Total salary | Bonus % | Vat % | Advance | Net salary | Dues salary |
| 1 | samir | 12000 | 22 | ||||||
| 2 | |||||||||
Total salary:- =12000*22/30
Bonus salary :- =total salary*bonus% =10000*10%
Vat salary:- =(total salary+ bonus)*vat% =(10000+1000)* 13/100
Net salary:- =(total salary+ bonus%)-vat%
Dues salary:- = (Net salary- advance)
Other formula
=average salary(data range) or = average(c2:c9) (To calculate Average salary)
=max(data range) or =max(c2:c9) (To calculate maximum value)
=min(data range) or =min(c2:c9) (To calculator minimum value)
=count(data range) or =count(c2:c9) (To calculate value)
=squrt(data range) or =squrt(n) or =squrt(c2) (To square root of any number)
=today() (To insert current date)
=now() (To insert new current date and time)
A B C D Mark sheet
| name | English | Math | Nepali | Science | Social | Population | Health | Opt math | Toal mark | % mar k | Result | Division | Re mark |
| Samir | 80 | 54 | 55 | 45 | 65 | 75 | 45 | 98 | |||||
Total mark =SUM(D9:K9) (press enter button)
Total % mark =SUM(L10*100/800) (press enter button)
Result =IF(AND(D9>=32,E9>=32,F9>=32,G9>=32,H9>=32,I9>=32,
J9>=32,K9>=32),”pass”, “fail”) (press enter button)
Division formula:- =if (m2=”pass” ,if (l2>=60, “1st”,if(l2>=45,”2nd”,”3rd”)),”fail”)
(press enter button)
Remark :- =if(m2=“pass” ,if(l2>=80, “excellent”, if(l2>=60, “best”, if
(l2>=45, “better”, “good”))) , “no remark”) (press enter button)
Power point
MS Power point: – Software that is used for effective presentation on any subject by animated display with organized sequence. It is a part of MS-Office. It is developed by Microsoft Corporation.
Its extension is .ppt.
How to open ms power point.
- Click start bar
- Click on run
- Type powerpnt
- Click on ok or enter button
Or
- Click start bar
- Click program option
- Click on Accessories
- Click on ms power point
Slide: – Slide is a container where many objects can be placed for display.
There can be multiple slides in a project.
How to create new slide.
- Click insert menu
- Click on new slide
How to delete slide.
- Select the slide
- Press the delete key
Slide Design:- Is used for applying the different style of background effect and contains in slide.
How to design slide
- Click format menu
- Click on slide design
- Click on slide template
How to color slide design.
- Click format menu
- Click on slide design
- Click on color schemes
- Choose any on color style
How to animation slide.
- Click format menu
- Click on slide design
- Click on animation schemes
- Choose any on animation style apply to selected box.
How to slide show.
- Click slide show menu
- Click on show view
Or
Press f5
How to create grid and guide in slide.
- Click view menu
- Click on grid and guide option.
- Active grid on screen option.
- Active drawing guide and screen in slide.
How to clear grid and guide.
- Click view menu
- Click on grid and guide option.
- enactive grid on screen option.
- enactive drawing guide and screen option.
How to change the slide color.
- Click on format menu
- Click on background
- Click on fill color
- Click on effect color
- Click on ok
How to add effect in background.
- Click on slide show menu
- Click on slide transition option
- Choose any one slide style (apply to selected box )
- Click on modify transition box and choose any one style speed and sound
- Click on apply to all slide
How to create duplicate slide.
- Click on insert menu
- Click on duplicate slide
How to create slide layout
- Click on format menu
- Click on slide layout
- Choose any one slide layout box
Running the Slide:- After the designing completion of slide we can run to view for presentation.
Slide Show — View Slide Show
OR
F5 (short cut key)
Text Box:- Is the box where text can be written and can be moved from one place to next place.
Slide lay out:- Applies the style of layout contents of slide. It provides the various types of automatic prepared layout style.
Internet
I-nternet: Is a huge networking system among computer that is widely used from one
location to another location to share the files and information. It has converted our universe
into concept of global village. There are many advantage of internet that are been translated
in our today’s daily applied subject. –
# Send and Receive the E-mails.
# can search for any kind of information regarding on any subject.
# Conference, Voice Mail
# Much effective media for instant messaging.
.
Requirement for internet access:- There is some fundamental thing that requires accessing the internet.
1.User Account:- Account is validity of user whether user do have rights of accessing internet or not.
2.Password:- Password is key to verify of right user regarding the user account.
3.Phone Line:- Is needed to connect the PC to in
ternet for dialing the ISP Server.
4.Modem:- Is the device attached in computer that keeps on translating signals
to digit and digit to signals by connecting with phone line.
Internet Browser:- Is the program in computer that opens the web pages in display
the contents to user. Examples are like: Internet Explorer, Netscape Navigator,
Mazola and Eudora.
Web Site:- Is a collection of individual web pages which is identified by its unique
domain name.
Web Page:- Is an individual part of web site that carries the particular.
www means (World Wide Web ).
http: is protocol of information sharing.
Hyperlink:- Is connection between two pages which helps user to open next page from current page.
Formation of Web Site Name:-
www + website name + com
example www.hotmail.com, www.yahoo.com etc.
Email:- Is technology that makes people to send and receive the message instantly.
Main benefit using e-mail is it can be accessed from any part of the world. There are various website that provides the email facility. Like hotmail.com, yahoo.com,
gmail.com etc.
User Account:- To access the email user to have subscribed the user account in any website that provides the email facility. Each website asks the bio-data when while creating the new account. When account is created user is given user name and password to access the email service.
Email Objects:- In every email portal there is some common object which bears same functionality. They are like.
1. Inbox:- Is the portion in email where incoming mails are stored. To check new
mail user should go to inbox. New or unread messages are highlighter with
bold formatted.
2. Compose:- Is the portion where user can create the new message for sending purpose. It contains various parts like
a To:- Where recipient addresses are mentioned. (Type the message which you want to send the message)
b. CC:- Stands for carbon copy and is used for sending the same mail to multi recipient.
d. Subject:- Where subject of the mail is specified.(The main topic of the mail)
e. Message Body:- Where exactly the contains of mail is written.
f. Send Button:- This button sends the mail to address that is mentioned in To:- Box.
g. Attach:- This hyperlink is used for attaching any other files if exist along with mail.
3. Delete Button:- We can delete unwanted mails from mail account by using delete button. By applying tick mark by clicking the mail in check box then clicking delete button removes the mail.
4. Sign Out:- Takes out from the mails account.
5. Sent: is the portion where sent mails are stored.
Checking mail:- Click on Mail which to open on the column of subject.
REPLY MAILS:- we can reply the current mail directly to the sender by not going to compose section
Click on Reply Button
How to create user id in internet e-mail.
- Double click on internet icon figure
- Type www.yahoo.com in web browser box
- Click on sign up box
Type personal information
Type First name: …………………..
Type Last name:- ……………………
Type Email id :- ……………………. @yahoo.com
Type pass word :- …………………. (minimum 6 character)
Type re pass word:- ………………….
Type date of birth:- …………………..
Type country:- ………………………..
Type country code:- ………00977………………
Type alter net id :- ………………………..(other id )
Select question:- …………………………….
Select answer :- ……………………………..
Type show code (according to show code )
- Click on submit box
Please wait some time
How to see (open) any web site?
- Double click on internet icon figure
- Type any web site www.yahoo.com ,google.com, gmail.com in web browser box
- Press enter button (wait some time)
How to send e-mail message.
- Double click on internet icon figure
- Type www.yahoo.com in web browser box
- Click on sign in box
- Click on send box
- Type e-mail ID (in our ID) in from box.
- Type e-mail ID (home your want to) In To box.
- Type e-mail ID (same message send other ID) in CC box.
- Type message title which you want to subject (in subject box) example:- for the post of computer engineering
- Type massage
- Click on send button box
Note:-please wait for some time
How to receive e-mail message.
- Double click on internet icon figure
- Type www.yahoo.com in web browser box
- Type e-mail ID or pass word
- Click on sign in box
- Click on inbox
- Click on massage subject box (which you want to receive message)
Note:- At last read your massage.
How to change password.
- Double click on messenger icon figure
- Type personal ID or password
- Click on ok or press enter button
- Click on messenger option
- Click on user account
- Click on change password
- Type old password
- Type new password
- Type renew password
- Click on ok or (press enter button)
How searching for desired information.-
- Double click on internet icon figure
- Type google.com in web browser box
- Type any thing (which you want to) example:- “national medical collage”
- Click on go box or (press enter button)
Note :- wait some time
| THE END |


