Thursday, July 3, 2014

Office Automation

Q:No:1: Tick the correct one:

1. The extension of Ms-word document is _____________________.
         a) BMP        b) DOC          c) TXT          d) XLS

2. In Ms-word, to select the whole document, we use ________________.
         a) F1            b) Alt +F        c) Ctrl + A          d) None these

3. In Ms-Word, to insert page break, we can use _____________ key combination.
        a) Alt + Enter          b) Ctrl + Enter         c) Shift + Enter      d) None of these

4. If we want to save an existing save document by pressing CTRL + S, which procedure will be          run?
        a) Save as        b) Save          c) Search          d) Send

5. The Text which comes on top of every page is called _________________
        a) Heading           b) Top             c) Header            d) Footer

6. Shift + F7 is the shortcut of __________________________
        a) Thesaurus        b) Spelling and Grammar       c) Mail Merge       d) Option

7. When you press ____________ key, MS-word Automatically creates a new Paragraph.
        a) Ctrl + Enter      b) Shift + Enter        c) Enter        d) None of these

8. The Word "Wrap Text".
         a) Automatically moves text to the next line when necessary
         b) Appears at the bottom of the document
         c) Allow you to type over text
         d) None of the above

9. ____________ command save the Active files with New File Name.
         a) Save         b) Save As         c) Save As web       d) Version

10. A chart that shows how various values make up a whole is known as _______________
         a) Function       b) Line Graph       c) Pie Chart          d) None of these

11. The Default Name of MS-Excel File is ________________.
         a) Worksheet           b) Workbook          c) Book                d) None of these

12. In Auto Format command we use the ____________ templates to format our worksheet.
         a) Pre-Designed         b) Blank           c) None Pre-Designed       d) None of these

13. Cell Edit key in Excel is _______________________.
         a) F4            b) F2           c) F1              d) Ctrl + F2

14. To drag a selected range of the data to another worksheet in the same workbook, use the 
        a) Tab key           b) Alt Key          c) Ctrl Key          d) None of these

15. MS Excel has maximum __________ number of Column.
        a)  256          b)  65536       c)  6536           d) None of these

16. Microsoft Excel is an Electronic _________________
        a) Worksheet        b) Record book         c) Workbook          d) None of these

17. MS Excel Product of ______________________
        a) Sun Micro System         b) Macromedia          c) Micro Soft         d) Multi Software System

18. By the help of ___________ function we can adds all the numbers in a range of cells.
        a) Count( )            b) Sum( )           c) Add( )             d) Total ( )

19. In Excel, ____________ Command is used arrange data in Ascending or Descending order.
        a) Data---> Sort      b) Data-----> Index     c) Data --->Order     d) Tools--->Sort  

20. MS- Excel Database is limited to the number of rows in worksheet__________.
        a) 65536           b) 65000         c) 40000              d) 256

Q:No:02: Write the purpose of the following Short Keys:

1. Alt + F + S  :   ___________________________________________________________

2. Ctrl + B  :       ___________________________________________________________

3. Ctrl + U  :      ___________________________________________________________

4. Ctrl  + Z  :      ___________________________________________________________

5. Ctrl + I   :       ___________________________________________________________

Q:No:03: Write the purpose of the following Functions:

1. SQRT ( ) : ______________________________________________________________

2. DATE ( ) : ______________________________________________________________

3. SUM( ) : _______________________________________________________________

4. IF ( ) : _________________________________________________________________

5. AVERAGE( ) : __________________________________________________________

Q:No:04: Choose the correct answer:

1. What is the extension of the presentation saved in PowerPoint?
       a)  .DOC            b) .BAT            c) .PPT             d).XLS

2. _____________ key use for start slide show.
       a) F2            b) F3                c) F4            d) F5

3. _____________ Keys save the document.
       a) Ctrl + Enter          b) Shift + Enter       c) Shift + C       d) Ctrl +S

4. ______________ Key use for end the slide show.
       a) ESC              b) TAB             c) Shift + TAB            d) CTRL + ALT

5. PowerPoint is called _______________ software.
       a) Spread Sheet         b) Word Processing      c) Presentation       d) Graphic

6. Which of the following is a helpful way to provide reminders for you during a presentation?
       a) Transparencies          b) Templates              c) Speaker Notes              d) None of these

7. ___________ view enables you to view multiple slides on a single  screen.
       a) Normal View         b) Master           c) Slide sorter view           d) None of these

8. ____________ View is the main editing view, which you use to write and design your        presentation?
       a) Outline           b) Normal           c) Slide Show             d) Slide Sorter

9. What is template?
       a) A template is another word for Table
       b) A template is a collection of pre-designed slides
       c) A template is a paper plate
       d) None of these

10. How can you emphasize (highlight) text on the screen while running the slide show?
        a) Use a pointer and tap the screen repeatedly to get everyone's attention
        b) Use the pen
        c) Point at it with your finger
        d) Pronunciation louder on the words you want to emphasize

Wednesday, July 2, 2014

DOS & Windows

Q:No:1: In DOS, by the help of _________ command we can duplicate file at current location or another location.
          a) COPY            b) Del Tree          c) REN            d) CD

Q:No:2: DOS is an example of ______________ software.
          a) Operating System                               b) Virus Protection
          c) Application Software                          d) None of these

Q:No:3: ________________ command is used to Remove Directory from Disk.
          a) RD         b) Del           c) Remove            d) Erase

Q:No:4: Internal commands are resides in _____________________
          a) Floppy Disk     b) Memory      c) Hard Disk      d) None of these

Q:No:5: All internal commands are Present in _________________ file.
          a) IO.Sys        b) Msdos.sys      c) Command.com        d) None of these

Q:No:6: REN command changes the name of __________________.
          a) Volume Label         b) Fat          c) Sector         d) None of these

Q:No:7: The ______________ commands are always stored in RAM.
          a) Internal            b) Command.com        c) External         d) IO.Sys

Q:No:8: _______________ command is used to delete a file or multiple files.
           a) Del        b) Remove         c) Erase          d) RD

Q:No:9: FAT stands for_____________________________________.
          a) File Access Table                        b) File Allocation Tracks
          c) File Allocation Table                    d) None of these

Q:No:10: The internal name of disk is called _______________________
          a) Volume Label        c) FAT        b) Sector             d) None of these

Q:No:11: Windows is a product of ___________________________
          a) Sun Micro system       b) Microsoft       c) Macromedia       d) None of these

Q:No:12: Which company developed the first graphical user interface ?
          a) Microsoft           b) AT & T         c) IBM            d) None of these

Q:No:13: To activate the Help facility of Microsoft we use ____________ key.
          a) F10          b) Alt + Tab           c) Ctrl + W       d) F1

Q:No:14: To switch between different programs or application we use ________ key.
          a) Ctrl + Tab      b) Alt + Tab      c) Alt + Shift      d) None of these

Q:No:15: GUI stands for _____________________________________
          a) Graphic Unit Introduction                      b) Graphical User Interface
          c) Graphics Unit Interface                          d) None of these

Q:No:16: The Extension of wordpad file __________________________
           a) Doc            b) Txt              c) Rtf                d) Dco

Q:No:17: The Default Name of Notepad File _________________________
           a) Text           b) Untitled         c) Document         d) Doc

Q:No:18: The operating system is the most common type of ______________ software.
           a) Word-processing software                             b) Application
           c) System                                                          d) Communication

Q:No:19: DSL is an example of a ___________________ connection.
            a) Broadband       b) Wireless      c) Network            d) Slow

Q:No:20: The CPU and memory are located on the ___________________
            a) Motherboard      b) Storage Device    c) Output device     d) Expansion board

Q:No:21: What is difference between single User & Multi User operating System?
Ans:      _______________________________________________________________
            ________________________________________________________________
            ________________________________________________________________
           _________________________________________________________________
           _________________________________________________________________
           _________________________________________________________________

Q:No:22: Difference between DOS & Windows.
Ans:       _______________________________________________________________
            ________________________________________________________________
            ________________________________________________________________
           _________________________________________________________________
           _________________________________________________________________
           _________________________________________________________________

Q:No:23: Write the description of the following commands:
           Commands             Description
           Cls                          _________________________________________________
           Vol                         _________________________________________________
           Copy                      __________________________________________________
           Format                   __________________________________________________
           Date                      ___________________________________________________

Q:No:24: Write syntax and purpose of the following commands and also state type of command.

1: Date:  _________________________________________________________________
        Syntax: _____________________________________________________________
        Purpose: ____________________________________________________________

2: Label: _________________________________________________________________
           Syntax: ____________________________________________________________
           Purpose: ___________________________________________________________

3: CLS: __________________________________________________________________
           Syntax: _____________________________________________________________
           Purpose: ____________________________________________________________

4: Erase/Delete: _____________________________________________________________
           Syntax: ______________________________________________________________
           Purpose: _____________________________________________________________

5: Dir: _____________________________________________________________________
           Syntax: _______________________________________________________________
           Purpose: ______________________________________________________________