Tuesday, December 23, 2014

Some Shortcut Keys of MS EXcel

Some Shortcut Keys of MS Excel

F11                       -              Create a Chart
F7                         -              Speling Check
Ctrl + Shift + ;     -              Insert  Current Time
Ctrl +  ;                -              Insert Current Date
Ctr + Space          -               Select entire Column
Shift + Space       -              Select Entire Row
Shift + F3            -               Insert Function
Shift + F5            -               Find and Replace
Ctrl + F6             -              Switch between open Workbook/Windows
Ctrl + F9             -               Minimize the Current Workbook
Ctrl + F10          -                Maximize the Current Workbook
Ctr + A               -                Select All
Ctrl + B              -                Bold highlighted Selection
Ctrl + U              -                Underline the Highlighted Selection
Ctrl + I               -               Italic the Highlighted Selection
Alt  +  =               -                Formula to Sum all of the above cell
Ctrl +  Arrow Keys     -      Move to next section of the text
Ctrl + P              -                 For Print
Ctrl + Z               -                Undo 

    Tuesday, November 18, 2014

    PROCESS TO INSERT SHAPE

    PROCESS TO INSERT SHAPE-

    1. CLICK ON INSERT TAB
    2. CLICK ON THE  DROP DOWN MENU OF SHAPES
    3. SELECT ANY SHAPE WHICH YOU WANT TO INSERT ON YOUR DOCUMENT.
    4. PUT POINTER ON THE PLACE WHERE YOU WANT TO INSERT SHAPE
    5. DRAG MOUSE ACCORDING TO THE DESIRED SIZE AS YOU REQUIRED

    PROCESS TO ADD TEXT

    1. CLICK ON INSERT TAB
    2. CLICK ON DROP DOWN MENU OF SHAPE
    3. INSERT  ANY SHAPE 
    4. SELECT SHAPE IN WHICH YOU WANT TO ADD TEXT
    5. RIGHT CLICK ON THE SHAPE
    6. CLICK ON THE ADD TEXT
    7. TYPE YOUR TEXT

    PROCESS TO CHANGE SIZE OF THE SHAPE

    1. CLICK ON INSERT TAB
    2. CLICK ON DROP DOWN MENU OF SHAPE
    3. INSERT  ANY SHAPE 
    4. PUT POINTER ON THE SHAPE 
    5. PRESS LEFT BUTTON ON THE MOUSE.
    6. DRAG THE MOUSE ACCORDING TO THE DESIRED
        SIZE DO YOU WANT TO SHAPE

    PROCESS TO CHANGE SHAPE STYLE

    1. CLICK ON INSERT TAB
    2. CLICK ON DROP DOWN MENU OF SHAPE
    3. INSERT ANY SHAPE
    4. CLICK ON DROP DOWN MENU OF SHAPE STYLE
    5. CLICK DESIRED SHAPE STYLES DO YOU WANT ON YOUR SHAPE.


    COMPUTER GENERATION

    COMPUTER GENERATION
    GENERATION
    TIME PERIOD
    LANGUAGE USED
    TECHNOLOGY
    OPERATING SYSTEM
    EXAMPLE
    FIRST
    1946-1959
    MACHINE LEVEL CODE
    VACCUM TUBE BASED
    BATCH PROCESSING USED
    ENIAC, UNIVAC ETC
    SECOND
    1959-1965
    ASSEMBLY & HIGH LEVEL LIKE
    TRANSISTER BASED
    BATCH PROCESSING  &
    MULTI PROGRAMMING OS
    IBM 1620
    IBM 7074
    THIRD
    1965-1971
    HIGH LEVEL LANGUAGE
    PASCAL, BASIC, ALGOL WERE USED
    INTEGRATED CIRCUIT
    REMOTE PROCESSING, TIME SHARING MULTIPROGRAMMING
    PDP(PERSONAL DATA PROCESSOR),
    HONEYWELL 6000 SENG
    FOURTH
    1971-1980
    HLL LIKE C, C++, DBASE ETC
    VLSI (VERY LARGE SCALE INTEGRATED CIRCUIT)
    TIME SHARING REALTIME  & DISTRIBUTED OS USED
    CRAY-1 (SUPER COMPUTER)
    FIFTH
    1980- TILL NOW
    C, C++, JAVA, .NET ETC
    ULSI(ULTRA LARGE SCALE INTEGRATION)
    TIME SHARING REALTIME  & DISTRIBUTED OS USED
    TECHNOLOGY USED – AI, NATURAL LANGUAGE PROCESSING PARALLED PROCESSING ETC

    Shortcut Keys Used in Hindi Typing


    Alt + 0131
    ƒ
    0132
    „
    0133
    …
    0134
    †
    0135
    ‡
    0136
    ˆ
    0137
    ‰
    0138
    Š
    0139
    ‹
    0140
    Œ
    0151
    —
    0159
    Ÿ]
    0161
                ¡
    0163
    £
    0164
    ¤
    0165
    ¥
    0167
    §
    0168
    ¨
    0169
    ©
    0170
     ª  
    0171
    «
    0188
    ¼
    0189
    ½
    0190
    ¾
    0191
    ¿
    0192
    À
    0193
    Á
    0195
    Ã
    0197
    Å
    0198
    Æ
    0199
    Ç
    0200
    È
    0201
    É
    0202
    Ê
    0204
    Ì
    0205
    Í
    0206
    Î
    0207
    Ï
    0211
    Ó
    0212
    Ô
    0214
    Ö
    0216
    Ø
    0217
    Ù
    0218
    Ú
    0221
    Ý
    0222
    Þ
    0224
    à
    0225
    á
    0226
    â
    0227
    ã
    0228
    ä
    0230
    æ
    0231
    ç

    Wednesday, July 23, 2014

    Getting Started with MS Excel 2003

                Start Menu >> All Programs >>Microsoft-Office>> Microsoft Office MS Excel 2003
    Or
    1. Click on the Start button from the Task bar
    2. Select All Programs From the Start button.
    3. Select All Programs and Click on the Microsoft Office and Choose the Microsoft Office Excel 2003
          The screen as shown in figure appears with a blank workbook opened.

    Creating a New Blank Database

    Creating a New Blank Database on MS-Access 2003

    1. Select File menu and click on the New.
    2. Click on the Blank database.
    3. File New Database box will be appears.
    4. In the File New database give File name: db2 (new database)
    5. Click on the Create button.
    6.  The New Database db2 is created on the MS Access.

    Creating a New Blank Database

    Creating a New Blank Database on MS-Access 2003

    1. Select File menu and click on the New.
    2. Click on the Blank database.
    3. File New Database box will be appears.
    4. In the File New database give File name: db2 (new database)
    5. Click on the Create button.
    6.  The New Database db2 is created on the MS Access.
    Subscribe to: Posts (Atom)