Excel uses shortkeys

Excel uses shortkeys

Short Keys                                   Commands

F2                                                  Edit the selected cell

F5                                                  Go to a specific cell

F11                                                Create Chart

F7                                                  Spell check selected text/ 

                  document

Ctrl + shift + +                              Enter the current time

Alt + shift + F1                             Insert new worksheet

Shift + F3                                     Open the excel formula window

Shift + F5                                     Bring up search box

Ctrl + A                                        Select all content

Ctrl + K                                       Insert Hyperlink

Ctrl + F9                                      Minimize current window

Ctrl + F10                                    Maximize Current Window

Ctrl + F6                                      Switch between open   

                               worksheet/Window

Ctrl + tab                                     Two or more open Excel fields

Alt + F                                         Create a formula to sum all the 

                 above cells

Ctrl + Spacebar                          Select Entire column

Shift + Spacebar                         Select Entire Rows

...

MICROSOFT NATURAL KEYBOARD SHORT KEYS

MICROSOFT NATURAL KEYBOARD SHORT KEYS

KEYS                                            RESULT

win (CTRL + ESC)                       Displays or hide the start menu

win + Break                                  Display the system properties dialog box

win + D                                          Display the desktop

win + M                                         Minimizes all the windows

win + E                                          Open my computer

win + shift + M                             Restore the minimizes of windows

win + F                                          Search for a file/ folder

win + R                                         Open the Run dialog box

Ctrl + win + F                               Search for computers

win + U                                         Open utility manager

...

concept of "B","I","U"

Concept of "B","I","U"

"B" make the selected content to be bold in the look..

for e.g. : without command "B" it looks like =   "INDIA"

after selecting "B" it look like=  "INDIA"

short key is "Ctrl + B"

"I" make the selected content to be italic (bend)..

for e.g. without using "I" it look like= "AMAZING"

 after selecting "I" it will look like=  "AMAZING"

short key is "Ctrl + I"

"U" make an underline of the selected word or data...

for e.g. without using "U" it look like = "important"

after selecting "U" it will look like= "important"

 

short key is "Ctrl+U"...

...

some computer related terms with full form

Computer related terms with its full forms

HTTP - Hyper Text Transfer Protocol.

* HTTPS - Hyper Text Transfer Protocol Secure.

* IP - Internet Protocol.

* URL - Uniform Resource Locator. 

* USB - Universal Serial Bus. 

* VIRUS - Vital Information Resource UnderSeized. 

* 3G -3rd Generation. 

* GSM - Global System for Mobile Communication.

* CDMA - Code Divison Multiple Access.

* UMTS - Universal MobileTelecommunication System.

* SIM - Subscriber Identity Module . 

* AVI = Audio Video Interleave 

* RTS = Real Time Streaming

* SIS = Symbian OS Installer File 

* AMR = Adaptive Multi-Rate Codec

* JAD = Java Application Descriptor 

* JAR = Java Archive

* JAD = Java Application Descriptor 

* 3GPP = 3rd Generation Partnership Project 

* 3GP = 3rd Generation Project 

* MP3 = MPEG player lll

* MP4 = MPEG-4 video file

*AAC = Advanced Audio Coding 

* GIF= Graphic Interchangeable Format

* JPEG = Joint Photographic Expert Group

* BMP = Bitmap

* SWF = Shock Wave Flash 

* WMV = Windows Media Video 

* WMA = Windows Media Audio 

* WAV = Waveform Audio

* PNG = Portable Network Graphics

* DOC = Document (MicrosoftCorporation) 

* PDF = Portable Document Format 

* M3G = Mobile 3D Graphics

* M4A = MPEG-4 Audio File 

* NTH = Nokia Theme (series 40)

* THM = Themes (Sony Ericsson) 

* MMF = Synthetic Music Mobile Application File

* NRT = Nokia Ringtone

* XMF = Extensible Music File

* WBMP = Wireless Bitmap Image 

* DVX = DivX Video

* HTML = Hyper Text Markup Language

* WML = Wireless Markup Language

* CD -Compact Disk.

* DVD - Digital Versatile Disk.

*CRT - Cathode Ray Tube. 

* DAT - Digital Audio Tape. 

* DOS - Disk Operating System. 

* GUI -Graphical User Interface. 

* HTTP - Hyper Text Transfer Protocol. 

* IP - Internet Protocol. 

* ISP - Internet Service Provider. 

* TCP - Transmission Control Protocol.

* UPS - Uninterruptible Power Supply.

* HSDPA - High Speed Downlink PacketAccess.

* EDGE - Enhanced Data Rate for GSM[GlobalSystem for Mobile Communication] Evolution. 

* VHF - Very High Frequency.

* UHF - Ultra High Frequency. 

* GPRS - General PacketRadio Service.

* WAP - Wireless ApplicationProtocol.

* TCP - Transmission ControlProtocol .

* ARPANET - Advanced ResearchProject Agency Network.

* IBM - International Business Machines.

* HP - Hewlett Packard.

*AM/FM - Amplitude/ Frequency Modulation.

* WLAN - Wireless Local Area Network

...

what are Icons in the desktop screen

ICONS in the Desktop Screen

On the desktop screen you will see several small pictures. These pictures are called "ICONS"
Double Clicking the left mouse button on an icon will start the program.

some of my students ask me what is the use of icons?

Ans: icons are nothing but the application software or some folders that provide easy to access and reduce the steps to be open from Start Menu .

these icons actually are the shortcuts to access through desktop screen

for e.g. in the desktop screen you have seen the icon named "My Computer" "My Documents" or "Typing Master"

you can easily double click to switch any folder or the application software instead of go to start button select all programs then select typing master then you see a menu with options select the desired one.

how to customize your desktop in "Windows XP"?

• right click on desktop screen 
• select properties option
• you will see display properties dialog box, select desktop menu from the following
• then select Customize Desktop
• You will see a new dialog box with Desktop Item
• select the icons you wanted to be used in your desktop screen as a icon.
• you can also change the the icon by selecting change icon option.

how to customize your desktop in "Vista-Ultimate"?

• right click on desktop screen 

• select personalize option from the bottom

• left hand-side you will see "Change Desktop Icons" Options

• select or deselect the options you wanted to see on desktop as a icon 

...

what are peripheral devices?

Peripheral Devices

Any hardware devices that are connected externally to the C.P.U(Central Processing Unit) are called Peripheral Devices
for e.g.

• computer
• keyboard
• mouse
• speakers
• cameras
• scanners
• printer
• microphones, etc

...

how to change case of your text in ms-word 2007

To Change Case of  your text in ms-word 2007 

As we all know if we need a textual data in our document to be uppercase means to be capitalised each word we need to select CAP LOCK key from the keyboard before typing anything.......

But what will you do if your text is in lowercase or in small letters???

after typing if you got any instructions to be shown content or work in capital your caps lock key will not work at that time you need to follow some easy steps:

select your text which you wanted to be capitalised

go to home menu from menu bar of ms-word 2007

select " Aa " from the formatting tool baryou will see several options such as:

• Sentence Case

• lower Case

• Upper Case

• Toggle Case 

each has different functionality 

for e.g. you have typed  "welcome" and you selected Sentence case 

welcome word will be looked as = "Welcome" first word will be capital according to the rule of english and other will be in small till the system got any full stop or para change.

lower case will impact your text to be in small letters.

Upper Case will change your text into Capital each word.

Toggle Case is something mix of lower and upper for e.g. you typed 

"Welcome To The World of COMPUTERS"

it will change the capital words to be in lower case and the small letter word will be changed into capital 

so the result will be "wELCOME tO tHE wORLD OF computers"

 alternative method 

press Ctrl + D for font dialog box

select the "All Caps" Option from the following and then ok, your small letter content will be capitalised.

...