Steps of Mail-Merge
|
Type Document and save
|
|
|
|
Mailing Menu
|
|
|
|
Start Mail Merge
|
|
|
|
Step By Step Mail Merge Wizard
|
|
|
|
Use the Current Document
|
|
|
|
Select Recipients
|
|
|
|
Type a new list then create or use an
existing list
|
|
|
|
Type all address here and press OK
|
|
|
|
Then save the list in which drive you would
like to save.
|
|
|
|
Insert Merge Fields
|
|
|
|
Then press preview result and click on Next
record for No-2 address
|
SHORTCUT KEYS
|
F1
|
-
|
Displays
Help window.
|
|
F2
|
-
|
Renames
currently highlighted object.
|
|
F3
|
-
|
Displays
the window search dialogue box.
|
|
F4
|
-
|
Positions
cursor at the address bar in windows and internet explorer.
|
|
F5
|
-
|
Refreshes
contents in windows internet explorer.
|
|
Window
Key + D
|
-
|
Minimizes
all open windows and displays the desktop.
|
|
Window
Key + Tab
|
-
|
Cycles
through open applications via the task bar.
|
|
Window
Key + E
|
-
|
Starts
windows explorer to browser local computer.
|
|
Window
Key + F
|
-
|
Displays
the windows search dialogue box.
|
|
Window
Key + Ctrl + F
|
-
|
Displays
the windows search for computers dialogue.
|
|
Window
Key + F1
|
-
|
Displays
the Microsoft windows help window.
|
|
Window
Key + L
|
-
|
Lock
the computer.
|
|
Window
Key + M
|
-
|
Minimizes
all open windows.
|
MS WORD
1. MS
Word Commands.
(a) Insertion Pointer Movements.
Move Key/Key combination
(i) One character to the left Left Arrow
(ii)
One
character to the right Right
Arrow
(iii)
One
line up Up
Arrow
(iv)
One
line down Down
Arrow
(v)
One
word to the left Ctrl
+ Left Arrow
(vi)
One
word to the right Ctrl
+ Right Arrow
(vii)
To the end of a line End
(viii)
To the start of a line Home
(ix)
Down
one screen Pg
Down
(x)
Up
one screen Pg
Up
(xi)
To
the start of a document Ctrl
+ Home
(xii)
To the end of a document Ctrl + End
(xiii)
To any page of a document F5
(xiv)
Back to list insertion point Shift + F5
(b) Text Selection.
Select Key/Key
Combination
(i) Left Character Shift + Left Arrow
(ii)
Right
Character Shift
+ Right Arrow
(iii)
Previous
Line Shift
+ Up Arrow
(iv)
Next
Line Shift
+ Down Arrow
(v)
Extended
Selection F8
(vi)
Shrink
Selection Shift
+ F8
(vii)
Column Ctrl
+ Shift
(c) Text Entry Formatting.
Format Key/Key
Combination
(i) Insert New Paragraph Enter
(ii)
Insert
New Line Shift
+ Enter
(iii)
Insert
Hard Page Break Ctrl +
Enter
(iv)
Insert
Column Break Ctrl +
Shift + Enter
(v)
Insert
Normal Hyphen Hyphen
(vi)
Insert
Optional Hyphen Ctrl +
Hyphen
(vii)
Insert Hard Hyphen Ctrl + Shift + Hyphen
(viii)
Insert Hard space Ctrl + Shift + Space Bar
(ix)
Change
case Ctrl + Shift + K/ Shift +
F3
(d) Text Editing.
Edit Key/Key Combination
(i) Move selected text F2
(ii)
Copy
selected text Shift
+ F2
(iii)
Delete
character to the right Delete
(e) Font Formatting.
Format Key/Key
Combination
(i) Increase point size Ctrl + }
(ii)
Decrease
point size Ctrl +
{
(iii)
Change
point size Ctrl
+ Shift + P
(iv)
Change
case Shift
+ F3
(v)
Remove
formatting Ctrl +
Space Bar
(vi)
Capitalize
Ctrl
+ Shift + A
(vii)
Capitalize (Small caps) Ctrl + Shift + K
(viii)
Bold Ctrl
+ B
(ix)
Italic Ctrl
+ I
(x)
Underline Ctrl +
U
(xi)
Underline
words, but not spaces Ctrl + Shift + W
(xii)
Double Underline Ctrl + Shift + D
(xiii)
Enlarge Font Ctrl
+ Shift + > (greater than)
(xiv)
Subscript Ctrl
+ Equal key(=)
(xv)
Superscript Ctrl
+ Plus key(+)
(xvi)
Decrease Font size Ctrl + Shift + <(less than)
(xvii)
Drop Caps Alt
+ O + D
(xviii)
Insert Formula Alt + A + O
(xix)
Text direction Alt + O + X
(f) Paragraph Formatting.
Format Key/Key combination
(i) Single space line Ctrl + 1
(ii)
Double
space line Ctrl
+ 2
(iii)
1 ½
space line Ctrl
+ 5
(iv)
Center
Line Ctrl
+ E
(v)
Left
align lines Ctrl
+ L
(vi)
Right
align lines Ctrl
+ R
(vii)
Justify lines Ctrl
+ J
(viii)
Remove paragraph Ctrl + Q
(g) File
and Window Management.
Format Key/Key combination
(i) Save as F12
or Alt + F2
(ii)
Open Ctrl
+ O
(iii)
Close
document window Ctrl + F4
(iv)
Restore
document window Ctrl F10
(v)
Close
Active window Alt + F4
(vi)
Next
window Ctrl
+ F6 or Alt +F6
(vii)
Previous window Ctrl + Shift + F6 or Alt + Shift + F6
(viii)
Next page F6
(xi) Previous page Shift + F6
(h) Miscellaneous.
Function Key/Key combination
(i) Help F1
(ii)
Help
pointer Shift
+ F1
(iii)
Repeat
command F4
(iv)
Repeat
Find/ Go to Shift
+ F4
(v)
Spelling
& Grammar check F7
(vi)
Thesaurus
Shift
+ F7
(vii)
Menu F10
(viii)
Print Ctrl
+ Shift + F12 or Ctrl + P
(ix)
Undo Ctrl
+ Z
(x)
Redo Ctrl
+ Y
(xi)
Go
to Ctrl
+ G
MICRO SOFT
EXCEL
1. Commands
of Excel.
(a)
New
Workbook - Ctrl + N
(b)
Open
- Ctrl + O
(c)
Save
- Ctrl + S
(d)
Print
- Ctrl + P
(e)
Cut - Ctrl + X
(f)
Copy - Ctrl + C
(g)
Undo - Ctrl + Z
(h)
Repeat - Ctrl + Y
(j) Find - Ctrl + F
(k) Go
to - Ctrl + G
(l) Format
Cell - Ctrl + I
(m) Spell
Check - F7
(n) Help
- F1
(o) Bold - Ctrl + B
(p) Underline
- Ctrl + U
(q) Italic
- Ctrl + I
(r) Cancel a command - Esc
(s) Undo - Alt + E +U
(t) Repeat
- Alt + E+P
(u) New
Work Book - Alt + F, Ctrl + N
(v) To
beginning of row - Home
(w) To
cell A1 beginning - Ctrl + Home
(x) Left
/ Next Worksheet - Ctrl + Page Up
(y) Delete Cell - Alt
+ E +D
(z) Choose
edit copy - Alt +E+C
(aa) Paste - Alt + E+S
(ab) New
worksheet - Shift+F11
(ac) Merge
& Centre - Alt + H + MC
ORDER OF
PRECEDENCE RULES
|
Formula
(A1=50,
B1=10, C1=5)
|
Order of
Precedence Rule
|
Result
|
|
= A1+B1*C1
|
Multiplication
before addition.
|
100
|
|
= (A1+B1)*C1
|
Expression
inside parentheses executed before expression outside.
|
300
|
|
= A1/B1- C1
|
Division
before subtraction.
|
0
|
|
= A1/(B1- C1)
|
Expression
inside parentheses executed before expression outside.
|
10
|
|
= A1/B1*C1
|
Two
operators at same precedence level, leftmost operator evaluated first.
|
25
|
|
= A1/(B1*C1)
|
Expression
inside parentheses executed before expression outside.
|
1
|
FULL FORMS
|
BIOS
|
BASIC INPUT /
OUTPUT SYSTEM
|
|
FAT
|
FILE ALLOCATION
TABLE
|
|
SMPS
|
SWITCH MODE POWER
SUPPLY
|
|
SATA
|
SERIAL ADVANCED
TECHNOLOGY ATTACHMENT
|
|
SAS
|
SERIAL ATTACHED
SCSI
|
|
BUS
|
BIDIRECTIONAL
UNIVERSAL SWITCH
|
|
USB
|
UNIVERSAL SERIAL
BUS
|
|
AGO
|
ACCELERATED
GRAPHICAL PORT
|
|
CRT
|
CATHOD RAY TUBE
|
|
DOS
|
DISC OPERATING
SYSTEM
|
|
VDU
|
VISUAL DISPLAY UNIT
|
|
VGA
|
VIDEO GRAPHIC ARRAY
|
|
LCD
|
LIQUID CRYSTAL
DISPLAY
|
|
LED
|
LIGHT EMITTING
DIODE
|
|
DVD
|
DIGITAL VERSATILE
DISC
|
Comments
Post a Comment