SARKARI SUVIDHA KENDRA

 Shortcut Key

Ctrl+A: It is used to select all content of a page, including images and other objects.

• Ctrl+B: It provides users with the option to bold the selected item of a page.
• Ctrl+C: Its use is to copy the selected text, including other objects of a file or page.
• Ctrl+D: It is used to access the font preferences window, which offers several options such as font size, font style, font color, etc.
• Ctrl+E: It is used to align the selected item to the center of the screen.
• Ctrl+F: It helps users to find or search data in the current document or window.
• Ctrl+I: It offers an option to italicize and un-italicize the highlighted text.
• Ctrl+J: It is used to Justify (distribute your text evenly between the margins) the selected text.
• Ctrl+L: It is used to adjust (align) the selected content to the left of the screen.
• Ctrl+N: It is used to open a new or blank document in Microsoft applications and some other software.
• Ctrl+O: It is used to open the dialog box where you can choose a file that you want to open.
• Ctrl+P: It is used to open the print preview window of a document or a file. It can also be done by pressing Ctrl+F2 and Ctrl+Shift+F12.
• Ctrl+R: It offers users the option to align the line or selected content to the right of the screen.
• Ctrl+S: Its use is to save the document or a file.
• Ctrl+U: It is used to underline the selected text.
• Ctrl+V: It is used to paste the copied data. It allows you to copy data once, and then you can paste it any number of times. You can also paste the data by using Shift+Insert.
• Ctrl+W: Its use is to close the currently open document or a file quickly.
• Ctrl+X: If you want to cut some text, you can use this key to cut the selected content. You can also paste it by using Ctrl+V.
• Ctrl+Y: It allows the users to redo the last action performed in a file. For example, you have written a word mango; you can repeat this word multiple times by pressing Ctrl+Y.
• Ctrl+Z: It is used to get back the deleted item. For example, if you have deleted the data by mistake, you can press Ctrl+Z to retrieve (Undo) the deleted data. It can also be done by pressing Alt+Backspace.
• Alt+F, A: It allows users to use the Save As option, which means to save a file with a different name. For that, you need to press Alt+F, which displays a dialog box or a page, then press A for Save As option. It can also be done simply by pressing
• Ctrl+Shift+>: It increases the font size by +1pts up to 12pt thereafter increases by +2pts.
• Ctrl+Shift+<: It is used to decrease the font If the font size is 12pt or lower; it decreases the font by -1pts, and if the font size is above 12, it decreases the font by +2pts.
• Ctrl+]: Its use is to increases the font size by +1pts.
• Ctrl+[: It is used to decreases the font size by -1pts.
• Ctrl + (Left arrow ←):I t allows users the benefit to move one word to the left in the line or a paragraph.
• Ctrl + (Right arrow →): It is used to move one word to the
• Ctrl+Shift+*: It is used to show or hide non-printing characters.
• Ctrl + (Up arrow ↑): This key is used to move the typing cursor to the beginning of the line or paragraph.
• Ctrl + (Down arrow ↓): It enables you to move the typing cursor to the end of the paragraph.
• Ctrl+Delete: It allows users to delete a word to the right of the cursor.
• Ctrl+Backspace: It allows users to delete a word to the left of the cursor.
• Ctrl+End: Its use is to move the cursor to the last of the document.
• Ctrl+1: It is used to give a single line space. For example, to make the 1.0 space between the lines of a paragraph.
• Ctrl+2: It is used to give the double line space. For example, to make the 2.0 space between the lines of a paragraph.
• Ctrl+5: It is used to make the 5 space between the lines of a paragraph.
• Ctrl+Spacebar: It enables you to reset the selected text to the default font.
• Ctrl+Home: It allows you to move the cursor to the beginning of the document
• Ctrl+F1:I ts use is to open the task pane in some Microsoft office versions, in word 2016, it is used to hide and show the ribbon as shown in the below image:
• • F1: The function key F1 is used to open the help and support
  • F5: It is used to access the find and replace dialog box, including Go to
  • F7: It provides users the advantage to check spelling and grammar of selected text or document.
  • Shift+F3: It is used to use the change case option where you can change the text from uppercase to lowercase or a capital letter at the beginning of every word.

  • 
    

    
    

    
    

    इनमें से कौन से Computer को Portable Computer नहीं माना जा सकता हैं।?

    A) Laptop
    B) Network Computer
    C) Desktop Computer
    D) PDA Computer

    ANSWER= (C) Desktop Computer

    Keyboard पर जिन Keys के आगे f1, f …… f12 लिखा होता हैं उन्हें क्या कहते ?

    A) Function Keys
    B) Numeric Keys
    C) Toggle keys
    D) Combination Keys

    ANSWER= (A) Function Keys

    Monitor पर नजर आने वाले Icon को क्या कहते हैं ?

    A) Sheet
    B) Hard Copy
    C) Soft Copy
    D) Document

    ANSWER= (C) Soft Copy

    Keyboard , Mouse , Monitor और System Unit को क्या कहा जाता हैं

    A) Software
    B) Network
    C) Hardware
    D) None of the above

    ANSWER= (C) Hardware

    Binary Number System में 0 व 1 को क्या कहा जाता हैं ?

    A) Bit
    B) Byte
    C) Mega Byte
    D)Gega Byte

    ANSWER= (A) Bit

    SMPS का पूरा नाम क्या है?

    A) Service Mode Power Supply
    B) Switch Mode Power Supply
    C) Main Power Supply
    D)Save Power Main Supply

    ANSWER= (B) Switch Mode Power Supply

    0 से 9 तक Keys Keyboard में क्या कहलाती हैं ?

    A) Numeric keys
    B) Navigation keys
    C) T Logical Keys
    D) Sign Keys

    ANSWER= (A) Numeric keys

    Windows 7 में एक्सेसरीज में कौन – कौन से Option हैं

    A) Notepad
    B) Word pad
    C) Paint
    D) All of Above

    ANSWER= (D) All of the Above

    URL की Full Form D;k gS

    A) Uninterrupted Resource Location
    B) Uniform Resource Location
    C) Unified Resource Location
    D) Uniform Resource Locator

    ANSWER=(D) Uniform Resource Locator

    Google के निर्माणकर्ता हैं?

    A) Larry page and sergey brain
    B) Tim Bernese lee and David karp
    C) Mark zockrberge and tim bernese lee
    D) Larry page and tim bernese lee

    ANSWER=(A) Larry’s page and Sergey brain

    G- mail free में कितनी store प्रदान करता हैं?

    A) 20 GB
    B) 18 GB
    C) 15 GB
    D) 25 GB

    ANSWER= (D) 15 GB

    . Internet पर Secure Website की एक पहचान हैं ?

    A) http
    B) https
    C) smtp
    D) ftp

    ANSWER= (C) https

    UPS का पूर्ण नाम क्या हैं ?

    A) Uninterruptible Power Supply
    B) Unit Power Supply
    C) User Power Supply
    D) इनमें से कोई नही

    ANSWER= (A) Uninterruptible Power Supply

    C . P . U की full Form क्या हैं ?

    A) Control Processing unit .
    B) Central Processing Unit.
    C) Control Power Unit .
    D) Central Power User.

    ANSWER= (B) Central Processing Unit.

    कम्प्यूटर की गति किसमें मापी जाती ?

    A) MBPS
    B) MBS
    C) Https
    D) इनमे से कोई नहीं

    ANSWER= (A) MBPS

    Computer को हिन्दी में क्या कहा जाता हैं ?

    A) संगणक
    B) यंत्र
    C) मशीन
    D) Computer

    ANSWER= (A) संगणक

    Computer को Shutdown करने के लिए किस shortcut keys का इस्तेमाल करते हैं

    A)Alt + F4
    B) Ctrl + F4
    C) Alt + f5
    D) Shift + F4

    ANSWER= (A) Alt + F4

    
    

    
    

    Microsoft Word is a word processing software developed by Microsoft, first released on October 25, 1983.

    Multiple-Choice Questions on MS Word

              To prepare better for MCQ preparation. It is very beneficial to solve MCQs before exams for multiple reasons. You can practise, analyse and understand concepts while solving them. It will also help you in strengthening your time management.

     

    1.   Microsoft word is ____ software.

    (A) Application

    (B) Compiler

    (C) System

    (D) Programming

    Answer: A

     2 What is MS Word used for?

    A.  Design Pictures

    B.   Design Videos

    C.   Paint

    D.  Design Texts

    Answer: D) Design Texts

    3. Microsoft Word was released in which year?

    A.  1981

    B.   1982

    C.   1983

    D.  1984

    Answer: C) 1983

    4. Where is Office Button located in MS Word?

    A.  Left Upper

    B.   Left Bottom

    C.   Right Upper

    D.  Right Bottom

    Answer: A) Left Upper

    5. Which commands are present in Quick Access Toolbar?

    A.  Save

    B.   Undo

    C.   Redo

    D.  All of the above

    Answer: D) All of the above

    6. Title Bar is present at the _________ of the Quick Access Toolbar.

    A.  Up

    B.   Down

    C.   Left

    D.  Right

    Answer: D) Right

    7. What is the keyboard shortcut to Select All?

    A.  Ctrl + R

    B.   Ctrl + Alt

    C.   Ctrl + Enter

    D.  Ctrl + A

    Answer: D) Ctrl + A

    8. Which of the following keyboard shortcut is used to select the text in the direction of the arrow key?

    A.  Ctrl + Arrow

    B.   Shift + Arrow

    C.   Ctrl + Shift

    D.  Ctrl + S

    Answer: B) Shift + Arrow

    9. Which option is correct to save the document in MS Word?

    A.  Save

    B.   Save As

    C.   Ctrl+S

    D.  All of the above

    Answer: D) All of the above

    10. Where is the Word Count shown in MS Word?

    A.  Ribbon

    B.   Task Bar

    C.   Status Bar

    D.  View

    Answer: C) Status Bar

    11Which is not an edition of MS Word?

    (A) MS Word 2003

    (B) MS Word 2007

    (C) MS Word 2010

    (D) MS Word 1020

    Answer (D)

    12. Which of the following is a type of Page Orientation?

    A.  Portrait

    B.   Landscape

    C.   Both A. and B.

    D.  None of the above

    Answer: C) Both A. and B.

    13. What is the default paper size in MS Word?

    A.  8*11

    B.   8.5*11

    C.   8*11.5

    D.  8.5*11.5

    Answer: B) 8.5*11

    14. What is the default margin set in MS Word?

    A.  0.5 Inch

    B.   1 Inch

    C.   1.5 Inch

    D.  0.1 Inch

    Answer: B) 1 Inch

    15. Press ____ to open the help window in the MS Word document.

    (A) F1

    (B) F2

    (C) F9

    (D) F11

    Answer (A)

    
    

     

    Introduction to MS Excel

    MS Excel is a commonly used Microsoft Office application. It is a spreadsheet program which is used to save and analyse numerical data.

    MS Excel

    What is MS Excel?

    MS Excel is a spreadsheet program where one can record data in the form of tables. It is easy to analyse data in an Excel spreadsheet.

    
    

    
    

    What is a cell?

    A spreadsheet is in the form of a table comprising rows and columns. The rectangular box at the intersection point between rows and columns forms a cell. 

    Multiple-Choice Questions  in MS Excel

    Q 1. The address that is obtained by the combination of the Row number and the Column alphabet is called ________.

    1.   Worksheet

    2.   Cell

    3.   Workbox

    4.   Cell Address

    5.   Column Address

    Answer: (4) Cell Address

    Q 2. Where is the option for page border given in the MS Excel spreadsheet?

    1.   Home

    2.   Insert

    3.   Format

    4.   View

    5.   Page Border cannot be added in excel worksheet

    Answer: (5) Page Border cannot be added in excel worksheet

    Q 3. Excel workbook is a collection of _______ and _______.

    1.   Worksheet and charts

    2.   Graphs and images

    3.   Sheets and images

    4.   Video and audio

    5.   None of the above

    Answer: (1) Worksheet and charts

    Q 4.  Which keyboard key is used for Help in MS Excel?

    1.   ctrl+H

    2.   F2

    3.   F1

    4.   shift+H

    5.   Alt+ctrl+home

    Answer: (3) F1

    Q 5. How can you activate a cell in MS Excel?

    1.   By clicking on it

    2.   By pressing the arrow keys

    3.   By pressing Tab key

    4.   All of the above

    5.   None of the above

    Answer: (4) All of the above

    6. MS Excel 2007 में By Default कितनी Sheet होती हैं

    A) 2
    B) 1
    C) 3
    D) 4

    ANSWER= (C) 3

    7. MS Excel में सभी Formulas – – – – से शुरु होते हैं

    A) %
    B) +
    C) =
    D) >

    ANSWER= (C) =

    8- What is MS Excel?

    1.    Spreadsheet 

    2.    Database Management 

    3.    Presentation 

    4.    Workbook 

    Answer: Option A 

    9- What is the row limit of MS Excel 2019? 

    1.    4,81,0576

    2.    1,048,576

    3.    1,57,648

    4.    1,63, 84

    Answer: Option B

     1,048,576

    10- Which keyboard shortcut is used to easily switch open workbooks?

    1.    Alt+S

    2.    CTRL+S

    3.    CTRL+Alt 

    4.    CTRL+Tab

    Answer: Option D 
    

    INPUT OUTPUT DEVICE