Body language includes facial expressions, gestures postures, smell, touch, voice and sounds. Facial expressions may express feelings of love, hatred, anger, joy, sorrow, worn tiredness, anxiety, suspense, satisfaction, fear, zeal, surprise approval, pride, etc. People can communicate many moods through gestures and posture. Nod of head, shake of head, bow of head, shrug of shoulder, closed eyes, droop of shoulder show of hand, point of linger, tapping of fingers, clenched fist thumb-up sign, folded arms, crossed legs, handshakes, etc. say many things. Posture means style of standing. It indicates confidence or nervousness.
Smell is a strong communicant. Fragrances convey positively. Touch may communicate feelings of love, affection hatred, or anger. A kiss, a pat, a slap, a pinch, a tickle, a push a pull, and a fist communicate different messages. Then hoi you speak is also very important. Your voice quality and extra sounds you make while speaking are part of nonverbal communication called paralanguage. Pleasant voice has a good impression upon the others.
Wednesday, October 28, 2009
how i can define communication?
DEFINITION OF COMMUNICATION
The exchange of messages between human beings is known as communication. The peace of the world, the progress of an organization, and success of a person depend upon communication. We send and receive messages through words, pictures, signs, or body language. Communication may be verbal or nonverbal. Business communication is the exchange of messages in the business world.
Origin
The word "communication" comes from the Latin word, communicate, meaning to share, to have in common. From earliest times, communication and closely linked words such as commune, communion, and communicant have meant to share to partake, to exchange, and to hold in common.
Definition
"Communication means the search for all the available means of persuasion (Aristotle)
"Communication is the main highway to all human relations."
(Prof. Parkhurst)
"Communication is the action of conveying or exchanging information and ideas.
The exchange of messages between human beings is known as communication. The peace of the world, the progress of an organization, and success of a person depend upon communication. We send and receive messages through words, pictures, signs, or body language. Communication may be verbal or nonverbal. Business communication is the exchange of messages in the business world.
Origin
The word "communication" comes from the Latin word, communicate, meaning to share, to have in common. From earliest times, communication and closely linked words such as commune, communion, and communicant have meant to share to partake, to exchange, and to hold in common.
Definition
"Communication means the search for all the available means of persuasion (Aristotle)
"Communication is the main highway to all human relations."
(Prof. Parkhurst)
"Communication is the action of conveying or exchanging information and ideas.
Monday, October 26, 2009
Tips for Applying a JOB
* Search the job market for opportunities that interest you and study their requirements carefully.
* Make sure you CV is well-written, and free of typos! Highlight you strenght, as well as internships and college activities you took part in.
* Your dream job may be miles away. Sitting and worrying about it will not help. Take up an alternate less desired job.
* No one wants to scruffy, Sweety employe. Dress formally, Ettiquette and manners count for a lot, so lift up those feet.
* Make sure you CV is well-written, and free of typos! Highlight you strenght, as well as internships and college activities you took part in.
* Your dream job may be miles away. Sitting and worrying about it will not help. Take up an alternate less desired job.
* No one wants to scruffy, Sweety employe. Dress formally, Ettiquette and manners count for a lot, so lift up those feet.
Sunday, October 25, 2009
How i can reposition my toolbar in MS-OFFICE
Toolbar can be repositioned on your screen by simply moving the mouse pointer onto the toolbar then left clicking and dragging the toolbar across the screen. Once the toolbar is in the correct release the mouse button.
Auto format will automatically standardize the format of documents for you. Once you’ve finished typing a documents go the format menu and choose Auto format. Choose a type of documents from the drop-down list and click on auto format and review each change. Click ok. Word will now standardize the style in your document so it is consistently formatted and will allow you to accept or reject its suggested changes.
Auto format will automatically standardize the format of documents for you. Once you’ve finished typing a documents go the format menu and choose Auto format. Choose a type of documents from the drop-down list and click on auto format and review each change. Click ok. Word will now standardize the style in your document so it is consistently formatted and will allow you to accept or reject its suggested changes.
Saturday, October 24, 2009
How i can use nokia codes?
.:: NOKIA ::.Universal Codes
Code Description :
These Nokia codes will work on most Nokia Mobile Phones
(1) *3370# Activate Enhanced Full Rate Codec (EFR) - Your phone uses the best sound quality but talk time is reduced my approx. 5%
(2) #3370# Deactivate Enhanced Full Rate Codec (EFR) OR *3370# ( Favourite )
(3) *#4720# Activate Half Rate Codec - Your phone uses a lower quality sound but you should gain approx 30% more Talk Time.
(4) *#4720# Deactivate Half Rate Codec.
5) *#0000# Displays your phones software version, 1st Line : Software Version, 2nd Line : Software Release Date, 3rd Line : Compression Type. ( Favourite )
(6) *#9999# Phones software version if *#0000# does not work.
(7) *#06# For checking the International Mobile Equipment Identity (IMEI Number). ( Favourite )
(8) #pw+1234567890+1# Provider Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(9) #pw+1234567890+2# Network Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(10) #pw+1234567890+3# Country Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(11) #pw+1234567890+4# SIM Card Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(12) *#147# (vodafone) this lets you know who called you last.
(13) *#1471# Last call (Only vodofone).
(14) *#21# Allows you to check the number that "All Calls" are diverted to
(15) *#2640# Displays security code in use.
(16) *#30# Lets you see the private number.
(17) *#43# Allows you to check the "Call Waiting" status of your phone.
(18) *#61# Allows you to check the number that "On No Reply" calls are diverted to.
(19) *#62# Allows you to check the number that "Divert If Unreachable (no service)" calls are diverted to.
(20) *#67# Allows you to check the number that "On Busy Calls" are diverted to.
(21) *#67705646# Removes operator logo on 3310 & 3330.
(22) *#73# Reset phone timers and game scores.
(23) *#746025625# Displays the SIM Clock status, if your phone supports this power saving feature "SIM Clock Stop Allowed", it means you will get the best standby time possible.
24) *#7760# Manufactures code.
(25) *#7780# Restore factory settings.
26) *#8110# Software version for the nokia 8110.
(27) *#92702689# Displays - 1.Serial Number, 2.Date Made, 3.Purchase Date, 4.Date of last repair
(0000 for no repairs), 5.Transfer User Data. To exit this mode you need to switch your phone off then on again. (Favourite )
(28) *#94870345123456789# Deactivate the PWM-Mem.
(29) **21*number# Turn on "All Calls" diverting to the phone number entered.
(30) **61*number# Turn on "No Reply" diverting to the phone number entered.
(31) **67*number# Turn on "On Busy" diverting to the phone number entered.
(32) 12345 This is the default security code.
press and hold # Lets you switch between lines
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #
Provider lock status: #pw+1234567890+1
Network lock status #pw+1234567890+2
Provider lock status: #pw+1234567890+3
SimCard lock status: #pw+1234567890+4
NOKIA 6110/6120/6130/6150/6190
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #
NOKIA 3110
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 # or * # 9 9 9 9 # or * # 3 1 1 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
NOKIA 3330
*#06# This will show your warranty details *#92702689#
*3370# Basically increases the quality of calling sound, but decreases battery length.
#3370# Deactivates the above
*#0000# Shows your software version
*#746025625#This shows if your phone will allow sim clock stoppage
*4370# Half Rate Codec activation. It will automatically restart
#4370# Half Rate Codec deactivation. It will automatically restart
Restore Factory Settings To do this simply use this code
*#7780# Manufacturer Info Date of Manufacturing *#3283#
*3001#12345# (TDMA phones only) This will put your phone into programming mode, and you'll be
presented with the programming menu.
2) Select "NAM1"
3) Select "PSID/RSID"
4) Select "P/RSID 1"
Note: Any of the P/RSIDs will work
5) Select "System Type" and set it to Private
6) Select "PSID/RSID" and set it to 1
7) Select "Connected System ID"
Note: Enter your System ID for Cantel, which is 16401 or 16423. If you don't know yours, ask your local dealer for it.
8) Select "Alpha Tag"
9) Enter a new tag, then press OK
10) Select "Operator Code (SOC)" and set it to 2050
11) Select "Country Code" and set it to 302 for Canada, and 310 for the US.
12) Power down the phone and power it back on again ISDN Code To check the ISDN number on your Nokia use this code *#92772689#.::
Code Description :
These Nokia codes will work on most Nokia Mobile Phones
(1) *3370# Activate Enhanced Full Rate Codec (EFR) - Your phone uses the best sound quality but talk time is reduced my approx. 5%
(2) #3370# Deactivate Enhanced Full Rate Codec (EFR) OR *3370# ( Favourite )
(3) *#4720# Activate Half Rate Codec - Your phone uses a lower quality sound but you should gain approx 30% more Talk Time.
(4) *#4720# Deactivate Half Rate Codec.
5) *#0000# Displays your phones software version, 1st Line : Software Version, 2nd Line : Software Release Date, 3rd Line : Compression Type. ( Favourite )
(6) *#9999# Phones software version if *#0000# does not work.
(7) *#06# For checking the International Mobile Equipment Identity (IMEI Number). ( Favourite )
(8) #pw+1234567890+1# Provider Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(9) #pw+1234567890+2# Network Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(10) #pw+1234567890+3# Country Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(11) #pw+1234567890+4# SIM Card Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(12) *#147# (vodafone) this lets you know who called you last.
(13) *#1471# Last call (Only vodofone).
(14) *#21# Allows you to check the number that "All Calls" are diverted to
(15) *#2640# Displays security code in use.
(16) *#30# Lets you see the private number.
(17) *#43# Allows you to check the "Call Waiting" status of your phone.
(18) *#61# Allows you to check the number that "On No Reply" calls are diverted to.
(19) *#62# Allows you to check the number that "Divert If Unreachable (no service)" calls are diverted to.
(20) *#67# Allows you to check the number that "On Busy Calls" are diverted to.
(21) *#67705646# Removes operator logo on 3310 & 3330.
(22) *#73# Reset phone timers and game scores.
(23) *#746025625# Displays the SIM Clock status, if your phone supports this power saving feature "SIM Clock Stop Allowed", it means you will get the best standby time possible.
24) *#7760# Manufactures code.
(25) *#7780# Restore factory settings.
26) *#8110# Software version for the nokia 8110.
(27) *#92702689# Displays - 1.Serial Number, 2.Date Made, 3.Purchase Date, 4.Date of last repair
(0000 for no repairs), 5.Transfer User Data. To exit this mode you need to switch your phone off then on again. (Favourite )
(28) *#94870345123456789# Deactivate the PWM-Mem.
(29) **21*number# Turn on "All Calls" diverting to the phone number entered.
(30) **61*number# Turn on "No Reply" diverting to the phone number entered.
(31) **67*number# Turn on "On Busy" diverting to the phone number entered.
(32) 12345 This is the default security code.
press and hold # Lets you switch between lines
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #
Provider lock status: #pw+1234567890+1
Network lock status #pw+1234567890+2
Provider lock status: #pw+1234567890+3
SimCard lock status: #pw+1234567890+4
NOKIA 6110/6120/6130/6150/6190
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #
NOKIA 3110
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 # or * # 9 9 9 9 # or * # 3 1 1 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
NOKIA 3330
*#06# This will show your warranty details *#92702689#
*3370# Basically increases the quality of calling sound, but decreases battery length.
#3370# Deactivates the above
*#0000# Shows your software version
*#746025625#This shows if your phone will allow sim clock stoppage
*4370# Half Rate Codec activation. It will automatically restart
#4370# Half Rate Codec deactivation. It will automatically restart
Restore Factory Settings To do this simply use this code
*#7780# Manufacturer Info Date of Manufacturing *#3283#
*3001#12345# (TDMA phones only) This will put your phone into programming mode, and you'll be
presented with the programming menu.
2) Select "NAM1"
3) Select "PSID/RSID"
4) Select "P/RSID 1"
Note: Any of the P/RSIDs will work
5) Select "System Type" and set it to Private
6) Select "PSID/RSID" and set it to 1
7) Select "Connected System ID"
Note: Enter your System ID for Cantel, which is 16401 or 16423. If you don't know yours, ask your local dealer for it.
8) Select "Alpha Tag"
9) Enter a new tag, then press OK
10) Select "Operator Code (SOC)" and set it to 2050
11) Select "Country Code" and set it to 302 for Canada, and 310 for the US.
12) Power down the phone and power it back on again ISDN Code To check the ISDN number on your Nokia use this code *#92772689#.::
How i can use nokia codes?
.:: NOKIA ::.Universal Codes
Code Description :
These Nokia codes will work on most Nokia Mobile Phones
(1) *3370# Activate Enhanced Full Rate Codec (EFR) - Your phone uses the best sound quality but talk time is reduced my approx. 5%
(2) #3370# Deactivate Enhanced Full Rate Codec (EFR) OR *3370# ( Favourite )
(3) *#4720# Activate Half Rate Codec - Your phone uses a lower quality sound but you should gain approx 30% more Talk Time.
(4) *#4720# Deactivate Half Rate Codec.
5) *#0000# Displays your phones software version, 1st Line : Software Version, 2nd Line : Software Release Date, 3rd Line : Compression Type. ( Favourite )
(6) *#9999# Phones software version if *#0000# does not work.
(7) *#06# For checking the International Mobile Equipment Identity (IMEI Number). ( Favourite )
(8) #pw+1234567890+1# Provider Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(9) #pw+1234567890+2# Network Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(10) #pw+1234567890+3# Country Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(11) #pw+1234567890+4# SIM Card Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(12) *#147# (vodafone) this lets you know who called you last.
(13) *#1471# Last call (Only vodofone).
(14) *#21# Allows you to check the number that "All Calls" are diverted to
(15) *#2640# Displays security code in use.
(16) *#30# Lets you see the private number.
(17) *#43# Allows you to check the "Call Waiting" status of your phone.
(18) *#61# Allows you to check the number that "On No Reply" calls are diverted to.
(19) *#62# Allows you to check the number that "Divert If Unreachable (no service)" calls are diverted to.
(20) *#67# Allows you to check the number that "On Busy Calls" are diverted to.
(21) *#67705646# Removes operator logo on 3310 & 3330.
(22) *#73# Reset phone timers and game scores.
(23) *#746025625# Displays the SIM Clock status, if your phone supports this power saving feature "SIM Clock Stop Allowed", it means you will get the best standby time possible.
24) *#7760# Manufactures code.
(25) *#7780# Restore factory settings.
26) *#8110# Software version for the nokia 8110.
(27) *#92702689# Displays - 1.Serial Number, 2.Date Made, 3.Purchase Date, 4.Date of last repair
(0000 for no repairs), 5.Transfer User Data. To exit this mode you need to switch your phone off then on again. (Favourite )
(28) *#94870345123456789# Deactivate the PWM-Mem.
(29) **21*number# Turn on "All Calls" diverting to the phone number entered.
(30) **61*number# Turn on "No Reply" diverting to the phone number entered.
(31) **67*number# Turn on "On Busy" diverting to the phone number entered.
(32) 12345 This is the default security code.
press and hold # Lets you switch between lines
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #
Provider lock status: #pw+1234567890+1
Network lock status #pw+1234567890+2
Provider lock status: #pw+1234567890+3
SimCard lock status: #pw+1234567890+4
NOKIA 6110/6120/6130/6150/6190
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #
NOKIA 3110
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 # or * # 9 9 9 9 # or * # 3 1 1 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
NOKIA 3330
*#06# This will show your warranty details *#92702689#
*3370# Basically increases the quality of calling sound, but decreases battery length.
#3370# Deactivates the above
*#0000# Shows your software version
*#746025625#This shows if your phone will allow sim clock stoppage
*4370# Half Rate Codec activation. It will automatically restart
#4370# Half Rate Codec deactivation. It will automatically restart
Restore Factory Settings To do this simply use this code
*#7780# Manufacturer Info Date of Manufacturing *#3283#
*3001#12345# (TDMA phones only) This will put your phone into programming mode, and you'll be
presented with the programming menu.
2) Select "NAM1"
3) Select "PSID/RSID"
4) Select "P/RSID 1"
Note: Any of the P/RSIDs will work
5) Select "System Type" and set it to Private
6) Select "PSID/RSID" and set it to 1
7) Select "Connected System ID"
Note: Enter your System ID for Cantel, which is 16401 or 16423. If you don't know yours, ask your local dealer for it.
8) Select "Alpha Tag"
9) Enter a new tag, then press OK
10) Select "Operator Code (SOC)" and set it to 2050
11) Select "Country Code" and set it to 302 for Canada, and 310 for the US.
12) Power down the phone and power it back on again ISDN Code To check the ISDN number on your Nokia use this code *#92772689#.::
Code Description :
These Nokia codes will work on most Nokia Mobile Phones
(1) *3370# Activate Enhanced Full Rate Codec (EFR) - Your phone uses the best sound quality but talk time is reduced my approx. 5%
(2) #3370# Deactivate Enhanced Full Rate Codec (EFR) OR *3370# ( Favourite )
(3) *#4720# Activate Half Rate Codec - Your phone uses a lower quality sound but you should gain approx 30% more Talk Time.
(4) *#4720# Deactivate Half Rate Codec.
5) *#0000# Displays your phones software version, 1st Line : Software Version, 2nd Line : Software Release Date, 3rd Line : Compression Type. ( Favourite )
(6) *#9999# Phones software version if *#0000# does not work.
(7) *#06# For checking the International Mobile Equipment Identity (IMEI Number). ( Favourite )
(8) #pw+1234567890+1# Provider Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(9) #pw+1234567890+2# Network Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(10) #pw+1234567890+3# Country Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(11) #pw+1234567890+4# SIM Card Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(12) *#147# (vodafone) this lets you know who called you last.
(13) *#1471# Last call (Only vodofone).
(14) *#21# Allows you to check the number that "All Calls" are diverted to
(15) *#2640# Displays security code in use.
(16) *#30# Lets you see the private number.
(17) *#43# Allows you to check the "Call Waiting" status of your phone.
(18) *#61# Allows you to check the number that "On No Reply" calls are diverted to.
(19) *#62# Allows you to check the number that "Divert If Unreachable (no service)" calls are diverted to.
(20) *#67# Allows you to check the number that "On Busy Calls" are diverted to.
(21) *#67705646# Removes operator logo on 3310 & 3330.
(22) *#73# Reset phone timers and game scores.
(23) *#746025625# Displays the SIM Clock status, if your phone supports this power saving feature "SIM Clock Stop Allowed", it means you will get the best standby time possible.
24) *#7760# Manufactures code.
(25) *#7780# Restore factory settings.
26) *#8110# Software version for the nokia 8110.
(27) *#92702689# Displays - 1.Serial Number, 2.Date Made, 3.Purchase Date, 4.Date of last repair
(0000 for no repairs), 5.Transfer User Data. To exit this mode you need to switch your phone off then on again. (Favourite )
(28) *#94870345123456789# Deactivate the PWM-Mem.
(29) **21*number# Turn on "All Calls" diverting to the phone number entered.
(30) **61*number# Turn on "No Reply" diverting to the phone number entered.
(31) **67*number# Turn on "On Busy" diverting to the phone number entered.
(32) 12345 This is the default security code.
press and hold # Lets you switch between lines
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #
Provider lock status: #pw+1234567890+1
Network lock status #pw+1234567890+2
Provider lock status: #pw+1234567890+3
SimCard lock status: #pw+1234567890+4
NOKIA 6110/6120/6130/6150/6190
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #
NOKIA 3110
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 # or * # 9 9 9 9 # or * # 3 1 1 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
NOKIA 3330
*#06# This will show your warranty details *#92702689#
*3370# Basically increases the quality of calling sound, but decreases battery length.
#3370# Deactivates the above
*#0000# Shows your software version
*#746025625#This shows if your phone will allow sim clock stoppage
*4370# Half Rate Codec activation. It will automatically restart
#4370# Half Rate Codec deactivation. It will automatically restart
Restore Factory Settings To do this simply use this code
*#7780# Manufacturer Info Date of Manufacturing *#3283#
*3001#12345# (TDMA phones only) This will put your phone into programming mode, and you'll be
presented with the programming menu.
2) Select "NAM1"
3) Select "PSID/RSID"
4) Select "P/RSID 1"
Note: Any of the P/RSIDs will work
5) Select "System Type" and set it to Private
6) Select "PSID/RSID" and set it to 1
7) Select "Connected System ID"
Note: Enter your System ID for Cantel, which is 16401 or 16423. If you don't know yours, ask your local dealer for it.
8) Select "Alpha Tag"
9) Enter a new tag, then press OK
10) Select "Operator Code (SOC)" and set it to 2050
11) Select "Country Code" and set it to 302 for Canada, and 310 for the US.
12) Power down the phone and power it back on again ISDN Code To check the ISDN number on your Nokia use this code *#92772689#.::
Friday, October 23, 2009
Fifth Lesson Of Ms-Dos
Dir
Display the directory and Files
Dir/p
Display the directory and Files with page wise
Dir/w
Display the directory and Files with Width wise
Dir/w/p
Display the directory and Files with Page & Width wise.
Dir/w/p/s
Display the Sub directory and Files with Page & Width wise.
DATE
To Display and Change The Date
TIME
To Display and Change The Time
CLS
Clear The Screen.
MD
Made a New Directory
RD
Remove Directory
Display the directory and Files
Dir/p
Display the directory and Files with page wise
Dir/w
Display the directory and Files with Width wise
Dir/w/p
Display the directory and Files with Page & Width wise.
Dir/w/p/s
Display the Sub directory and Files with Page & Width wise.
DATE
To Display and Change The Date
TIME
To Display and Change The Time
CLS
Clear The Screen.
MD
Made a New Directory
RD
Remove Directory
Thursday, October 22, 2009
How i can write an application for job
Dated: ...............
[Company's High Authority Designation]
[Company Name]
[City]
Subject: Application for the post of...............
Respected Sir,
I feel immense pleasure and glee to offer my service to such a well reputed and career building organization. I have all the perquisites for this post commensurate with my qualifications and skills. An out line depicting my educational career & experience is separately attached herewith for your kind perusal.
It is therefore requested you to please provide me a chance to serve your apex organization. I will dispense my services as per company rules and will serve with dedication and zeal.
I will really be grateful to you.
Truly Yours,
-------------------
Your Name
[Company's High Authority Designation]
[Company Name]
[City]
Subject: Application for the post of...............
Respected Sir,
I feel immense pleasure and glee to offer my service to such a well reputed and career building organization. I have all the perquisites for this post commensurate with my qualifications and skills. An out line depicting my educational career & experience is separately attached herewith for your kind perusal.
It is therefore requested you to please provide me a chance to serve your apex organization. I will dispense my services as per company rules and will serve with dedication and zeal.
I will really be grateful to you.
Truly Yours,
-------------------
Your Name
Wednesday, October 21, 2009
Fifth Lesson Of Ms-Word
Borders and Shading
Allow: you to format text with a variety of border and shading colors.
Auto format: word can apply its own specialized formatting to selected text
Style : gallery allows you to chose from a variety of different preset style for your
Style :allows you to modify and create style for your document
Background :allows you to change the background color of a document
Language sets : the language for your document for you document for example (uk)
Columns : allows you to break your document into column
Tabs : Display the tabs dialog box that allow you to set tab position
Drop cap :creates a larger first letter at the beginning of the paragraph
Text direction : allows you to change the orientation of text within a text box
Change case :allows you to change selected text from upper and lower case and vice versa
Word count : Display is the number of word pages and character in a document
Object : allows you to change the shapes, size and color of an object
Allow: you to format text with a variety of border and shading colors.
Auto format: word can apply its own specialized formatting to selected text
Style : gallery allows you to chose from a variety of different preset style for your
Style :allows you to modify and create style for your document
Background :allows you to change the background color of a document
Language sets : the language for your document for you document for example (uk)
Columns : allows you to break your document into column
Tabs : Display the tabs dialog box that allow you to set tab position
Drop cap :creates a larger first letter at the beginning of the paragraph
Text direction : allows you to change the orientation of text within a text box
Change case :allows you to change selected text from upper and lower case and vice versa
Word count : Display is the number of word pages and character in a document
Object : allows you to change the shapes, size and color of an object
Sunday, October 18, 2009
If your video card/graphics adapter is different.
If you do not have an AGP video card, your card will be a PCI version. This means it will simply be installed in one of your open PCI slots.
If you are installing a separate 3D Accelerator card.
Some people decide not to buy "combo" cards that handle both 2D & 3D graphics. If you are installing a separate 3D Accelerator card, simply install it as you would a video card in a spare PCI slot. Consult the manual that comes with your 3D card for making final connections using the supplied cable.
If you are installing a modem.
The procedure is identical to installing the network card. See our parts list for recommendations regarding modems.
If you are installing a separate 3D Accelerator card.
Some people decide not to buy "combo" cards that handle both 2D & 3D graphics. If you are installing a separate 3D Accelerator card, simply install it as you would a video card in a spare PCI slot. Consult the manual that comes with your 3D card for making final connections using the supplied cable.
If you are installing a modem.
The procedure is identical to installing the network card. See our parts list for recommendations regarding modems.
How i can Edit Data With Keyboard
F2
Edit the active cell and position the insertion point at the end of the cell contents.
ALT+ENTER
Start a new line in the same cell.
BACKSPACE
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents.
DELETE
Delete the character to the right of the insertion point, or delete the selection.
CTRL+DELETE
Delete text to the end of the line.
F7
Display the Spelling dialog box.
SHIFT+F2
Edit a cell comment.
ENTER
Complete a cell entry and select the next cell below.
CTRL+Z
Undo the last action.
ESC
Cancel a cell entry.
CTRL+SHIFT+Z
When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction.
Edit the active cell and position the insertion point at the end of the cell contents.
ALT+ENTER
Start a new line in the same cell.
BACKSPACE
Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents.
DELETE
Delete the character to the right of the insertion point, or delete the selection.
CTRL+DELETE
Delete text to the end of the line.
F7
Display the Spelling dialog box.
SHIFT+F2
Edit a cell comment.
ENTER
Complete a cell entry and select the next cell below.
CTRL+Z
Undo the last action.
ESC
Cancel a cell entry.
CTRL+SHIFT+Z
When the AutoCorrect Smart Tags is displayed, undo or redo the last automatic correction.
Saturday, October 17, 2009
How i can make my MBA project?
If you want to make your MBA project but you have no pattern and data for that then you can contact me at siraqeelonline@yahoo.com . i will help you out for all needs.
Friday, October 16, 2009
Information About Windows Desktop.
Icon: allow you to quickly start your favorite programs with a double-click of the mouse. These icons are also called short cuts. You can add as many as will fit on the screen.
The Desktop Area: can be customized with different backgrounds and wallpapers’ made up of colors. Pictures and patterns.
The taskbar: is this gray strip at the bottom of your desktop. it is always visible on your screen , even when you are working in another program. It lists the entire program you currently open.
Start menu: launch button opens a list of programs available on your computer.
Quick launch: tool bar allows you to quickly open your favorite or most used programs.
Time: display will always show the current time here on your screen. it can be adjusted on any time by double clicking on it.
Common icons (‘shortcuts’) on a windows desktop
Ø My computer enables you to organize your documents and setup features like printers; email/internet connections and disk drive son your computer.
Ø The Recycle Bin is a temporary storage area for 9items you have deleted from computer. They can be retrieved from here if your deleting was accidental. Or they can be permanently deleted from your system.
Ø Internet explorer is a type of program (software) called an Internet browser. This allows you to view documents on the Internet. To connect to internet, you first need modem (a piece of hardware), a
The Desktop Area: can be customized with different backgrounds and wallpapers’ made up of colors. Pictures and patterns.
The taskbar: is this gray strip at the bottom of your desktop. it is always visible on your screen , even when you are working in another program. It lists the entire program you currently open.
Start menu: launch button opens a list of programs available on your computer.
Quick launch: tool bar allows you to quickly open your favorite or most used programs.
Time: display will always show the current time here on your screen. it can be adjusted on any time by double clicking on it.
Common icons (‘shortcuts’) on a windows desktop
Ø My computer enables you to organize your documents and setup features like printers; email/internet connections and disk drive son your computer.
Ø The Recycle Bin is a temporary storage area for 9items you have deleted from computer. They can be retrieved from here if your deleting was accidental. Or they can be permanently deleted from your system.
Ø Internet explorer is a type of program (software) called an Internet browser. This allows you to view documents on the Internet. To connect to internet, you first need modem (a piece of hardware), a
Thursday, October 15, 2009
Enter And Calculate Formula
= (equal sign)
Start a formula.
F2
Move the insertion point into the Formula Bar when editing in a cell is turned off.
BACKSPACE
In the Formula Bar, delete one character to the left.
ENTER
Complete a cell entry from the cell or Formula Bar.
CTRL+SHIFT+ENTER
Enter a formula as an array formula.
ESC
Cancel an entry in the cell or Formula Bar.
SHIFT+F3
In a formula, display the Insert Function dialog box.
CTRL+A
When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.
CTRL+SHIFT+A
When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses.
F3
Paste a defined name into a formula.
ALT+= (equal sign)
Insert an AutoSum formula with the SUM function.
CTRL+SHIFT+" (quotation mark)
Copy the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+' (apostrophe)
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+` (single left quotation mark)
Alternate between displaying cell values and displaying formulas.
F9
Calculate all worksheets in all open workbooks.
When a portion of a formula is selected, calculate the selected portion. You can then press ENTER or CTRL+SHIFT+ENTER (for array formulas) to replace the selected portion with the calculated value.
SHIFT+F9
Calculate the active worksheet.
CTRL+ALT+F9
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+F9
Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Start a formula.
F2
Move the insertion point into the Formula Bar when editing in a cell is turned off.
BACKSPACE
In the Formula Bar, delete one character to the left.
ENTER
Complete a cell entry from the cell or Formula Bar.
CTRL+SHIFT+ENTER
Enter a formula as an array formula.
ESC
Cancel an entry in the cell or Formula Bar.
SHIFT+F3
In a formula, display the Insert Function dialog box.
CTRL+A
When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.
CTRL+SHIFT+A
When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses.
F3
Paste a defined name into a formula.
ALT+= (equal sign)
Insert an AutoSum formula with the SUM function.
CTRL+SHIFT+" (quotation mark)
Copy the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+' (apostrophe)
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+` (single left quotation mark)
Alternate between displaying cell values and displaying formulas.
F9
Calculate all worksheets in all open workbooks.
When a portion of a formula is selected, calculate the selected portion. You can then press ENTER or CTRL+SHIFT+ENTER (for array formulas) to replace the selected portion with the calculated value.
SHIFT+F9
Calculate the active worksheet.
CTRL+ALT+F9
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+F9
Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Fourth Lesson Of Ms-Word
Page numbers: Inserts page numbers. You can format page numbers to appear at the top or bottom of the page
Break: Inserts a page, column or section break to your document
Auto text: automatically inserts frequently used text such as salutations and mailing instructions
Symbol: inserts special symbols into your document, such as non-English letters, currency symbols and mathematical figures
Footnote: Creates a numbered footnote at the current cursor
Caption: Inserts captions for graphic and table in your document
Index and tables: creates indexes and other tables such as a table of consents
Bookmark" Insert named bookmark into the document at a specified location so you can easily find Manu later on
Paragraph: Display the Paragraph dialog box with option for alignment, indention and spacing
Break: Inserts a page, column or section break to your document
Auto text: automatically inserts frequently used text such as salutations and mailing instructions
Symbol: inserts special symbols into your document, such as non-English letters, currency symbols and mathematical figures
Footnote: Creates a numbered footnote at the current cursor
Caption: Inserts captions for graphic and table in your document
Index and tables: creates indexes and other tables such as a table of consents
Bookmark" Insert named bookmark into the document at a specified location so you can easily find Manu later on
Paragraph: Display the Paragraph dialog box with option for alignment, indention and spacing
Wednesday, October 14, 2009
What is Wndows?
What are windows?
Windows is what is called an operating system for your computer. Once an operating system is loaded onto your computer, it manages all the other programs (called application or software) you use, for like the foundations of a building. So to run a word processor or an email program, for instance, you need to have an operating system to allow you to access them.
Windows is what is called an operating system for your computer. Once an operating system is loaded onto your computer, it manages all the other programs (called application or software) you use, for like the foundations of a building. So to run a word processor or an email program, for instance, you need to have an operating system to allow you to access them.
Difference between Software & Hardware
What are software and hard ware?
Software that is compatible with
Windows can then be installed
Operating system (windows) installed on
Physical components of your computer (hardware)Your computer is basically made up of two kinds of component. These are called hardware and software. Software refers to the applications you load onto your computer. Like word processor, email programs and games. Hardware refers to the physical parts of your computers such as the microchip inside your computer, your monitor (screen) and your disk drives.
Software that is compatible with
Windows can then be installed
Operating system (windows) installed on
Physical components of your computer (hardware)Your computer is basically made up of two kinds of component. These are called hardware and software. Software refers to the applications you load onto your computer. Like word processor, email programs and games. Hardware refers to the physical parts of your computers such as the microchip inside your computer, your monitor (screen) and your disk drives.
Tuesday, October 13, 2009
Third Lesson For Ms-Word
Normal: shows a simple view Of the page includes horizontal ruler and shows page breaks as dotted lines
Online layout: optimizes the layout to make reading the document on-screen easier
Outline: This view shows the different heading levels that have been used in a document
Header and footer: Shows the header and footer on the screen and allows them to be created edited or deleted
Footnotes: Used to addexokabatoy notes or reference sorters within a document
Comments: show a list of any comments that have been inserted into document
Page layout: Document appears as it will print use this view to display graphics
Header and footers
Toolbar: presents menu off all the toolbar that are available and allows you to vie them on screen
Ruler: hides or shows the screen’s rulers
Document map: shows a map or outline of your document ‘s headings to the left of the page
Full screen: Shows your document without the title bar, so more text appears on the page. Placer your mouse pointer along the top edge of the screen to view the menu bar again
Zoom: Used to make a document appear larger or smaller on the screen
Online layout: optimizes the layout to make reading the document on-screen easier
Outline: This view shows the different heading levels that have been used in a document
Header and footer: Shows the header and footer on the screen and allows them to be created edited or deleted
Footnotes: Used to addexokabatoy notes or reference sorters within a document
Comments: show a list of any comments that have been inserted into document
Page layout: Document appears as it will print use this view to display graphics
Header and footers
Toolbar: presents menu off all the toolbar that are available and allows you to vie them on screen
Ruler: hides or shows the screen’s rulers
Document map: shows a map or outline of your document ‘s headings to the left of the page
Full screen: Shows your document without the title bar, so more text appears on the page. Placer your mouse pointer along the top edge of the screen to view the menu bar again
Zoom: Used to make a document appear larger or smaller on the screen
Monday, October 12, 2009
Show, hide, and outline data
ALT+SHIFT+RIGHT ARROW
Groups rows or columns.
ALT+SHIFT+LEFT ARROW
Ungroups rows or columns.
CTRL+8
Displays or hides the outline symbols.
CTRL+9
Hides the selected rows.
CTRL+SHIFT+( (opening parenthesis)
Unhides any hidden rows within the selection.
CTRL+0 (zero)
Hides the selected columns.
CTRL+SHIFT+) (closing parenthesis)
Unhides any hidden columns within the selection.
Switch to the previous program.
CTRL+ESC
Display the Windows Start menu.
CTRL+W or CTRL+F4
Close the selected workbook window.
CTRL+F5
Restore the window size of the selected workbook window.
F6
Switch to the next pane in a worksheet that has been split (Window menu, Split command).
SHIFT+F6
Switch to the previous pane in a worksheet that has been split.
CTRL+F6
When more than one workbook window is open, switch to the next workbook window.
CTRL+SHIFT+F6
Switch to the previous workbook window.
CTRL+F7
When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC.
CTRL+F8
When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press ESC.
CTRL+F9
Minimize a workbook window to an icon.
CTRL+F10
Maximize or restore the selected workbook window.
Groups rows or columns.
ALT+SHIFT+LEFT ARROW
Ungroups rows or columns.
CTRL+8
Displays or hides the outline symbols.
CTRL+9
Hides the selected rows.
CTRL+SHIFT+( (opening parenthesis)
Unhides any hidden rows within the selection.
CTRL+0 (zero)
Hides the selected columns.
CTRL+SHIFT+) (closing parenthesis)
Unhides any hidden columns within the selection.
Switch to the previous program.
CTRL+ESC
Display the Windows Start menu.
CTRL+W or CTRL+F4
Close the selected workbook window.
CTRL+F5
Restore the window size of the selected workbook window.
F6
Switch to the next pane in a worksheet that has been split (Window menu, Split command).
SHIFT+F6
Switch to the previous pane in a worksheet that has been split.
CTRL+F6
When more than one workbook window is open, switch to the next workbook window.
CTRL+SHIFT+F6
Switch to the previous workbook window.
CTRL+F7
When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC.
CTRL+F8
When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press ESC.
CTRL+F9
Minimize a workbook window to an icon.
CTRL+F10
Maximize or restore the selected workbook window.
Sunday, October 11, 2009
Changing The Title On Your Media Player
You can change the title bar for the Windows Media Player
1. Go to RUN
2. Write the regedit
3. Go to HKEY_CURRENT_USER\.DEFAULT\
4. Then Go to Software\Policies\Microsoft\WindowsMediaPlayer
5. Create a string value ot titlebar
6. Give it a value whatever you want to appear in the title bar.
1. Go to RUN
2. Write the regedit
3. Go to HKEY_CURRENT_USER\.DEFAULT\
4. Then Go to Software\Policies\Microsoft\WindowsMediaPlayer
5. Create a string value ot titlebar
6. Give it a value whatever you want to appear in the title bar.
Saturday, October 10, 2009
Second Lesson of Ms-Word
Undo: undoes your last action. You can also undo or correct previous actions using this function
Repeat: your last action. If you accidentally undo and action try repeating your last action
Clear: delete selected text without copying it to the clipboard
Cut: deletes text the page and stores it on a clipboard. The text can then be inserted to another location in your document. NM; the clipboard can only hold one piece of text or image at time
Select: all an entire document including it to the clipboard
Copy: copies selected text without deleting it from your document. Pictures can also be copied
Paste: reproduces text or images that have been previously cut or copied
Paste special: provides some additional pasting options such as pasting objects
Object allows you to edit any objects (pictures media clips, graph, etc) in your document
Find: searches the document for a specicic word a phrase
Replace: search your document for a specific word or phrase you want to replace or change
Go to: allows you to move to a specific place in your document such as a page, section, footnote,
Link: enables you to edit any links to other document you have
Repeat: your last action. If you accidentally undo and action try repeating your last action
Clear: delete selected text without copying it to the clipboard
Cut: deletes text the page and stores it on a clipboard. The text can then be inserted to another location in your document. NM; the clipboard can only hold one piece of text or image at time
Select: all an entire document including it to the clipboard
Copy: copies selected text without deleting it from your document. Pictures can also be copied
Paste: reproduces text or images that have been previously cut or copied
Paste special: provides some additional pasting options such as pasting objects
Object allows you to edit any objects (pictures media clips, graph, etc) in your document
Find: searches the document for a specicic word a phrase
Replace: search your document for a specific word or phrase you want to replace or change
Go to: allows you to move to a specific place in your document such as a page, section, footnote,
Link: enables you to edit any links to other document you have
Most Helpful Short Keys in Ms-Excel
ALT+TAB
Switch to the next program.
ENTER
Complete a cell entry and select the cell below.
ALT+ENTER
Start a new line in the same cell.
CTRL+ENTER
Fill the selected cell range with the current entry.
SHIFT+ENTER
Complete a cell entry and select the previous cell above.
TAB
Complete a cell entry and select the next cell to the right.
SHIFT+TAB
Complete a cell entry and select the previous cell to the left.
ESC
Cancel a cell entry.
Arrow keys
Move one character up, down, left, or right.
HOME
Move to the beginning of the line.
F4 or CTRL+Y
Repeat the last action.
CTRL+SHIFT+F3
Create names from row and column labels.
CTRL+D
Fill down.
CTRL+R
Fill to the right.
CTRL+F3
Define a name.
CTRL+K
Insert a hyperlink.
ENTER (in a cell with a hyperlink)
Activate a hyperlink.
CTRL+; (semicolon)
Enter the date.
CTRL+SHIFT+: (colon)
Enter the time.
ALT+DOWN ARROW
Display a drop-down list of the values in the current column of a list.
CTRL+Z
Undo the last action.
Press F2 to edit the cell, turn on NUM LOCK, and then press the following keys by using the numeric key pad:
ALT+0162
Enters the cent character ¢.
ALT+0163
Enters the pound sterling character £.
ALT+0165
Enters the yen symbol ¥.
ALT+0128
Enters the euro symbol €.
= (equal sign)
Start a formula.
F2
Move the insertion point into the Formula Bar when editing in a cell is turned off.
BACKSPACE
In the Formula Bar, delete one character to the left.
ENTER
Complete a cell entry from the cell or Formula Bar.
CTRL+SHIFT+ENTER
Enter a formula as an array formula.
ESC
Cancel an entry in the cell or Formula Bar.
SHIFT+F3
In a formula, display the Insert Function dialog box.
CTRL+A
When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.
CTRL+SHIFT+A
When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses.
F3
Paste a defined name into a formula.
ALT+= (equal sign)
Insert an AutoSum formula with the SUM function.
CTRL+SHIFT+" (quotation mark)
Copy the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+' (apostrophe)
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+` (single left quotation mark)
Alternate between displaying cell values and displaying formulas.
F2
Edit the active cell and position the insertion point at the end of the cell contents.
ALT+ENTER
Switch to the next program.
ENTER
Complete a cell entry and select the cell below.
ALT+ENTER
Start a new line in the same cell.
CTRL+ENTER
Fill the selected cell range with the current entry.
SHIFT+ENTER
Complete a cell entry and select the previous cell above.
TAB
Complete a cell entry and select the next cell to the right.
SHIFT+TAB
Complete a cell entry and select the previous cell to the left.
ESC
Cancel a cell entry.
Arrow keys
Move one character up, down, left, or right.
HOME
Move to the beginning of the line.
F4 or CTRL+Y
Repeat the last action.
CTRL+SHIFT+F3
Create names from row and column labels.
CTRL+D
Fill down.
CTRL+R
Fill to the right.
CTRL+F3
Define a name.
CTRL+K
Insert a hyperlink.
ENTER (in a cell with a hyperlink)
Activate a hyperlink.
CTRL+; (semicolon)
Enter the date.
CTRL+SHIFT+: (colon)
Enter the time.
ALT+DOWN ARROW
Display a drop-down list of the values in the current column of a list.
CTRL+Z
Undo the last action.
Press F2 to edit the cell, turn on NUM LOCK, and then press the following keys by using the numeric key pad:
ALT+0162
Enters the cent character ¢.
ALT+0163
Enters the pound sterling character £.
ALT+0165
Enters the yen symbol ¥.
ALT+0128
Enters the euro symbol €.
= (equal sign)
Start a formula.
F2
Move the insertion point into the Formula Bar when editing in a cell is turned off.
BACKSPACE
In the Formula Bar, delete one character to the left.
ENTER
Complete a cell entry from the cell or Formula Bar.
CTRL+SHIFT+ENTER
Enter a formula as an array formula.
ESC
Cancel an entry in the cell or Formula Bar.
SHIFT+F3
In a formula, display the Insert Function dialog box.
CTRL+A
When the insertion point is to the right of a function name in a formula, display the Function Arguments dialog box.
CTRL+SHIFT+A
When the insertion point is to the right of a function name in a formula, insert the argument names and parentheses.
F3
Paste a defined name into a formula.
ALT+= (equal sign)
Insert an AutoSum formula with the SUM function.
CTRL+SHIFT+" (quotation mark)
Copy the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+' (apostrophe)
Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+` (single left quotation mark)
Alternate between displaying cell values and displaying formulas.
F2
Edit the active cell and position the insertion point at the end of the cell contents.
ALT+ENTER
Friday, October 9, 2009
Usage Of Filter By Keys in Ms-Excel
ALT+DOWN ARROW
In the cell that contains the drop-down arrow, displays the AutoFilter list for the current column.
DOWN ARROW
Selects the next item in the AutoFilter list.
UP ARROW
Selects the previous item in the AutoFilter list.
ALT+UP ARROW
Closes the AutoFilter list for the current column.
HOME
Selects the first item (All) in the AutoFilter list.
END
Selects the last item in the AutoFilter list.
ENTER
Filters the list based on the item selected from the AutoFilter list.
In the cell that contains the drop-down arrow, displays the AutoFilter list for the current column.
DOWN ARROW
Selects the next item in the AutoFilter list.
UP ARROW
Selects the previous item in the AutoFilter list.
ALT+UP ARROW
Closes the AutoFilter list for the current column.
HOME
Selects the first item (All) in the AutoFilter list.
END
Selects the last item in the AutoFilter list.
ENTER
Filters the list based on the item selected from the AutoFilter list.
First Lesson Of Micrsoft Word
New: start a new document in a new window without quitting word.
Open: Open an existing Document, Directories and folders
Save: Save the current documents.
The save as dialoge box only appears the first time you save your document.
Close: Close the current window and document.
Save as opens the Save as dialoge box lets you save the current documents
Save as HTML: save documents in a format that is suitable for the Internet
Versions save: Multiple versions ofThe same document in One flew
Page setup: adjusts the elaout of a document including magins, paper size and page orientation
Print: presents the print dialog box, which allows document. You can print specicic pages and more then one copy at a time
Send to: a quick way to transfer your document electronically by fax or email
Exit: closes all open document as well as Microsoft word itself
Properties: tells you the sixes of your file, when the document was created and last modified
Open: Open an existing Document, Directories and folders
Save: Save the current documents.
The save as dialoge box only appears the first time you save your document.
Close: Close the current window and document.
Save as opens the Save as dialoge box lets you save the current documents
Save as HTML: save documents in a format that is suitable for the Internet
Versions save: Multiple versions ofThe same document in One flew
Page setup: adjusts the elaout of a document including magins, paper size and page orientation
Print: presents the print dialog box, which allows document. You can print specicic pages and more then one copy at a time
Send to: a quick way to transfer your document electronically by fax or email
Exit: closes all open document as well as Microsoft word itself
Properties: tells you the sixes of your file, when the document was created and last modified
Thursday, October 8, 2009
Insert, delete, and copy cells in MS-EXCEL
CTRL+C
Copy the selected cells.
CTRL+C, immediately followed by another CTRL+C
Display the Microsoft Office Clipboard (multiple copy and paste).
CTRL+X
Cut the selected cells.
CTRL+V
Paste copied cells.
DELETE
Clear the contents of the selected cells.
CTRL+HYPHEN
Delete the selected cells.
CTRL+SHIFT+PLUS SIGN
Insert blank cells.
Copy the selected cells.
CTRL+C, immediately followed by another CTRL+C
Display the Microsoft Office Clipboard (multiple copy and paste).
CTRL+X
Cut the selected cells.
CTRL+V
Paste copied cells.
DELETE
Clear the contents of the selected cells.
CTRL+HYPHEN
Delete the selected cells.
CTRL+SHIFT+PLUS SIGN
Insert blank cells.
Tuesday, October 6, 2009
How u can display files in MSDOS mode
Dir
Display the directory and Files
Dir/p
Display the directory and Files with page wise
Dir/w
Display the directory and Files with Width wise
Dir/w/p
Display the directory and Files with Page & Width wise.
Dir/w/p/s
Display the Sub directory and Files with Page & Width wise.
Display the directory and Files
Dir/p
Display the directory and Files with page wise
Dir/w
Display the directory and Files with Width wise
Dir/w/p
Display the directory and Files with Page & Width wise.
Dir/w/p/s
Display the Sub directory and Files with Page & Width wise.
Monday, October 5, 2009
An Easy Pattern Of CV
Muhammad Nadeem
Father Name: -- Muhammad Rafiq Anjum
N.I.C No.: --36302-5145862-7
Date Of Birth: -- 09/03/1988
Martial Status: -- Single
Religion: -- Islam
Address: -- Masoom Shah Road, Street No. 2, House No. 21
-- Jalil Abad, Multan-Pakistan
Contact No. -- 0314-6186213
· Academic Background
--Matriculate (Multan Board Of Intermediate & Secondary Education)
--Intermediate -DO- (Result Awaited)
· Computer Skills
Operating System ( Windows 98/Xp)
Office 2000 (Ms Excel, Ms Word, Ms PowerPoint)
Graphic Designing (Urdu / English using Corel & Adobe)
· Professional Certifications
--Diploma Of Office Administration
--Diploma Of Pattern Drafting & Grading
· Professional Experience
-- 6 Month Experience in Fatima Enterprises Limited, Lahore as
Assistant Cutting Master
-- 11 Month Experience in Bright Future Institute Of Computer Studies as
Computer Instructor
Father Name: -- Muhammad Rafiq Anjum
N.I.C No.: --36302-5145862-7
Date Of Birth: -- 09/03/1988
Martial Status: -- Single
Religion: -- Islam
Address: -- Masoom Shah Road, Street No. 2, House No. 21
-- Jalil Abad, Multan-Pakistan
Contact No. -- 0314-6186213
· Academic Background
--Matriculate (Multan Board Of Intermediate & Secondary Education)
--Intermediate -DO- (Result Awaited)
· Computer Skills
Operating System ( Windows 98/Xp)
Office 2000 (Ms Excel, Ms Word, Ms PowerPoint)
Graphic Designing (Urdu / English using Corel & Adobe)
· Professional Certifications
--Diploma Of Office Administration
--Diploma Of Pattern Drafting & Grading
· Professional Experience
-- 6 Month Experience in Fatima Enterprises Limited, Lahore as
Assistant Cutting Master
-- 11 Month Experience in Bright Future Institute Of Computer Studies as
Computer Instructor
How u can format data in Ms-Excel with Keyboard.
ALT+' (apostrophe)
Display the Style dialog box.
CTRL+1
Display the Format Cells dialog box.
CTRL+SHIFT+~
Apply the General number format.
CTRL+SHIFT+$
Apply the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+%
Apply the Percentage format with no decimal places.
CTRL+SHIFT+^
Apply the Exponential number format with two decimal places.
CTRL+SHIFT+#
Apply the Date format with the day, month, and year.
CTRL+SHIFT+@
Apply the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+!
Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values.
CTRL+B
Apply or remove bold formatting.
CTRL+I
Apply or remove italic formatting.
CTRL+U
Apply or remove underlining.
CTRL+5
Apply or remove strikethrough.
CTRL+9
Hide the selected rows.
CTRL+SHIFT+( (opening parenthesis)
Unhide any hidden rows within the selection.
CTRL+0 (zero)
Hide the selected columns.
CTRL+SHIFT+) (closing parenthesis)
Unhide any hidden columns within the selection.
CTRL+SHIFT+&
Apply the outline border to the selected cells.
CTRL+SHIFT+_
Remove the outline border from the selected cells.
Display the Style dialog box.
CTRL+1
Display the Format Cells dialog box.
CTRL+SHIFT+~
Apply the General number format.
CTRL+SHIFT+$
Apply the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+%
Apply the Percentage format with no decimal places.
CTRL+SHIFT+^
Apply the Exponential number format with two decimal places.
CTRL+SHIFT+#
Apply the Date format with the day, month, and year.
CTRL+SHIFT+@
Apply the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+!
Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values.
CTRL+B
Apply or remove bold formatting.
CTRL+I
Apply or remove italic formatting.
CTRL+U
Apply or remove underlining.
CTRL+5
Apply or remove strikethrough.
CTRL+9
Hide the selected rows.
CTRL+SHIFT+( (opening parenthesis)
Unhide any hidden rows within the selection.
CTRL+0 (zero)
Hide the selected columns.
CTRL+SHIFT+) (closing parenthesis)
Unhide any hidden columns within the selection.
CTRL+SHIFT+&
Apply the outline border to the selected cells.
CTRL+SHIFT+_
Remove the outline border from the selected cells.
Subscribe to:
Posts (Atom)