PS Exam

http://www.mcqquestions.com/

 

Fundamentals of Computer – Set 1

1-1. FORTRAN programming language is more suitable for ……
A. Business Applications
B. Marketing Applications
C. Scientific Applications
D. None of the above

1-2. Mostly which of the following device is used to carry user files?
A. Floppy Disk
B. Hard Disk  
C. RAM
D. CDROM

1-3. Which device is used to backup the data?
A. Floppy Disk
B. Tape
C. Network Drive
D. All of the above

1-4. In order to play and hear sound on a computer, one needs:
A. a sound card and speakers
B. a microphone
C. all of them required
D. none of them required

1-5. Which of the following are the cheapest memory devices in terms of Cost/Bit?
A. Semiconductor memories
B. Magnetic Disks
C. Compact Disks
D. Magnetic Tapes

1-6. In a computer _____ is capable to store single binary bit.
A. Capacitor
B. Flip flop
C. Register
D. Inductor

1-7. A set of flip flops integrated together is called ____
A. Counter
B. Adder
C. Register
D. None of the above

1-8. Which of the following are the best units of data on an external storage device?
A. Bits
B. Bytes
C. Hertz
D. Clock cycles

1-9. A register organized to allow to move left or right operations is called a ____
A. Counter
B. Loader
C. Adder
D. Shift register

1-10. Which of the following have the fastest access time?
A. Semiconductor Memories
B. Magnetic Disks
C. Magnetic Tapes
D. Compact Disks

Answers
1 – C / 2 – A / 3 – D / 4 – A / 5 – C / 6 – B / 7 – C /  8 – B / 9 – D / 10 – A

Fundamentals of Computer – Set 2

2-1. Which is a semi conductor memory?
A. Dynamic
B. Static
C. Bubble
D. Both a & b

2-2. Which of the following is a read only memory storage device?
A. Floppy Disk
B. CD-ROM  
C. Hard Disk
D. None of these

2-3. Which of the following is a programming language?
A. Lotus
B. Pascal
C. MS-Excel
D. Netscape

2-4. What do you call the translator which takes assembly language program as input & produce machine language code as output?
A. Compiler
B. Interpreter
C. Debugger
D. Assembler

2-5. What is a compiler?
A. A compiler does a conversion line by line as the program is run
B. A compiler converts the whole of a higher level program code into machine code in one step
C. A compiler is a general purpose language providing very efficient execution
D. None of the above

2-6. What is an interpreter?
A. An interpreter does the conversion line by line as the program is run
B. An interpreter is the representation of the system being designed
C. An interpreter is a general purpose language providing very efficient execution
D. None of the above

2-7. What are the stages in the compilation process?
A. Feasibility study, system design and testing
B. Implementation and documentation
C. Lexical Analysis, syntax analysis, and code generation
D. None of the above

2-8. A Compiler is ____
A. a combination of computer hardware
B. a program which translates from one high-level language to another
C. a program which translates from one high-level to a machine level language
D. None of these

2-9. When a key is pressed on the keyboard, which standard is used for converting the keystroke into the corresponding bits?
A. ANSI
B. ASCII
C. EBCDIC
D. ISO

2-10. A Pixel is ………
A. A computer program that draws picture
B. A picture stored in secondary memory
C. The smallest resolvable part of a picture
D. None of these

Answers
1 – D / 2 – B / 3 – B / 4 – D / 5 – B / 6 – B / 7 – C / 8 – C / 9 – A / 10 – C

Fundamentals of Computer – Set 3

3-1. Which device is used as the standard pointing device in a Graphical User Environment?
A. Keyboard
B. Mouse
C. Joystick
D. Track ball

3-2. Which number system is usually followed in a typical 32-bit computer?
A. 2
B. 10  
C. 16
D. 32

3-3. Which number system is usually followed in a typical 32-bit computer?
A. Binary
B. Decimal
C. Hexadecimal
D. Octal

3-4. Which of the following is not an output device?
A. Scanner
B. Printer
C. Flat Screen
D. Touch Screen

3-5. Which of the following devices have a limitation that we can only store information to it but cannot erase or modify it?
A. Floppy Disk
B. Hard Disk
C. Tape Drive
D. CDROM

3-6. Which technology is used in Compact disks?
A. Mechanical
B. Electrical
C. Electro Magnetic
D. Laser

3-7. Which of the following storage devices can store maximum amount of data?
A. Floppy Disk
B. Hard Disk
C. Compact Disk
D. Magneto Optic Disk

3-8. Which of the following is the largest manufacturer of Hard Disk Drives?
A. IBM
B. Seagate
C. Microsoft
D. 3M

3-9. The programs which are as permanent as hardware and stored in ROM is known as
A. Hardware
B. Software
C. Firmware
D. ROM ware

3-10. Memory is made up of
A. Set of wires
B. Set of circuits
C. Large number of cells
D. All of these

Answers
1 – B / 2 – A / 3 – A / 4 – A / 5 – D / 6 – D / 7 – B / 8 – B / 9 – C / 10 – C

Fundamentals of Computer – Set 4

4-1. Primary memory stores
A. Data alone
B. Programs alone
C. Results alone
D. All of these

4-2. EPROM can be used for
A. Erasing the contents of ROM
B. Reconstructing the contents of ROM  
C. Erasing and reconstructing the contents of ROM
D. Duplicating ROM

4-3. Which device can understand difference between data & programs?
A. Input device
B. Output device
C. Memory
D. Microprocessor

4-4. The contents of information are stored in
A. Memory data register
B. Memory address register
C. Memory arithmetic registers
D. Memory access register

4-5. Memory unit is one part of
A. Input device
B. Control unit
C. Output device
D. Central Processing Unit

4-6. Algorithm and Flow chart help us to
A. Know the memory capacity
B. Identify the base of a number system
C. Direct the output to a printer
D. Specify the problem completely and clearly

4-7. Which of the following is not a valid size of a Floppy Disk?
A. 8″
B. 5 1/4″
C. 3 1/2″
D. 5 1/2″

4-8. The basic operations performed by a computer are
A. Arithmetic operation
B. Logical operation
C. Storage and relative
D. All the above

4-9. The earliest calculating devices are
A. Abacus
B. Clock
C. Difference Engine
D. None of these

4-10. Who built the first Mechanical Calculator
A. Joseph Marie Jacquard
B. John Mauchly
C. Blaise Pascal
D. Howard Aiken
Answers :

1 – D / 2 – C / 3 – D / 4 – A / 5 – D / 6 – D / 7 – D / 8 – D / 9 – A / 10 – C

Fundamentals of Computer – Set 5

5-1. Punched cards were first introduced by
A. Powers
B. Pascal
C. Jacquard
D. Herman Hollerith

5-2. Computers built before the First Generation of computers were:
A. Mechanical
B. Electro-mechanical
C. Electrical
D. None of these

5-3. Word length of a Personal Computer is ___
A. 4 bits
B. 8 bits
C. 16 bits
D. 64 bits

5-4. Size of the primary memory of a PC ranges between
A. 2KB to 8KB
B. 64KB & 256KB
C. 256KB & 640KB
D. None of these

5-5. CPU speed of a personal computer is
A. 32 KIPS
B. 100 KIPS
C. 1 MIPS
D. None of these

5-6. Programs are executed on the basis of a priority number in a
A. Batch processing system
B. Multiprogramming
C. Time sharing
D. None of these

5-7. Cursor is a ____
A. Pixel
B. Thin blinking line
C. Pointing device
D. None of these

5-8. Operating system, editors, and debuggers comes under?
A. System Software
B. Application Software
C. Utilities
D. None of the above

5-9. What is the first stage in software development?
A. Specification and design
B. Testing
C. System Analysis
D. Maintenance

5-10. What is System Analysis?
A. The design of the screen the user will see and use to enter or display data
B. System analysis defines the format and type of data the program will use
C. System Analysis involves creating formal model of the problem to be solved
D. None of the above

Answers :
1 – D / 2 – B / 3 – B / 4 – C / 5 – B / 6 – B / 7 – B / 8 – A / 9 – C / 10 – C

Fundamentals of Computer – Set 6

6-1. What do you call the programs that are used to find out possible faults and their causes?
A. Operating system extensions
B. Cookies
C. Diagnostic software
D. Boot diskettes

6-2. Which programming languages are classified as low level languages?
A. Basic, COBOL, FORTRAN
B. Prolog 2, Expert Systems
C. Knowledge based Systems
D. Assembly Languages

6-3. Which of the following is not anti-viruses software?
A. NAV
B. F-Prot
C. Oracle
D. McAfee

6-4. Which device is required for the Internet connection?
A. Joystick
B. Modem
C. CD Drive
D. NIC Card

6-5. What does DMA stand for?
A. Distinct Memory Access
B. Direct Memory Access
C. Direct Module Access
D. Direct Memory Allocation

6-6. Which of the following is a storage device?
A. Tape
B. Hard Disk
C. Floppy Disk
D. All of the above

6-7. When did John Napier develop logarithm?
A. 1416
B. 1614
C. 1641
D. 1804

6-8. A normal CD-ROM usually can store up to __________data?
A. 680 KB
B. 680 Bytes
C. 680 MB
D. 680 GB

6-9. MIS is designed to provide information needed for effective decision making by?
A. Consumers
B. Workers
C. Foremen
D. Managers

6-10. What is a light pen?
A. Mechanical Input device
B. Optical input device
C. Electronic input device
D. Optical output device

Answers
1  – C / 2  – D / 3 – C / 4 – B / 5 – B / 6 – D / 7 – B / 8 – C / 9 – D / 10 – B

Fundamentals of Computer – Set 7

7-1. The Second Generation Computer was based on ________.
A. Vacuum Tube
B. Silicon Chips
C. Transistor
D. Bio Chips

7-2. The Third Generation Computer was made with ________.
A. Vacuum Tube
B. Discrete Components
C. IC
D. Bio Chips

7-3. The BIOS is the abbreviation of ________.
A. Basic Input Output System
B. Best Input Output System
C. Basic Input Output Symbol
D. Base Input Output System

7-4. What do you call a single point on a computer screen?
A. Cell
B. Element
C. Pixel
D. Bit

7-5. RJ45 UTP cable has ________ Cables.
A. 2 pair
B. 3 pair
C. 4 pair
D. 5 pair

7-6. Basic is ________ language.
A. a procedural
B. an object oriented
C. both A and B
D. none of the above

7-7. In ________ mode, the communication channel is used in both directions at the same time?
A. Full-duplex
B. Simplex
C. Half-duplex
D. None of the above

7-8. How was the generation of computer classified?
A. by the device used in memory & processor
B. by the speed of computer
C. by the model of the computer
D. by the accuracy of computer

7-9.    Who invented Analytical engine?
A. Blaise Pascal
B. George Bool
C. Charles Babbage
D. Dr. Herman Hollerith

7-10. Through which device the main components of the computer communicate with each other?
A. Keyboard
B. System Bus
C. Monitor
D. Memory

Answers
1 – C / 2 – C / 3 – A / 4 – C / 5 – C / 6 – A / 7 – A / 8 – A / 9 – C / 10 – B

Fundamentals of Computer – Set 8

8-1.  MICR stands for
A.  Magnetic Ink Character Reader
B.  Magnetic Ink Code Reader
C.  Magnetic Ink Case Reader
D.  None of the above

8-2.  Which access method is used to access cassette tape?
A.  Direct
B.  Sequential      
C.  Both of the above
D.  None of the above

8-3.  EEPROM stands for
A.  Electrically Erasable Programmable Read Only Memory
B.  Electronic Erasable Programmable Read Only Memory
C.  Easily Erasable Programmable Read Only Memory
D.  Easily Erasable Programmable Read Only Memory

8-4.  Which of the following memories need refresh?
A.  SRAM
B.  DRAM
C.  ROM
D.  All of the above

8-5.  ASCII stands for
A.  American Standard Code for Information Interchange
B.  American Scientific Code for International Interchange
C.  American Standard Code for Intelligence Interchange
D.  American Scientific Code for Information Interchange

8-6.  The output quality of a printer is measured by
A.  Dot per sq. inch
B.  Dot per inch
C.  Dots printed per unit time
D.  All of the above

8-7.  Main storage is also called
A.  Accumulator
B.  Control Unit
C.  Register Unit
D.  Memory

8-8.  Which is valid statement
A.  1 KB = 1024 Bytes
B.  1 MB = 1024 Bytes
C.  1 KB = 1000 Bytes
D.  1 MB = 1000 Bytes

8-9.  After copying the content how many times can you paste?
A.  1
B.  16
C.  32
D.  Many

8-10.  1 nibble equals to
A.  1 bits
B.  2 bits
C.  4 bits
D.  8 bits

 Answers
1 – A / 2 – B / 3 – A / 4 – B / 5 – A / 6 – B / 7 – D / 8 – A / 9 – D / 10 – C

Fundamentals of Computer – Set 9

9-1  Which of the following Language that Computer can Understand & Execute?
A.  Machine Language
B.  C Programming Language
C.  Java Programming Language
D.  None of the Above

9-2  Who is credited for using punch cards to control patterns of a weaving machine?
A.  Blaise Pascal
B.  Herman Hollerith     
C.  Jacquard
D.  Charles Babbage

9-3  Dedicated Computer means
A. Doesn’t have OS
B. Used by single person
C. Assigned to one and only one task
D. All of Above

9-4  Computer Keyboard can be classified as __________ Device?
A.  Memory
B.  Input
C.  Output
D.  Storage

9-5  Physical connection between Microprocessor Memory and other parts is called _________
A.  Path
B.  Hub
C.  Address bus
D.  None of the above

9-6  Shortcut Notation for groups of four Binary Digits is called ____________ Number System.
A.  Unicode
B.  Decimal
C.  Binary
D.  Hexadecimal

9-7  What is the full form of AT in the IBM PC-AT?
A.  Applied Technology
B.  Advance Technology
C.  Additional Technology
D.  None of the Above

9-8  ____________ has the shortest access times.
A.  Cache Memory
B.  Virtual Memory
C.  Secondary Memory
D.  All of the Above

9-9  In Computer terminology ‘CAD’ is stands for
A.  Computer And Design
B.  Computer Algorithm in Design
C.  Computer Aided Design
D.  None of the above

9-10  Which of the following is not an Input Device?
A.  Touch Screen
B.  Optical Scanners
C.  Touch Pad
D.  Mouse Pad

 Answers
1 – A / 2 – C / 3 – C / 4 – B / 5 – C / 6 – D / 7 – B / 8 – A / 9 – C / 10 – D

xxxxx -----  Fundamentals of Computer  ----  xxxxx

Operating Systems – Set 1

1-1. ______ is used in operating system to separate mechanism from policy
A. Single level implementation
B. Two level implementation
C. Multi level implementation
D. None

1-2. The operating system creates _____ from the physical computer
A. Virtual space
B. Virtual computers  
C. Virtual device
D. None

1-3. ______ shares characteristics with both hardware and software
A. Operating system
B. Software
C. Data
D. None

1-4. Multiprogramming systems:
A. Are easier to develop than single programming systems
B. Execute each job faster
C. Execute more jobs in the same time period
D. Are used only one large mainframe computers.

1-5. Which is the first program run on a computer when the computer boots up?
A. System software
B. Operating system
C. System operations
D. None

1-6. Which is built directly on the hardware?
A. Computer Environment
B. Application Software
C. Operating System
D. Database System

1-7. Which of the following Operating System does not implement multitasking truly?
A. Windows 98
B. Windows NT
C. Windows XP
D. MS DOS

1-8. Which runs on computer hardware and serve as platform for other software to run on?
A. Operating System
B. Application Software
C. System Software
D. All

1-9. Which is the layer of a computer system between the hardware and the user program
A. Operating environment
B. Operating system
C. System environment
D. None

1-10. The primary purpose of an operating system is:
A. To make the most efficient use of the computer hardware
B. To allow people to use the computer,
C. To keep systems programmers employed
D. To make computers easier to use

Answers

1 – B / 2 – B / 3 – A / 4 – C / 5 – B / 6 – C / 7 – D / 8 – A / 9 – B / 10 – A

Operating Systems – Set 2

2-1. When a computer is first turned on or restarted, a special type of absolute loader called ____ is executed
A. Compile and Go loader
B. Boot loader
C. Bootstrap loader
D. Relating loader

2-2. Which of the following Operating systems is better for implementing a Client-Server network
A. MS DOS
B. Windows 95  
C. Windows 98
D. Windows 2000

2-3. The operating system manages
A. Memory
B. Processes
C. Disks and I/O devices
D. all of the above

2-4. Usually, in MSDOS, the primary hard disk drives has the drive letter ____
A. A
B. B
C. C
D. D

2-5. What is the function of an operating system?
A. Manages computer’s resources very efficiently
B. Takes care of scheduling jobs for execution
C. Manages the flow of data and instructions
D. All of the above

2-6. Which is not the function of the Operating System?
A. Memory management
B. Disk management
C. Application management
D. Virus Protection

2-7. Which Operating System doesn’t support networking between computers?
A. Windows 3.1
B. Windows 95
C. Windows 2000
D. Windows NT

2-8. Which Operating System doesn’t support long file names?
A. OS/2
B. Windows 95
C. MS-DOS
D. Windows NT

2-9. Which file keeps commands to execute automatically when OS is started?
A. command.com
B. any batch file
C. autoexec.bat
D. config.sys

2-10. What should be the extension to execute files?
A. EXE
B. BAT
C. COM
D. All of the above

 Answers

1 – C / 2 – D / 3 – D / 4 – C / 5 – D / 6 – D / 7 – A / 8 – C / 9 – C / 10 – D

------ Operating System ------

Microsoft Word – Set 1

1-1. Which option in File pull-down menu is used to close a file in MSWord?
A. New
B. Quit
C. Close
D. Exit

1-2. Which bar is usually located below that Title Bar that provides categorized options?
A. Menu bar
B. Status Bar
C. Tool bar
D. Scroll bar

1-3. Which of these toolbars allows changing of Fonts and their sizes?
A. Standard
B. Formatting
C. Print Preview
D. None of these

1-4. Which key should be pressed to start a new paragraph in MS-Word?
A. Down Cursor Key
B. Enter Key
C. Shift + Enter
D. Ctrl + Enter

1-5. Which menu in MSWord can be used to change character size and typeface?
A. View
B. Tools
C. Format
D. Data

1-6. By default, on which page the header or the footer is printed?
A. on first page
B. on alternate page
C. on every page
D. none of the above

1-7. In MS-Word, for what does ruler help?
A. to set tabs
B. to set indents
C. to change page margins
D. All of the above

1-8. Using Find command in Word, we can search?
A. characters
B. formats
C. symbols
D. All of the above

1-9. MS-Word automatically moves the text to the next line when it reaches the right edge of the screen and is called?
A. Carriage Return
B. Enter
C. Word Wrap
D. None of the above

1-10. Selecting text means, selecting?
A. a word
B. an entire sentence
C. whole document
D. any of the above

Answers
1 – C / 2 – A / 3 – B / 4 – B / 5 – C / 6 – C / 7 – D / 8 – D / 9 – C / 10 – D

Microsoft Word – Set 2

2-1. Single spacing in MS-WORD document causes ____ point line spacing?
A. 10
B. 12
C. 14
D. 16

2-2. Which would you choose to display the statistics about a document?
A. tools, word count
B. insert, statistics
C. tools, spelling and grammar
D. tools, statistics

2-3. Which feature do you use to create a newspaper like document?
A. Bullets & numbering
B. Tables
C. Columns
D. Tab stops

2-4. Which would you choose to list Synonyms & Antonyms of a selected word?
A. Tools, Spelling & Grammar
B. Tools, Language
C. Tools, Options
D. Insert, Cross-reference

2-5. Which language does MS-Word use to create Macros?
A. Visual C++
B. Visual Basic
C. FoxPro
D. Access

2-6. What do you call ‘a collection of character and paragraph formatting commands’?
A. the defaults
B. a template
C. a style
D. a boilerplate

2-7. In MS Word, Ctrl+S is for …..
A. Scenarios
B. Size
C. Save
D. Spelling Check

2-8. Which key is used to increase left indent?
A. Ctrl+I
B. Ctrl+M
C. Alt+I
D. F10

2-9. Which key is used to select all the text in the document?
A. Ctrl+T
B. Ctrl+A
C. Ctrl+F
D. Ctrl+N

2-10. To undo the last work, press …..
A. Ctrl+U
B. Ctrl+Y
C. Ctrl+Z
D. Ctrl+W

==========================
Answers
1 – B / 2 – A / 3 – C / 4 – B / 5 – B / 6 – C / 7 – C / 8 – B / 9 – B / 10 – C

Microsoft Word – Set 3

3-1. Which enables us to send the same letter to different persons?
A. macros
B. template
C. mail merge
D. none

3-2. Which key deletes the character to the left of the cursor?
A. End
B. Backspace
C. Home
D. Delete

3-3. Which key deletes the character to the right of the cursor?
A. End
B. Backspace
C. Home
D. Delete

3-4. Which would you choose to save a document with a new name?
A. Press Ctrl+S
B. Click File, Save
C. Click Tools, Options, Save
D. Click File, Save As

3-5. Which would you choose to move selected text from one place to another?
A. Move and Paste
B. Copy and Paste
C. Cut and Paste
D. Delete and Paste

3-6. How do you magnify your document?
A. View, Zoom
B. Format, Font
C. Tools, Options
D. Tools, Customize

3-7. Which enables you to move directly to specific location in a document?
A. Subdocuments
B. Bookmarks
C. Cross-references
D. Outlines

3-8. What are inserted as cross-reference in Word?
A. Placeholders
B. Bookmarks
C. Objects
D. Word fields

3-9. Which keystroke is used for updating a field?
A. F6
B. F9
C. F11
D. F12

3-10. A master document contains ………, each of which contains a pointer to a file on a disk?
A. Placeholders
B. subdocuments
C. bookmarks
D. references

 Answers

1 – C / 2 – B / 3 – D / 4 – D / 5 – C / 6 – A / 7 – B / 8 – D / 9 – B / 10 – B

Microsoft Word – Set 4

4-1. When typing in a word field manually, what must you press to insert the code’s braces?
A. Ctrl + F6
B. Ctrl + F9
C. Alt + F11
D. Shift + F12

4-2. A word field may consist of an optional field instruction called a(n) …………..
A. subdocument
B. symbol
C. signal
D. switch

4-3. Footnotes, endnotes, and indexes are all inserted as ………….
A. bookmarks
B. cross-references
C. hyperlinks
D. word fields

4-4. Before creating a master document, you must switch to..……
A. Normal View
B. Outline View
C. Web Layout View
D. Print Layout View

4-5. Before moving a subdocument to another location within a master document, you must switch to …………..
A. Normal View
B. Outline View
C. Web Layout View
D. Print Layout View

4-6. Which of the following can be used to navigate documents?
A. frames
B. hyperlinks
C. web toolbar
D. all of the above

4-7. Which of the following can be used to divide a web page into areas?
A. frames
B. theme
C. table of contents
D. none of the above

4-8. By default, Word automatically formats each heading in a table of contents as ………..
A. bookmarks
B. cross-references
C. hyperlinks
D. word-fields

4-9. The ability to combine name and addresses with a standard document is called ……….
A. document formatting
B. database management
C. mail merge
D. form letters

4-10. Which feature is used for monitoring all document changes?
A. Edit Document
B. Monitor Change
C. Track Change
D. Track all

=========================
Answers
1 – B / 2 – D / 3 – D / 4 – B / 5 – B / 6 – B / 7 – A / 8 – C / 9 – C / 10 – C

Microsoft Word – Set 5

5-1. When sharing data in Office, the ……… document is the document in which the data was first entered.
A. source
B. destination
C. original
D. primary

5-2. Which command is used to establish a link between a source document and a destination document?
A. Tools, Link, Documents
B. Tools, Link
C. Edit, Link
D. Edit, Paste Special

5-3. Which option enables automatic updates in destination documents?
A. embedding
B. objects
C. links
D. relationships

5-4. Which is an Office feature that makes it easy to edit embedded objects?
A. pasting
B. visual editing
C. tools, update, links
D. edit, links

5-5. Which is true when you insert an excel worksheet into a word document?
A. word is the destination document
B. excel is the destination document
C. the worksheet is the destination document
D. the document is the source document

5-6. What would you do when you want to update the data in an embedded worksheet range?
A. double click the worksheet range object
B. right click worksheet range object & choose format object
C. edit the data in the destination document
D. edit the data in the source document.

5-7. Which can be used for quick access to commonly used commands and tools?
A. Status bar
B. Tool bar
C. Menu bar
D. Title bar

5-8. With which view can you see how text and graphics will appear on the printed page?
A. Normal
B. Print Layout
C. Outline
D. Web Layout

5-9. Which simplifies the process of formatting text if the same formatting is required in more than one location?
A. Auto Text
B. Format Painter
C. Font dialog box
D. None of the above

5-10. Which of the following is best for quick copy operation?
A. Copy and Paste
B. Windows Clipboard
C. Drag and Drop
D. Auto Text

==================================
Answers
1 – A / 2 – D / 3 – C / 4 - B / 5 - A / 6 – A / 7 – B / 8 – B / 9 – B / 10 – C

Microsoft Word – Set 6

6-1. Which simplifies the process of formatting text if the same formatting is required in more than one location?
A. Auto Text
B. Format Painter
C. Font dialog box
D. None of the above

6-2. Which of the following is best for quick copy operation?
A. Copy and Paste
B. Windows Clipboard
C. Drag and Drop
D. Auto Text

6-3. Which of the following operations moves text from clipboard?
A. Copy
B. Paste
C. Drag and Drop
D. Cut

6-4. Which of the following provides a list ofx synonyms?
A. Find command
B. Replace Command
C. Thesaurus
D. Spelling and Grammar

6-5. Which of the following helps to reduce spelling error in the document?
A. Auto Format
B. Auto Correct
C. Smart Tags
D. Auto Text

6-6. Auto text and Auto correct are ___________ tools.
A. styling
B. editing
B. designing
D. none of the above

6-7. Which of the following enables you to make multiple changes in a document at once?
A. find command
B. Replace command
C. Drag and Drop
D. copy command

6-8. Which of the following commands should you always use before submitting a document to others?
A. find command
B. Replace command
C. Spelling and Grammar
D. Thesaurus

6-9. Which of the following enables you to paste data multiple times?
A. windows clipboard
B. office clipboard
C. both A and B
D. none of the above

6-10. Which of the following do you use to change margins?
A. formatting toolbar
B. page setup dialog box
C. Standard toolbar
D. paragraph dialog box

Answers
1 – B / 2 – C / 3 – B / 4 – C / 5 – B / 6 – B / 7 – B / 8 – C / 9 – C / 10 – B

Microsoft Word – Set 7

7-1. Which do you press to force a page break?
A. CTRL+ALT
B. CTRL+ break
C. CTRL+ Enter
D. none of the above

7-2. Which do you choose to create footer? (in MS Office 2003)
A. format, header and footer
B. view, footer
C. insert, header and footer
D. view, header and footer

7-3. Which do you choose to create header? (in MS Office 2003)
A. format, header and footer
B. view, header
C. insert, header and footer
D. view, header and footer

7-4. Which do you choose to shade words and paragraph?
A. format, borders and shading
B. insert, borders and shading
C. view, shading
D. none of the above

7-5. to view headers and footers, you must switch to
A. normal view
B. print layout view
C. print preview mode
D. both B and C

7-6. Which of the following can you change using the page setup dialog box?
A. margins
B. page orientation
C. vertical alignment
D. all of the above

7-7. By default, your document prints with:
A. 1 inch top and bottom margins
B. a portrait orientation
C. 1.25 inches left and right margins
D. all of the above

7-8. switching between portrait and landscape modes involves the:
A. header and footer toolbar
B. print layout view
C. page setup dialog box
D. none of the above

7-9. What happens when you insert an AutoShape by simply clicking in the document?
A. it appears near the insertion point
B. it is inserted in its default size
C. is selected
D. all of the above

7-10. What must be used to control the layering of objects?
A. formatting toolbar
B. picture toolbar
C. drawing toolbar
D. image toolbar

 Answers
1 – C / 2 – D / 3 – D / 4 – A / 5 – D / 6 – D / 7 – D / 8 – C / 9 – D / 10 – C

Microsoft Word – Set 8

8.1 What is the shortcut key to “Center Align” the selected text?
A. Ctrl + C
B. Ctrl + E
C. Ctrl + F
D. None of above

8.2 What is the shortcut key to “Undo” the last action in a document?
A. Ctrl + X
B. Ctrl + Y  
C. Ctrl + Z
D. None of above

8.3 What is the shortcut key to “Insert Hyperlink” in a document?
A. Ctrl + H
B. Ctrl + L
C. Ctrl + K
D. None of above

8.4 What is the shortcut key for “Find and Replace” dialog box?
A. Ctrl + F
B. Ctrl + R
C. Ctrl + H
D. Ctrl + Shift + F

8.5 What is the shortcut key for Spelling Check in document?
A. F7
B. Shift + F7
C. Ctrl + F7
D. Alt + F7

8.6 What is the shortcut key to Update Formula in a table?
A. F9
B. Alt + F9
C. Ctrl + F9
D. Shift + F9

8.7 What is the shortcut key to Close Active Document in Microsoft Word?
A. Ctrl + F4
B. Shift + F4
C. Ctrl + Shift + F4
D. None of above

8.8 What is the shortcut key for “Font” dialog box?
A. Ctrl + F
B. Ctrl + D
C. Ctrl + G
D. None of the above

8.9 What is the shortcut key for “Superscript” the selected text?
A. Ctrl + =
B. Ctrl + -
C. Ctrl + Shift + =
D. Ctrl + Shift + -

8.10 What is the shortcut key for “Subscript” the selected text?
A. Ctrl + =
B. Ctrl + -
C. Ctrl + Shift + =
D. Ctrl + Shift + -

 Answers
1 – B / 2 – C / 3 – C / 4 – C / 5 – A / 6 – A / 7 – A / 8 – B / 9 – C / 10 – A

---- Microsoft Word -----

Microsoft Excel – Set 1

1-1. Comments put in cells are called …..
A. Smart Tip
B. Cell Tip
C. Web Tip
D. Soft Tip

1-2. Comments can be added to cells using …..
A. Edit -> Comments
B. Insert -> Comment  
C. File -> Comments
D. View –> Comments

1-3. Which menu option can be used to split windows into two?
A. Format -> Window
B. View -> Window-> Split
C. Window -> Split
D. View –> Split

1-4. Getting data from a cell located in a different sheet is called….
A. Accessing
B. Referencing
C. Updating
D. Functioning

1-5. Which of the following is not a valid data type in Excel?
A. Number
B. Character
C. Label
D. Date/Time

1-6. Which elements of a worksheet can be protected from accidental modification?
A. Contents
B. Objects
C. Scenarios
D. All of the above

1-7. A numeric value can be treated as label value if …… precedes it.
A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Tilde (~)

1-8. Concatenation of text can be done using
A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&)

1-9. Which area in an Excel window allows entering values and formulas?
A. Title Bar
B. Menu Bar
C. Formula Bar
D. Standard Tool Bar

1-10. Multiple calculations can be made in a single formula using…..
A. Standard Formulas
B. Array Formula
C. Complex Formulas
D. Smart Formula

Answers
1 – B / 2 – B / 3 – C / 4 – B / 5 – B / 6 – D / 7 – A / 8 – D / 9 – C / 10 – B

Microsoft Excel – Set 2

2-1. An Excel Workbook is a collection of …….
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts

2-2. What do you mean by a Workspace?
A. Group of Columns
B. Group of Worksheets
C. Group of Rows
D. Group of Workbooks

2-3. MS-EXCEL is based on ……….?
A. WINDOWS
B. DOS
C. UNIX
D. OS/2

2-4. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
A. AutoFill
B. Auto correct
C. Auto sum
D. Auto format

2-5. To select an entire column in MS-EXCEL, press?
A. CTRL + C
B. CTRL + Arrow key
C. CTRL + S
D. None of the above

2-6. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
A. ROUND ( )
B. FACT ( )
C. MOD ( )
D. DIV ( )

2-7. Which function is not available in the Consolidate dialog box?
A. Pmt
B. Average
C. Max
D. Sum

2-8. Which is not the function of “Edit, Clear” command?
A. Delete contents
B. Delete notes
C. Delete cells
D. Delete formats

2-9. Microsoft Excel is a powerful………..
A. Word processing package
B. Spreadsheet package
C. Communication S/W Package
D. DBMS package

2-10. How do you rearrange the data in ascending or descending order?
A. Data, Sort
B. Data, Form
C. Data, Table
D. Data Subtotals

Answers
1 – D / 2 – D / 3 – A / 4 – C / 5 – D / 6 – C / 7 – A / 8 – C / 9 – B / 10 – A
=========================

Microsoft Excel – Set 3

3-1. Which Chart can be created in Excel?
A. Area
B. Line
C. Pie
D. All of the above

3-2. What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?
A. 5,430.00
B. 5,436.80
C. 5,436.8
D. 6.8

3-3. How do you display current date and time in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()

3-4. How do you display current date only in MS Excel?
A. date ()
B. Today ()
C. now ()
D. time ()

3-5. How do you wrap the text in a cell?
A. Format, cells, font
B. Format, cells, protection
C. format, cells, number
D. Format, cells, alignment

3-6. What does COUNTA () function do?
A. counts cells having alphabets
B. counts empty cells
C. counts cells having number
D. counts non-empty cells

3-7. What is the short cut key to highlight the entire column?
A. Ctrl+C
B. Ctrl+Enter
C. Ctrl+Page Up
D. Ctrl+Space Bar

3-8. In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *
C. %
D. &

3-9. Excel displays the current cell address in the ……….
A. Formula bar
B. Status Bar
C. Name Box
D. Title Bar

3-10. What is the correct way to refer the cell A10 on sheet3 from sheet1?
A. sheet3!A10
B. sheet1!A10
C. Sheet3.A10
D. A10

===========================
Answers
1 – D / 2 – B / 3 – C / 4 – B / 5 – D / 6 – D / 7 – D / 8 – A / 9 – C / 10 – A

Microsoft Excel – Set 4

4-1. Which language is used to create macros in Excel?
A. Visual Basic
B. C
C. Visual C++
D. Java

4-2. Which of the following is not a term of MS-Excel?
A. Cells
B. Rows
C. Columns
D. Document

4-3. How many worksheets can a workbook have?
A. 3
B. 8
C. 255
D. none of above

4-4. Which would you choose to create a bar diagram?
A. Edit, Chart
B. Insert, Chart
C. Tools, Chart
D. Format, Chart

4-5. Which setting you must modify to print a worksheet using letterhead?
A. Paper
B. Margin
C. Layout
D. Orientation

4-6. What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
A. XY Chart
B. Line Chart
C. Pie Chart
D. Column Chart

4-7. The spelling dialog box can be involved by choosing spelling from ________ menu.
A. insert
B. file
C. tools
D. view

4-8. Which key do you press to check spelling?
A. F3
B. F5
C. F7
D. F9

4-9. To record a sequence of keystrokes and mouse actions to play back later we use:
A. Media player
B. Sound Recorder
C. Calculator
D. Macro Recorder

4-10. We can save and protect the workbook by
A. Write Reservation Password
B. Protection Password
C. Read-only Recommended
D. Any of the above

===================================
Answers
1 – A / 2 – D / 3 – D / 4 – B / 5 – B / 6 – C / 7 – C / 8 – C / 9 – D / 10 – D

Microsoft Excel – Set 5

5-1. The first cell in EXCEL worksheet is labeled as
A. AA
B. A1
C. Aa
D. A0

5-2. What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)
A. An absolute cell address is created.
B. Cell address will change when it is copied to another cell.
C. The sheet tab is changed.
D. The status bar does not display the cell address.

5-3. What are the tabs that appear at the bottom of each workbook called?
A. Reference tabs
B. Position tabs
C. Location tabs
D. Sheet tabs

5-4. What is represented by the small, black square in the lower-right corner of an active cell or range?
A. Copy handle
B. Fill handle
C. Insert handle
D. Border

5-5. In Excel, a Data Series is defined as what?
A. A type of chart.
B. A cell reference.
C. A collection of related data
D. A division of results

5-6. In Excel, the Fill Color button on the Formatting toolbar is used for what?
A. To insert a background.
B. To add borders.
C. To select a distribution of figures.
D. To add shading or color to a cell range.

5-7. In help menu of Excel, which of the following tabs are found?
A. Contents tab
B. Answer Wizard tab
C. Index tab
D. all of the above.

5-8. A __________ is a grid with labeled columns and rows.
A. Dialog box
B. Worksheet
C. Clipboard
D. Toolbar

5-9. The active cell:
A. is defined by a bold border around the cell.
B. Receives the data the user enters.
C. It is the formula bar.
D. Only A and B.

5-10. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
A. Logical
B. Math & Trigonometry
C. Statistical
D. Financial

================================
Answers
1 – B / 2 – A / 3 – D / 4 – B / 5 – C / 6 – D / 7 – D / 8 – B / 9 – D / 10 – D

Microsoft Excel – Set 6

6-1. B7:B9 indicates:
A. Cells B7 and cell B9 only.
B. Cells B7 through B9.
C. Cell B8 only.
D. None of the above.

6-2. The Cancel and Enter buttons appear in the:
A. Title bar
B. Formula bar
C. Menu bar
D. Sheet tabs

6-3. MS-EXCEL can be used to automate
A. Financial statements, Business forecasting
B. Transaction registers, inventory control
C. Accounts receivable, accounts payable
D. Any of the above

6-4. NOT, AND, OR and XOR are
A. Logical Operators
B. Arithmetic operators
C. Relational operators
D. None of the above

6-5. In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a
A. calendar
B. photograph of rainfall
C. chart showing rainfall amounts
D. database of rainfall

6-6. You want to record experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be:
A. word processing
B. spreadsheet
C. database
D. graphics

6-7. You are editing an worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?
A. New
B. Save As
C. Edit
D. Save

6-8. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
A. Re-format the spreadsheet
B. Insert a row
C. Increase the column width
D. Use the spacebar

6-9. In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………
A. ascending order
B. descending order
C. alphabetical order
D. random order

6-10. In order to perform a calculation in a spreadsheet, you need to use a:
A. table
B. formula
C. field
D. variable

Answers
1 – B / 2 – B / 3 – D / 4 – A / 5 – C / 6 – B / 7 – B / 8 – B / 9 – B / 10 – B

Microsoft Excel – Set 7

7-1. The box on the chart that contains the name of each individual record is called the ________.
A. cell
B. title
C. axis
D. legend

7-2. If you want all of the white cats grouped together in the database, you need to sort by ________.
A. Color, then Gender
B. Pet Type, then Color
C. Pet Type, then Gender
D. Color, then Pet Name

7-3. You accidentally erased a record in the sheet. What command can be used to restore it immediately?
A. Insert
B. Copy
C. Undo
D. Replace

7-4. Where a row and a column meet, what do you call that?
A. A cell
B. A block
C. A box
D. None of the above

7-5. How do you tell one cell from another?
A. By numbers
B. By letters
C. By its address
D. by color

7-6. Give me an example of a cell address.
A. 11 25
B. 911
C. 41A
D. A21

7-7. Which is an example of a formula?
A. =A1+A2
B. =add(A1:A2)
C. A1+A2
D. SUM(A1:A2)

7-8. Which is an example of a function?
A. =add(A1:A2)
B. =A1+A2
C. =SUM(A1:A2)
D. A1+A2

7-9. What is the symbol for multiplying?
A. >
B. /
C. !
D. *

7-10. What is the symbol for dividing?
A ./
B. %
C. &
D. #

Answers
1 – D / 2 – B / 3 – C / 4 – A / 5 – C / 6 – D / 7 – A / 8 – C / 9 – D /10 – A

Microsoft Excel – Set 8

8-1  A function inside another function is called _______
A. Nested function
B. Round function
C. Sum function
D. Text function

8-2  Which of the following is not an underline option in the format cells dialog box?
A. Double
B. Single Accounting    
C. Double Accounting
D. Single Engineering

8-3  Formulas in Excel start with
A.   %
B.   =
C.   +
D.   -

8-4  The default header for a worksheet is
A. Username
B. Date and Time
C. Sheet tab Name
D. None

8-5  Which of the following is not an option of the spelling dialog box?
A. Ignore
B. Ignore all
C. Edit
D. Change

8-6  Which of the following methods will not enter data in a cell?
A. Pressing the Esc key
B. Pressing an arrow key
C. Pressing the tab key
D. Clicking the enter button to the formula bar

8-7  The cell reference for cell range of G2 to M12 is _______
A.   G2.M12
B.   G2;M12
C.   G2:M12
D.   G2-M12

8-8  What is the keyboard shortcut for creating a chart from the selected cell range?
A.   F2
B.   F4
C.   F8
D.   F11

8-9 The Software which contains rows and columns is called ______
A. Database
B. Drawing
C. Spreadsheet
D. Word processing

8-10 You can group noncontiguous worksheets with
A. The alt+enter key
B. The ctrl key and mouse
C. The shift key and the mouse
D. The group button on the standard toolbar

Answers
1 – A / 2 – D / 3 – B / 4 – D / 5 – C / 6 – A / 7 – C / 8 – D / 9 – C / 10 – B

---- Microsoft Excel ----

Microsoft PowerPoint – Set 1

1-1.  Power Point presentation is a collection of ________
A. Slides and Handouts
B. Speaker’s notes
C. Outlines
D. All of the above

1-2.  How can the slide show be repeated continuously?
A. loop continuously until ‘Esc’
B. repeat continuously  
C. loop more
D. none

1-3.  From where can we set the timing for each object?
A. slide show, custom transition
B. Slide show, Slide transition
C. slide show, custom animation
D. view, slide sorter

1-4.  The arrangement of elements such as Title and subtitle text, pictures, tables etc. is called :
A. Layout
B. Presentation
C. Design
D. Scheme

1-5.  A File which contains readymade styles that can be used for a presentation is called :
A. AutoStyle
B. Template
C. Wizard
D. Pre formatting

1-6.  After choosing a predefined template, which option has to be chosen to change the background color?
A. Design Template
B. Color Scheme
C. Animation Scheme
D. Color Effects

1-7.  Ellipse Motion is a predefined ________
A. Design Template
B. Color Scheme
C. Animation Scheme
D. None of these

1-8.  Animation Schemes can be applied to ________ in the presentation.
A. All slides
B. Select slides
C. Current Slide
D. All of the above

1-9.  To insert new slide in the current Presentation, we can choose:
A. Ctrl+M
B. Ctrl+N
C. Ctrl+O
D. Ctrl+F

1-10.  To open the existing presentation, press
A. Ctrl + L
B. Ctrl + N
C. Ctrl + A
D. Ctrl + O

 Answers
1 – D / 2 – A / 3 – C / 4 – A / 5 – B / 6 – B / 7 – C / 8 – D / 9 – A / 10 – D

Microsoft PowerPoint – Set 2

2-1.  Slides can have
A. title, text, graphs
B. drawn objects, shapes
C. clipart, drawn art, visual
D. any of the above

2-2.  A Chart can be put as a part of the presentation using
A. Insert -> Pictures –> Chart
B. Insert –> Chart  
C. Edit –> Chart
D. View -> Chart

2-3.  We can replace a font on all slides with another font using the option :
A. Edit –> Fonts
B. Tools –> Fonts
C. Tools -> Replace Fonts
D. Format -> Replace Fonts

2-4.  Which key on the keyboard can be used to view Slide show?
A. F1
B. F2
C. F5
D. F10

2-5.  Which option in PowerPoint allows you to create a package of your presentation for showing to another computer?
A. Save As
B. Save and Go
C. Pack and Go
D. Web and Go

2-6.  Which view in Power Point can be used to enter Speaker Comments?
A. Normal
B. Slide Show
C. Slide Sorter
D. Notes Page view

2-7.  Which option can be used to set custom timings for slides in a presentation?
A. Slider Timings
B. Slider Timer
C. Rehearsal
D. Slide Show Setup

2-8.  Which option can be used to create a new slide show with the current slides but presented in a different order?
A. Rehearsal
B. Custom Slide show
C. Slide Show Setup
D. Slide Show View

2-9.  Which of the following is an example for Automatic Text formatting?
A. Underlining Hyperlink
B. Adjusting extra space
C. Replacing two – s with a hyphen
D. All of the above

2-10.  Power Point can display data from which of the following add-in software of MS Office?
A. Equation Editor
B. Organization Chart
C. Photo Album
D. All of these

Answers
1 – D / 2 – A / 3 – D / 4 – C / 5 – C / 6 – D / 7 – C / 8 – B / 9 – D / 10 – D

Microsoft PowerPoint – Set 3

3-1.  The spelling dialog box can be involved by choosing spelling from ________ menu.
A. Insert
B. File
C. Tools
D. View

3-2.  Which key do you press to check spelling?
A. F3
B. F5
C. F7
D. F9

3-3.  Which PowerPoint feature allows the user to create a simple presentation without having to spend too much time on it?
A. AutoContent Wizard
B. Animation
C. Color Schemes
D. Chart Wizard

3-4.  Which PowerPoint feature adds special effects to modify the appearance of the slides and the timing between each slide?
A. Color Schemes
B. Animation
C. Transition Settings
D. Handouts

3-5.  Slide sorter of PowerPoint is available on _____ menu.
A. Insert
B. File
C. View
D. Edit

3-6.  To print the PowerPoint presentation, press
A. Ctrl + T
B. Ctrl + E
C. Ctrl + S
D. Ctrl + P

3-7.  What is a slide transition?
A. Overheads
B. Letters
C. A special effect used to introduce a slide in a slide show
D. The way one slide looks

3-8.  What does “apply design template” do?
A. Changes the content of the slide
B. Adds functionality to the slide
C. Changes the look of the slide without changing the content
D. None of the above

3-9.  How can you stop a slide show?
A. Press the right arrow
B. Press Escape
C. Press the left arrow
D. Press the down arrow

3-10.  What do you do to start the slide show?
A. Click on Go
B. Turn on transition
C. Click on the Slide Show icon
D. All of the above

 Answers
1 – C / 2 – C / 3 – A / 4 – C / 5 – C / 6 – D / 7 – C / 8 – C / 9 – B / 10 – C

Microsoft PowerPoint – Set 4

4.1  Which type of template provides a design concept, fonts & color scheme for presentation?
A.  Format
B.  Design
C.  Content
D.  Normal

4.2  In Normal view, this tab displays the content of each slide.
A.  Slides
B.  View    
C.  Sort
D.  Outline

4.3  Which is the menu to create a text box on a slide.
A.  View -> Text Box
B.  Tools -> Text Box
C.  Insert -> Text Box
D.  Format -> Text Box

4.4  Which is not the one of view options provided by PowerPoint to look at and modify presentation.
A.  Slide Show
B.  Format Slide
C.  Slide Sorter
D.  Normal

4.5  In PowerPoint, when the mouse pointer appears as this it indicates that the Draw Table feature is on
A.  Solid plus sign
B.  Solid arrow
C.  I-beam
D.  Pencil

4.6  Which is the menu command to recolor a picture on a slide
A.  Insert -> Picture -> Recolor
B.  Tools -> Picture -> Recolor
C.  Format -> Picture -> Recolor
D.  Edit -> Picture -> Recolor

4.7  PowerPoint design templates are stored in a file with this extension.
A.  .ptt
B.  .pot
C.  .ppt
D.  .dtp

4.8  In Power Point, this is a container for text or graphics.
A.  Slide master
B.  Table
C.  Placeholder
D.  Text box

4.9  This is the menu command used to apply a design template in PowerPoint.
A.  Tools -> Slide Design
B.  Format -> Slide Design
C.  Insert  -> Slide Design
D.  Insert -> Slide Design

4.10  This task pane shows the design that is currently being used in a presentation.
A.  Slide Show
B.  Slide Style
C.  Slide Design
D.  Slide Format

 Answers
1 – B / 2 – D / 3 – C / 4 – B / 5 – D / 6 – C / 7 – B / 8 – D / 9 – B / 10 – C

soft PowerPoint – Set 5

5.1  What is the shortcut key for repeat the recent find?
A.  CTRL + F4
B.  SHIFT + F4
C.  CTRL + F5
D.  SHIFT + F5

5.2  Which is the Shortcut key to start a presentation from the beginning?
A.  F5
B.  ALT + F5    
C.  CTRL + F5
D.  SHIFT + F5

5.3  Which is the shortcut key to jump to the first slide of the presentation?
A.  Home
B.  Alt + Home
C.  Ctrl + Home
D.  Shift + Home

5.4  To select more than one slide in the presentation
A.  Just Click on slide
B.  Ctrl + Click on slide
C.  Alt + Click on slide
D.  Shift + Click on slide

5.5  To place something in the same position on every slide of presentation automatically, insert into
A.  Slide master
B.  Notes master
C.  Handout master
D.  None of the above

5.6  To edit an already inserted embedded organization chart object by
A.  Double Click on the organization chart object
B.  CTRL + Click on the organization chart object
C.  SHIFT + Click on the organization chart object
D.  None of the above

5.7  Shortcut key to insert a hyperlink in a slide
A.  Ctrl + H
B.  Ctrl + K
C.  Hyperlinks can’t be inserted in slides
D.  None of the above

5.8  To draw the Square box in the slide by selecting rectangle tool
A.  Holding CTRL & Draw
B.  Holding ALT & Draw
C.  Holding SHIFT & Draw
D.  All of the above

5.9  What is the maximum zoom percentage in Microsoft PowerPoint?
A.  100%
B.  200%
C.  300%
D.  400%

5.10  Microsoft PowerPoint can insert objects from the following add-ins?
A.  Equation Editor
B.  Organization Chart
C.  Photo Album
D.  All of these

 Answers
1 – B / 2 – A / 3 – C / 4 – B / 5 – A / 6 – A / 7 – B / 8 – C / 9 – D / 10 – D

---- Microsoft PowerPoint ----

Microsoft Access – Set 1

1-1.  An organized collection of logically related data is known as
A. Data
B. Meta data
C. Database
D. Information

1-2.  In databases, Locking level is also called as
A. Granularity
B. S lock
C. X lock
D. Dead lock

1-3.  Which of the following is not a database application?
A. dBase
B. Flash
C. FoxPro
D. Access

1-4.  HSAM stands for ________
A. Hierarchic Sequential Access Method
B. Hierarchic Standard Access Method
C. Hierarchic Sequential and Method
D. Hierarchic Standard and Method

1-5.  Which of the following is not a logical database structure?
A. Chain
B. Network
C. Tree
D. Relational

1-6.  In a datasheet, what does each column represent?
A. Record
B. Field
C. Database
D. Table

1-7.  In a datasheet, what does each row represent?
A. Record
B. Field
C. Database
D. Table

1-8.  A ________ is a unit of information in a ________
A. record, field
B. field, record
C. data source, field
D. record, data source

1-9.  What do you call a primary key field included in another table?
A. Foreign key
B. Parent key
C. Child key
D. Index

1-10.  Which type of field is incremented automatically?
A. Auto Elevate
B. AutoNumber
C. Auto Increment
D. Auto Value

 Answers
1 – C / 2 – A / 3 – B / 4 – A / 5 – A / 6 – B / 7 – A / 8 – B / 9 – A / 10 – B

Microsoft Access – Set 2

2-1.  Which object is used to create a form?
A. Tables and Queries
B. Tables only
C. Tables and reports
D. Queries and reports

2-2.  What determines a table’s sort order?
A. AutoNumber field
B. Index field  
C. Field order
D. Primary key

2-3.  What is an intersection of a row and a column?
A. Form
B. Cursor
C. Cell
D. Record

2-4.  Which tool do you use to create a query object?
A. Database wizard
B. Simple filter wizard
C. Simple query wizard
D. Table query wizard

2-5.  Which of the following is not a view for interacting with a form object?
A. Datasheet view
B. Design view
C. Form view
D. Layout view

2-6.  What is the purpose of indexing?
A. To reduce table size
B. To speedup data search
C. both A and B
D. none of the above

2-7.  Which is the valid data type in Access?
A. Number
B. Text
C. Currency
D. All of the above

2-8.  How many relations may exist between two tables in databases?
A. 4
B. 3
C. 2
D. 1

2-9.  What is the full form of SQL?
A. Sophisticated Question List
B. Structured Question List
C. Structured Query Language
D. Small Query Length

2-10.  Which data type is better to use for storing phone number in the following format “977-1-1234567”?
A. Text
B. AutoNumber
C. Number
D. Currency

 Answers
1 – A / 2 – B / 3 – C / 4 – C / 5 – D / 6 – B / 7 – D / 8 – B / 9 – C / 10 – A

Microsoft Access – Set 3

3-1.  What do you call a collection of records matching parameters of a query?
A. Field
B. Record
C. Query
D. Dynaset

3-2.  Which query do you use to answer the question “Which employees earn more than $5000 a month”?
A. Search query
B. Cross tab query  
C. Select query
D. Update query

3-3.  In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
A. zipcode, firstname, lastname
B. firstname, lastname, zipcode
C. zipcode, lastname, firstname
D. can’t sort by multiple fields

3-4.  What does the expression [detail] ! [product] * 1.30 do?
A. multiplies the contents of detail and product fields by 1.3
B. First divides detail by product and then multiplies by 1.3
C. multiplies the contents of detail in the product table by 1.3
D. multiplies the contents of product in the detail table by 1.3

3-5.  Which criteria return only those addresses beginning with the letter “K”?
A. address = “K”
B. address = “K*”
C.  address = “K?”
D. address = “K#”

3-6.  Which criteria do not return the position “Officer” as a match?
A. position = “*ff*”
B. position = “O??icer”
C. position = “ ?ff*”
D. position = “O#r”

3-7.  Which query do you use to answer the question “What is the average salary of the employees”?
A. Search query
B. Cross tab query
C. Select query
D. Update query

3-8.  What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
A. display all customers with CustID from 10 to 100
B. display all customers with CustID above 10
C. display all customers with CustID below 100
D. display all customers with CustID from 11 to 99

3-9.  How to make a date field DOB store the dates like “2002/10/17” ?
A. By setting the input mask property to “yyyy/mm/dd”
B. By setting the format property to “yyyy/mm/dd”
C. By entering dates in yyyy, mm, dd order
D. none of the above

3-10.  You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
A. By setting required to ‘Yes’
B. By using default value
C. By defining validation rule
D. By using format

Answers
1 – D / 2 – C / 3 – C / 4 – D / 5 – B / 6 – D / 7 – C / 8 – D / 9 – B / 10 – C

Microsoft Access – Set 4

4-1.  In an application created using the database wizard, the main menu is presented as a:
A. form, called a switchboard
B. report, called a menu
C. table, called a switchboard
D. query, called a menu

4-2.  Which leads you through the process of creating a table?
A. wizard
B. assistant    
C. relation
D. coach

4-3.  Which data type is better to use for storing the price of an item?
A. Text
B. AutoNumber
C. Number
D. Currency

4-4.  Which do you click to display the table’s primary key and indexes in a separate window?
A. indexes button
B. primary key button
C. view datasheet button
D. view design button

4-5.  After right click the field selector button, which do you choose to delete a field in design view?
A. Delete field
B. delete rows
C. remove field
D. remove rows

4-6.  Which tool is used to generate printout of a table’s structure?
A. Analyzer
B. Designer
C. Documenter
D. Generator

4-7.  Which of the following is not a legitimate section for form objects?
A. Form detail
B. Group header
C. Form header
D. Page footer

4-8.  The basic elements of a form or a report are called:
A. Controls
B. Objects
C. Windows
D. Properties

4-9.  Which control types is most often associated with a bound control?
A. command button
B. label
C. text box
D. list box

4-10.  Which control type do you use to create a calculated control?
A. command button
B. combo box
C. text box
D. list box

 Answers
1 – A / 2 – A / 3 – D / 4 – A / 5 – B / 6 – C / 7 – B / 8 – A / 9 – C / 10 – C

Microsoft Access – Set 5

5-1.  Which is not a view for displaying a report object?
A. Datasheet view
B. Design view
C. Print preview
D. Layout preview

5-2.  The report footer section is most useful for displaying:
A. grand totals
B. Column headings  
C. subtotals
D. page numbers

5-3.  Which function can not be used for calculated controls in a report?
A. SUM
B. AVG
C. MPT
D. COUNT

5-4.  Which setting you must modify to print a report using letterhead?
A. Group
B. Margin
C. Section
D. Orientation

5-5.  In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
A. datasheet border
B. datasheet underline
C. Column Header underline
D. vertical gridline

5-6.  Which is not an option for customizing a datasheet window?
A. change one row’s height
B. hide one column
C. change one column’s width
D. freeze one column

5-7.  Which is not a command that is selectable from right click menu of a field column?
A. Hide columns
B. Unhide columns
C. freeze columns
D. sort descending

5-8.  What do you call the process of restricting the display of records in a table to those matching a particular criterion?
A. filtering
B. restricting
C. sorting
D. sifting

5-9.  In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
A. Referential integrity is enforced
B. Referential integrity isn’t enforced
C. An inner join is set
D. An outer join is set

5-10.  Which of the following is not an action query?
A. add
B. delete
C. make-table
D. update

 Answers
1 – A / 2 – A / 3 – C / 4 – B / 5 – C / 6 – A / 7 – B / 8 – A / 9 – A / 10 – A

---- Microsoft Access ----

Web Designing – Set 1

1-1.  What is the full form of HTML?
A. Hyper text markup language
B. Hyphenation text markup language
C. hyphenation test marking language
D. hyper text marking language

1-2.  What is the full form of HTTP?
A. Hyper text transfer protocol
B. Hyper text transfer package  
C. Hyphenation text test program
D. none of the above

1-3.  What is a search engine?
A. a program that searches engines
B. a web site that searches anything
C. a hardware component
D. an machinery engine that search data

1-4.  What is the full form of TCP/IP?
A. transmission control protocol / internet protocol
B. telephone call protocol / international protocol
C. transport control protocol / internet protocol
D. none of the above

1-5.  HTML document start and end with which tag pairs?
A.
B. …..
C. ……
D. ……

1-6.  Which tag is used to create body text in HTML?
A.
B.
C. tag must be within ________
A. Title
B. Form
C. Header
D. Body

2-2.  Text within … tag is displayed as ________
A. bold
B. italic  
C. list
D. indented

2-3.  Text within … tag is displayed as ________
A. bold
B. italic
C. list
D. indented

2-4. 

…

tag is used to ________
A. display the numbered list
B. underline the text
C. display the bulleted list
D. bold the text

2-5.  Which tag is used to display the numbered list?
A.

B.

C.

D.

2-6.  Which tag is used to display the large font size?
A.
B.
C. < SIZE >
D.

2-7.  tag can be placed within ________
A. Header
B. Body
C. both A and B
D. none of the above

2-8.  using

tag will
A. start a new paragraph
B. break the line
C. end the current paragraph
D. none of the above

2-9.  … tag is used for ________
A. Table heading
B. Table Records
C. Table row
D. none of the above

2-10.  Which is true to change the text color to red?
A.
B.
C.
D. none of the above

  Answers
1 – C / 2 – B / 3 – A / 4 – C / 5 – A / 6 – B / 7 – C / 8 – A / 9 – B / 10 – B

Web Designing – Set 3

3-1.  With regards to e-mail addresses:
A. they must always contain an @ symbol
B. they can never contain spaces
C. they are case-insensitive
D. all of the above

3-2.  A homepage is __________
A. an index of encyclopedia articles
B. where all Internet data is stored    
C. required for access to the Internet
D. the first page of a website

3-3.  Which of the following is used to explore the Internet?
A. Browser
B. Spreadsheet
C. Clipboard
D. Draw

3-4.  What is Internet Explorer?
A. An Icon
B. A File Manager
C. A Browser
D. The Internet

3-5.  What do I need to get onto the Internet?
A. Computer
B. Modem
C. Browser
D. All of the above

3-6.  What is an ISP?
A. Internet System Protocol
B. Internal System Program
C. Internet Service Provider
D. None of the above

3-7.  Which of the following is valid IP address?
A. 984.12.787.76
B. 192.168.321.10
C. 1.888.234.3456
D. 192.168.56.115

3-8.  Which is not a domain name extension
A. .mil
B. .org
C. .int
D. .com

3-9.  What is a FTP program used for?
A. Transfer files to and from an Internet Server
B. Designing a website
C. Connecting to the internet
D. None of the above

3-10.  Which of the following are commonly found on web pages?
A. internet
B. hyperlinks
C. intranet
D. all of the above

Answers
1 – D / 2 – D / 3 – A / 4 – C / 5 – D / 6 – C / 7 – D / 8 – C / 9 – A / 10 – B

Web Designing – Set 4

4.1  What is the correct syntax in HTML for creating a link on a webpage?
A.
B.
C.
D. < A HREF = “ghumti.html”>

4.2  Which of the following is an attribute of

tag?
A. SRC
B. LINK  
C. CELLPADDING
D. BOLD

4.3  Choose the correct HTML tag to make the text bold?
A.
B.
C.
D. Both A) and C)

4.4  Which HTML tag would be used to display power in expression (A+B)² ?
A.
^B.
_C.
D.

4.5  Choose the correct HTML code to create an email link?
A.
B.
C. ganesh@ghumti.com
D.

4.6  Choose the correct HTML tag for the largest heading?
A.

B.

C.
D.

4.7  Output of XML document can be viewed in a
A. Word Processor
B. Web browser
C. Notepad
D. None of the above

4.8  What is the correct way of describing XML data?
A. XML uses a DTD to describe data
B. XML uses a description node to describe data
C. XML uses XSL to describe the data
D. XML uses a validator to describe the data

4.9  Comments in XML document is given by:
A.
B.
C.
D.

4.10  Which statement is true?
A. An XML document can have one root element
B. An XML document can have one child element
C. XML elements have to be in lower case
D. All of the above

 Answers
1 – D / 2 – C / 3 – D / 4 – A / 5 – B / 6 – A / 7 – B / 8 – C / 9 – C / 10 – A

Web Designing – Set 5

5.1  How to define target in new page in HTML?
A.  Click Here
B.   Click Here
C.   Click Here
D.   Click Here

5.2  In HTML, Uniform Resource Identifier (URI) is used to
A.  To create a frame document .
B.  To create a image map in the webpage.      
C.  To customize the image in the webpage.
D.  To identify a name or a resource on the internet.

5.3  CSS is an acronym for
A.  Cascading Style Sheet
B.  Costume Style Sheet
C.  Cascading System Style
D.  None of the Above

5.4  Which of the following protocol is not used in the Internet
A.  Telnet
B.  WIRL
C.  HTTP
D.  Gopher

5.5  Who invented World Wide Web (WWW)?
A.  Blaise Pascal
B.  Charles Babbage
C.  Herman Hollerith
D.  Tim Berners-Lee

5.6  What is the use of Web Font in HTML ?
A.  that is the core font that is use to develop Web Pages.
B.  that enables to use fonts over the Web without installation.
C.  that is the special font that developed by Microsoft Corp.
D.  All of the Above.

5.7  What is tag in HTML?
A.  It renders fonts as teletype text font style.
B.  It renders fonts as truetype text font style.
C.  It renders fonts as truncate text font style.
D.  None of the Above.

5.8  What is the use of Forms in HTML?
A.  to display contents of email.
B.  to display animation effect.
C.  to collect user’s input.
D.  None of the Above.

5.9  What is the use of iframe in HTML?
A.  to display a web page within a web page.
B.  to display a web page with animation effect.
C.  to display a web page without browser.
D.  All of the Above.

5.10  FTP is an acronym for
A.  File Transaction Protocol
B.  File Transmission Protocol
C.  File Translation Protocol
D.  File Transfer Protocol

Answers
1 – B / 2 – D / 3 – A / 4 – B / 5 – D / 6 – B / 7 – A / 8 – C / 9 – A / 10 – D