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

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: ______________________________________________________________

E-Commerce with ASP

Q1: Inside which HTML by Electronic Commerce we mean ______________.
        a) Commerce of electronic goods
        b) Commerce which depends on electronics
        c) Commerce which is based on the use of internet
        d) Commerce which is based on transactions using computers connected by telecommunication network.

Q2: Inside which HTML element do we put the Javascript?
        a) JS             b) <Script>       c) <Scripting>       d) <JavaScript>

Q3: Where is the correct place to insert a JavaScript?
        a) The <Body. Section.             b) The <Head> section.
        c) Both the <head> section & <body> section are correct

Q4: 

System Analyzing & Designing

Q1: MIS stands for __________________________________________.
             1. Micro information system                         2. Micro individual system
             3. Management individual system                  4. Management information system

Q2: ________________ steps are in the system development life cycle (SDLC).
            a)  4                b) 6                c)  5                 d) 10

Q3: The first step in the system development life cycle (SDLC) is __________________.
            a)  Analysis                                          b) Design      
            c) Problem/Opportunity identification    d) Development and Documentation

Q4: The ________________ determines whether the project should go forward.
            a) Feasibility assessment                    b) Opportunity identification
            c) System evolution                           d)  Program Specification

Q5: The organized process or set of steps that needs to be followed to develop an information system is known as the _____________________
            a) Analytical cycle                            b) Design cycle
            b) Program specification                   d) System development life

Q6: Which of the following hardware component is the most important to the operation of the database management system?
            a) High resolution video display           b) Printer
            c) High speed, large capacity disk       d) Plotter

Q7: The traditional methodology used to develop, maintain and replace information system_____.
            a) Development                                 b) Analysis
            c) Design                                           d) None of these

Q8: A continuous process of system investigation is _____________________.
            a) Documentation                               b) Implementation
            c) Data collection                               d) Feasibility Determination

Q9: A sample system development before the actual design is ___________________.
            a) Model                 b) Pilot           c) Trail             d) Dummy

Q10: Close ended questionnaires ask user for ________________.
           a) Check list approach                      b) True & False
           c) Description                                   d) All of the above

Q11: Open-ended questionnaires ask user for _______________.
          a) Check list approach                      b) Description
          c) Multi choice Questions                  d) All of above

Q12: The problem statement includes all of the following EXCEPT ___________.
          a) Input             b)Processing          c) Output           d) Storage

Q13: In which phase of SDLC are CASE tool, Gantt charts and per chart used.
          a) Phase 1          b) Phase 2             c) Phase 3            d)Phase 4

Q14: A data element in a data dictionary may have _____________.
          a) Only integer                           b) No value
          c) Only real                               d) Only decimal value

Q15: By metadata we mean _______________.
          a) Very Large Data                  b) Data Dictionary
          c) Data about data                   d) Meaningful data

Q16: Stack Time = ____________________.
           a) LFT - EFT                          b) LST + LFT
           c) EST - LFT                          d) None of these

Q17: Entity Relation Diagram is created after.
           a) Logical Diagram                  b) O Diagram
           c) Context Diagram                 d) Physical Diagram

Q18: In interactive data input a menu is used to ____________.
           a) Enter new data                     b)Add/delete data
           c) Select one out of many alternatives often by a mouse click
           d) Detect errors in data input