All Type Computer

1. The following device allows the user to add external components to a computer system.
 (A) Storage devices
 (B) Keyboards
 (C) Ports/ system boards
(D) Diskettes


 2. Software that manages data in more than one file at a time and these files are treated as tables with rows and columns rather than as lists of records is
(A) Relational Data Base Management Package
(B) Data Base Management Package
(C) Documentation Package
(D) None of these

 3. A program that remains in the memory while other programs are executing
(A) Resident Program
(B) Non-Resident Program
(C) Permanent Program
(D) None of these


 4. The total time elapsed between submission of command and data to a computer and getting the result of computation is the
(A) Access time
(B) Response time
(C) Entrance time
(D) None of these


5. An  automatic  machine  that  is  made  to perform routine human tasks is
(A) Computer
(B) Robot
(C) Tanker
(D) None of these


6. The time required to complete a single, continuous execution of an object program is called
(A) Run time
(B) Access time
(C) Random time
(D) Response time


7. Computer network is a
(A) A distributed data processing system
(B) Multiple computers are linked together for the purpose of data communication and resource sharing
(C) Both A & B are false
(D) Both A & B are true

8. A process  of collecting, organizing, storing and   otherwise   maintaining   a  complete historical  record  of  programs  and  other documents  used  or  prepared  during the different phases of the system is called
(A) Documentation
(B) Document reader
(C) Data process
(D) None of these


9. What are connector symbol?
(A) They are used in a flowchart
(B) It represents a junction in a flow line
(C) Often used to transfer flow between different pages of a lengthy chart
(D) All the above


 10. Console is
(A) A device that enables human operators to communicate with the computer
(B) A device that enables human operators not to communicate with the computer
(C) Communication between computers
(D) None of these


11. Constant is a value written into a program instruction
(A) that does not change during the execution of the program
(B) that can change during the execution of the program
(C) that can vary during the execution of the program
(D) none of these


12. A removable direct-access storage medium containing multiple magnetic disks mounted vertically on a single-shaft is referred as
(A) Tape pack
(B) Disk pack
(C) Cylinder
(D) None of these


13. Diskette is a
(A) A low-cost, thin flexible magnetic disk storage device
(B) High volume  storage device
(C) Primary storage device
(D) None of these

14. An optical input device that is used to read documents printed in a special type font is known as
 (A) Document reader
(B) Documentation
(C) Printer
(D) None of these


15. For checking spelling one uses
(A) Dictionary Disk
(B) Index disk
(C) Directory
(D) None of these
16. Process of finding/ correcting program errors is
(A) Bugs
(B) Debugging
(C) Hacking
(D) Cracking


17. Diagnostic routines is a
(A) Programs used to print error messages
(B) Indicates system problems and improper program instructions.
(C) Both A & B are true
(D) None of these
18. The term DBMS is referred to
(A) Data Base Management system
(B) The software used for the management, maintenance and retrieval of the data stored in a data base
(C) Both A & B are true
(D) None of these


19. The speed at which data is transferred from the main memory to another medium on which data are recorded is referred as
(A) Data transfer rate
(B) Byte
(C) Buds
(D) None of these
20. The time period during which a computer is malfunctioning or not operating correctly due to machine failures is referred as
(A) Downtime
(B) Uptime
(C) Runtime
(D) None of these


21. Automatic execution of high-priority computer programs that have been designed to preempt the use of computer resources is referred as
(A) Foreground processing
(B) background processing
(C) black processing
(D) white processing


22. Digitizer is an input device
(A) Used to convert graphic and pictorial data into binary inputs for a digital computer
(B) Used to convert graphic and pictorial data into analog inputs for a digital computer.
(C) Used for debugging
(D) None of these


23. A storage devices where the access time is effectively independent of the location of the data is referred as
(A) Direct access
(B) Secondary storage
(C) Primary storage
(D) None of these


24. A pictorial representation that uses predefined symbols to describe either the logic of a computer program or the data flow and processing steps of a system is referred as
(A) Flowchart
(B) Algorithm
(C) Program
(D) None of these


25. A flat, circular plate coated with a magnetic material on which data can be stored by magnetization of portions of the flat surface is
(A) Disk
(B) Tape
(C) Pen drive
(D) None of these
26. Disk operating system is referred for
(A) DOS
(B) Operating system which contains the disk-oriented commands and uses disk devices for permanent storage
(C) Both A & B
(D) None of these


27. Document reader is
(A) An optical input device  used to read documents
(B) A device that arrange the documents
(C) A device that is used to edit document
(D) None of these


28. One or more identifying lines printed at the bottom of a page are referred as
(A) Header
(B) Footer
(C) Index
(D) None of these


29. FORTRAN  is
(A) Formula Translation
(B) A high-level mathematically oriented programming language
(C) Both A & B
(D) None of these


30. A CPU designed specifically to handle the communications processing task with main purpose is to off-load communications processing task from the host computer so that the host computer can be dedicated for applications and data processing jobs.
(A) Backend processor
(B) Front-end processor
(C) Node processor
(D) None of these


31. An adder which adds three binary digits and outputs a result bit and a carry bit is referred as
(A) Half adder
(B) Quarter adder
(C) Full adder
(D) None of these


32. Emulator is a program that
(A) Permits one computer to execute the machine-language instructions of another computer of a different make
(B) Which is not broken down into smaller units
(C) Permits one computer to execute the machine-language instructions of another computer of same make.
(D) None of these


33. Emulator is a program that
(A) Permits one computer to execute the machine-language instructions of another computer of a different make
(B) Which is not broken down into smaller units
(C) Permits one computer to execute the machine-language instructions of another computer of same make.
(D) None of these


34. EDP is referred to
(A) Electronic Data Processing
(B) Data processing through equipment that is predominantly electronic such as digital computer
(C) Both A & B
(D) None of these


35. Internet banking is an example of
(A) Electronic funds transfer (EFT)
(B) EDP (Electronic Data Processing )
(C) EBCDIC
(D) ASCII


36. EBCDIC is
(A) 6-bit coding system
(B) 7-bit coding system
(C) 8-bit coding system
(D) 9-bit coding system


37. A data communication facility on which data can be transmitted in two directions is referred as (A) Duplex
(B) Simplex
(C) Triplex
(D) None of these


38. Electronic Mail /Message System (EMMS) best suits to
(A) Postal service
(B) Telephone service
(C) Telegraph service
(D) None of these


39. Digital Computer is a computer
(A) that works with discrete quantities
(B) that  works with analog quantities
(C) Both A & B
(D) None of these


40. The  subdivision of fields
(A) always done to give the programmer greater flexibility
(B) dependent on  programming language used
(C) never accomplished on fields containing numeric data
(D) all the above


41. The checking operation performed on input is called
(A) validation of data
(B) verification of data
(C) vilification of data
(D) control of data


42. A device that attaches to both ends of an electrical bus and prevents reflection of echoes of signals that reach the end of the bus is called
(A) Terminator
(B) Connector
(C) Processor
(D) None of these


43. A device mounted on a communication satellite which receives, amplifies and retransmits signals’ from earth stations is called
(A) Terminator
(B) Connector
(C) Processor
(D) Transponder


44. Technique of using disk space to make programs believe that the system contains more random access memory (RAM) than is actually available is called
(A) Virtual memory
(B) Secondary memory
(C) Primary memory
(D) None of these


45. A term means that the application software is priced separately from the computer hardware is called
(A) Unbundled
(B) Bundled
(C) Utility
(D) None of these


46. Following is not the operating system
(A) UNIX
(B) DOS
(C) WINDOWS
(D) BASIC


47. Which of the following is true concerning personal computers?
(A) They have been most successful in the home.
(B) They are user friendly
(C) No specific programming technique required
(D) All the above.


48. While buying a PC system, one should first
(A) identify hardware components
(B) define computing needs
(C) both A and B
(D) None of these


49. The  microcomputers  which  have  the  same operating    characteristics    as    the   IBM microcomputers are called
(A) IBM desk top
(B) IBM PC
(C) IBM advanced computers
(D) None of theses


50. The personal computers are also referred as
(A) desk top micros
(B) advanced computers
(C) palmtop computers
(D) all the above


51. POS data-entry system is used  extensively by
(A) banking industry
(B) grocery industry
(C) railroad industry
(D) word-processing industry


52. Primary advantage of key-to-tape data-entry systems
(A) A large percentage of editing can be performed at the time of data entry
(B) Key verification is easily performed
(C) The tape is reusable
(D) Keying errors can be detected as they occur


53. Maximum character EBCDIC can code
(A) 8
(B) 16
(C) 64
(D) 256


54. The hexadecimal number system has a base of
(A) 2
(B) 4
(C) 8
(D) 16


55. The use of parity bit is for
(A) coding
(B) indexing
(C) error-detection
(D) none of  these


56. The following are basic types of recordaccess methods
(A) sequential and random
(B) direct and immediate
(C) sequential and indexed
(D) on-line and real-time


57. Which of the following is input/output device?
(A) monitors 
(B) punched cards
(C) optical scanners
(D) all the above


The following magazine covers only the IBM PC and its compatibles
(A) Byte 
(B) PC Magazine
(C) Personal Computing
(D) Interface Age


59. The word size of a microprocessor refers to:
(A) the number of machine operations performed/ second
(B) the amount of information that can be stored / cycle
(C) the amount of information that can be stored in  bytes
(D) none of these


60. The primary memory of a personal computer consists
(A) ROM only
(B) RAM only
(C) Both ROM and RAM
(D) Memory module


61. Microsoft Excel is
(A) financial planning package
(B) electronic spreadsheet
(C) graphics package
(D) data-base management package


62. All the keys on the IBM PC keyboard repeat as long as one holds them down. These keys are known as
(A) typematic keys
(B) functional keys
(C) automatic keys
(D) alphabetic keys


63. Distributed   data   processing   configuration where   all   activities    passes   through  a centrally located computer is
(A) ring network
(B) spider network
(C) hierarchical network
(D) data control network


64. Communications device, combines transmissions from several devices into on line is
(A) concentrator
(B) modifier
(C) multiplexer
(D) full-duplex line


65. Data communications involving telegraph lines uses
(A) simplex lines
(B) wideband channels
(C) narrowband channels
(D) dialed service


66. An advantage of the laser printer respect to impact printer is
(A) it is quieter/ faster
(B) output is of a high quality
(C) support  wide range of type fonts
(D) all the above


67. Data entry can be performed with all of the following except
(A) OCR / OMR
(B) COM
(C) Voice-recognition systems
(D) MICR


68. Magnetic tape can serve as
(A) input media
(B) output media
(C) secondary-storage media
(D) all the above


69. The advantages of COM are its_____and__.
(A) compact size; readability
(B) compact size; speed
(C) readability; speed
(D) compact size; low cost


70. Elementary data item are
(A) data item which is not broken down into smaller units
(B) data item that  can be broken down into smaller units
(C) data item which is not decomposed   into smaller units
(D) none of these
71. A semiconductor memory which allows the eraser of the information stared in it so that new information can be stared in it is referred as
(A) EPROM
(B) ROM
(C) RAM
(D) None  of these


72. Extended ASCII uses
(A) 8 bits for coding   
(B) 9 bits for coding
(C) 10 bits for coding 
(D) 11 bits for coding


73. A device used for transmission of images scanned at a transmitting point and duplicated at a receiving point is
(A) Facsimile
(FAX) (B) Telephone
(C) Photocopier
(D) None of these


74. A data transmission medium made of tiny threads of glass or plastic that can transmit huge amount of information at the speed of light is
(A) Fiber optic cable
(B) Copper cable
(C) Twisted wire cable
(D) None of these


75. A method of using a communication channel in which signals can be transmitted between a source and a destination in both directions simultaneously is called
(A) Full duplex
(B) Half duplex
(C) Quarter duplex
(D) None of these


76. A sequential electronic circuit which can be placed in one out of two stable states where each state may be used to represent a binary digit is stated as
 (A) Integrated circuit
(B) Firmware
(C) Flip-flop
(D) None of these


77. A sequence of instruction (software) that is substituted for hardware and stored in readonly memory (ROM) is called
(A) Integrated circuit
(B) Firmware (C) Flip-flop
(D) None of these


78. Anonymous FTP is the
(A) Internet file transfer protocol
(B) Protocol that requires password
(C) None access files
(D) None of these


79. EFF sites allows anonymous FTP that
(A) Do not require a password or access
(B) Requires password or access
(C) Is a none access file
(D) None of these


80. ANSI is
(A) American National Standards Institute
(B) A USA based national organization that establishes     uniform     standards     in several fields of computers.
(C) Both A & B are true
(D) None is true


81. APL is
(A) A high level language for specifying complex algorithms.
(B) A real-time language primarily for scientific applications.
(C) Only A is true
(D) Both A & B are true


82. The overall design, construction, organization and interconnecting of the various components of a computer system is referred as
(A) Computer Architecture
(B) Computer Flow chart
(C) Computer Algorithm
(D) None of these


83. Asynchronous communication is
(A) Communication between independently operating units
(B) Communication between dependent operating units
(C) Communication between independent and dependent operating units
(D) None of these


84. Audio response is.
 (A) output medium
 (B) produces verbal responses from the computer system
 (C) Both A & B true
 (D) None is true


 85. Automated Office refers to the merger of ___________ in an office environment.
 (A) Computers
 (B) office
 (C) telecommunications
 (D) All the above


 86. Auxiliary storage is.
 (A) Secondary storage
 (B) Primary storage
 (C) Processing device
 (D) None of these


 87. Archive is.
 (A) Backup storage
 (B) Forward operation
 (C) Primary storage
 (D) None of these


 88. A branch of computer science that deals with computers that possess reasoning, learning and thinking capabilities that resemble those of human beings is recognized as?
 (A) Software engineering
 (B) Artificial intelligence
 (C) Hardware engineering
 (D) None of these


 89. ASCII is.
 (A) A standard coding system for computers
 (B) Hardware device
 (C) Software
 (D) None of these


 90. Following is true for Bandwidth.
 (A) The wider the bandwidth of a communications system the more data it can transmit in a given period of time.
 (B) The narrow the bandwidth of a communications system the more data it can transmit in a given period of time
. (C) The wider the bandwidth of a communications system the less data it can transmit in a given period of time.
 (D) None is true


 91. ASCII-8 is.
 (A) An extended version of ASCIl-7
 (B) Is a 8-bit code
 (C) Both A & B are true
 (D) Both A & B are false


 92. ASCII File is.
 (A) document    file    in    the   universally recognized text format
 (B) Word processor
 (C) System file
 (D) None of these



93. A program that translates mnemonic statements into executable instructions is referred as.
 (A) Softwar
e (B) Assembler
 (C) Translator
 (D) None of these


 94. An assembler is a.
 (A) Translator
  (B) Hardware
 (C) Assembly language
 (D) None of these


 95. In a disk system time required for a read/ write head to move to the track where the record to be read or written is stored is.
 (A) Access time
 (B) Random time
 (C) Response time
 (D)Seek time


 96. Computer output which is displayed on the screen of a terminal without a permanent copy is called.
 (A) Soft copy
 (B) Hard copy
 (C) Hardware
 (D) None of these


 97. A storage device or medium where the access time is dependent upon the location of the data is called.
 (A) Serial access
 (B) Parallel access
 (C) Null access
 (D) None of these


 98. The set of computer programs, procedures, and associated documentation related to the effective operation of a computer system is referred as.
 (A) Software
 (B) Hardware
 (C) Hardcopy
 (D) Softcopy


 99. An adder in which the bits of the operands are added one after another is called.
 (A) Serial adder
 (B) Parallel adder
 (C) Full adder
 (D) Half adder


 100. A method of providing virtual memory.
 (A) Segmentation
 (B) De-fragmentation
 (C) Paging
 (D) None of these


 101. Transmission of data in one direction is called.
 (A) Simplex
 (B) Duplex
 (C) Triplex
 (D) None of  these


 102. SNOBOL is.
 (A) string oriented symbolic language
 (B) high-level language
 (C) both A & B
 (D) None of these


 103. Speech recognition is.
 (A) Ability to input data directly into a computer system by speaking to it
 (B) Ability to output data directly from a computer system by speaking
.(C) Processing of voice in computer systems
 (D) None of these


104. Speech synthesis is.
 (A) The ability to input data directly into a computer system by speaking to it
 (B) The ability to output data directly from a computer system in spoken words
 (C) Processing of  voice in computer systems
 (D) None of these.


 105. A technique used to reduce the speed mismatch between slow speed I/O devices and fast CPU is called.
 (A) Spooling
 (B) Paging
 (C) Segmentation
 (D) None of these


 106. Storing programs on disk and then transferring these programs into main storage as and when they are needed. The technique is used to process large programs or several programs with limited memory is called.
 (A) Swapping
 (B) Spooling
 (C) Paging
 (D) Segmentation


 107. Terminals is.
 (A) An input device which allows a user to communicate directly with a computer system.
 (B) An output device which allows a user to communicate directly with a computer system.
 (C) Both A & B
 (D) None of these


 108. A symbol to indicate beginning (START), ending (STOP) and pauses (HALT) in program logic flow are referred as.
 (A) Terminal symbol
 (B) Decision symbol
 (C) Processing symbol
 (D) None of these


 109. Portability is program ability to run on.
 (A) dissimilar machines with minimum modification
 (B) similar   machines   with   maximum modification
 (C) dissimilar   machines   with   maximum modification
 (D) similar   machines   with   maximum modification


 110. A protocol that specifies how a personal computer can connect to a mail server on the Internet and download E-mail is known as.
 (A) Post office protocol
 (B) System protocol
 (C) Network protocol
 (D) None of these



111. A unit of a computer system that interprets instructions and executes them is known as.
 (A) Processor
 (B) Storage
 (C) Peripherals
 (D) None of these


 112. A register in CPU  used to store the address of the next instruction to be executed is known as   (A) Program counter
 (B) Program library
 (C) Programmer
 (D) None of these


 113. One who designs, writes, tests and maintenance computer programs is called.
 (A) Programmer
 (B) Operator
 (C) User
 (D) None of these


 114. Which of the following terms applies to communication between two computer systems?
 (A) computer literacy
 (B) power supply
 (C) applications software
 (D) connectivity


 115. A memory in CPU that holds program instructions, input data, intermediate results and the output information produced during processing is.
 (A) Secondary memory
 (B) Primary memory
 (C) Auxiliary memory
 (D) None of these


 116. A collection of complete programs, subroutines, and program modules that have already been developed, tested and documented to be used by programming projects.
 (A) Program counter
 (B) Program library
 (C) Programmer
 (D) None of these


 117. The following typically happens in the output phase of a computer based information system   (A) Data   is   put   into   the   computer  for processing
 (B) Information is produced in hardcopy / softcopy form
 (C) Mathematical calculations are performed
 (D) All of the above.


 118. Which of the following best describes a computer-based information system?
 (A) system where computer is used to turn data into information
 (B) inputting data
 (C) processing data
(D) data   is   put   into   the   computer   for processing



119. The following piece of hardware is used as input phase of a computer-based information system   (A) Printer
 (B) Diskette
 (C) Monitor
 (D) Keyboard


 120. Software instructions intended to satisfy a user specific processing needs are called.
 (A) systems software
 (B) microcomputer
 (C) documentation
 (D) applications software


 121. A term used for diskette is.
 (A) disk cartridge
 (B) disk pack
 (C) floppy disk
 (D) none of these


 122. Following is true for the digital computer.
 (A) Information is in form of a string of binary digits
 (B) It can be used as analog processor
 (C) It is less accurate than the analog computer
 (D) None of these.


 123. Comparing with secondary storage, primary storage is.
 (A) slow and inexpensive
 (B) fast and inexpensive
 (C) fast and expensive
 (D) slow and expensive


 124. CPU performs read/write operations at any point in time in.
 (A) ROM
 (B) PROM
 (C) EPROM
 (D) RAM


 125. Following is not the from of secondary storage.
 (A) Magnetic tape
 (B) CD’s
 (C) Disk
 (D) Hard disk


 126. Technique of placing software/programs in a ROM semiconductor chip is called.
 (A) PROM
 (B) EPROM
 (C) firm ware
 (D) microprocessor


 127. Following is not true for magnetic tape.
 (A) low cost
 (B) direct-access storage medium
 (C) compact and portable
 (D) highly reliable


 128. The following is an  nonvolatile memory.
 (A) ROM
 (B) RAM
 (C) LSI
 (D) VLSI


 129. The ________ can be programmed one time by either the manufacturer or the computer user. Once programmed, it cannot be modified.
 (A) RAM
 (B) ROM
 (C) PROM
 (D) EPROM


130. Which of the following is not true of a magnetic disk?
 (A) Users can  update records by writing over the old data
 (B) It provides sequential access to stored data
 (C) It is slow relative to magnetic tape
 (D) All of the above are true


 131. Which of the following was (were) not used in first-generation computers?
 (A) vacuum tubes
 (B) punch cards
 (C) magnetic core
 (D) all of the above


 132. Following is not true for Backup files .
 (A) These are the files which are generated automatically  in  when  one  saves  a document.
 (B) These files help in protecting the document due to out of order of the computer or power failure.   (C) These files delete as soon as computer is turned off
 (D) None of these


 133. An algebra that deals with logical propositions which are either true or false is referred as.
 (A) Boolean algebra
 (B) Modern Algebra
 (C) Abstract Algebra
 (D) None of these


 134. Bandwidth is.
 (A) The range of frequencies available for data transmission
 (B) Data transmission rate
 (C) Alternate for rubber band
 (D) None is true


 135. A coding structure in which characters are represented by means of a series of parallel bars is     (A) Bar Code
 (B) Menu bar
 (C) Numeric bar
 (D) None of these


 136. In Broadband system a network system.
 (A) Several analog signals share the same physical network channel.
 (B) Only digital signals share the same physical network channel.
 (C) Single analog signals share the same physical network channel.
 (D) None of these.


 137. Bit stands for.
 (A) binary digit
 (B) one binary piece of information
 (C) Both A and B are true
 (D) None is true


138. Broadband channel is the.
 (A) The fastest carriers where data transfer rates is of 1 million baud (bits/secon(D) or more.
 (B) The slower  carriers where  data transfer rates is of 56k baud
 (C) Musical channel
 (D) None of these


 139. BLOB is.
 (A) Binary Large Object
 (B) A long bit string representing complex data
 (C) Object oriented language
 (D) Only A & B are true


 140. A group of related items / section of program coding treated as a unit is referred as.
 (A) Block
 (B) Duplex
 (C) Street
 (D) None of these


 141. An operation in which data is moved to a different location is referred as.
 (A) Block move
 (B) Street move
 (C) Delete
 (D) None of these


 142. The following is responsible for number of logical records in a physical record.
 (A) Blocking factor
 (B) Block
 (C) Boolean algebra
 (D) None of these


 143. Boolean variable assumes.
 (A) Values that are true only
 (B) Values that are false only
 (C) Values that are either true or false
 (D) None of these


 144. Bubble Memory is.
 (A) nonvolatile
 (B) volatile
 (C) permanent
 (D) None of these


 145. In Nonvolatile memory device.
 (A) Data contained in them is not lost when the power turned off
 (B) Data contained in them is lost when the power turned off.
 (C) data contained in them is permanent and not be rewrite
 (D) None of these


 146. Following is true for Bubble Memory
 (A) A compact data storage device made of thin wafers of garnet (a semiconductor material) in a magnetic field.
 (B) Nonvolatile memory
 (C) Data contained in them is not lost when the power turned off
 (D) All are true



147. Buffer is device/ storage area.
 (A) Where data are temporarily stored
 (B) Where data is permanently stored
 (C) Where data error occurs
 (D) None of these


 148. A network geometric arrangement in which a single connecting line is shared by a number of nodes is called.
 (A) Car Topology
 (B) Bus Topology
 (C) Truck Topology
 (D) None of these


 149. An error in a computer program is referred as.
 (A) Bug
 (B) Bit
 (C) Virus
 (D) None of these


 150. Circuits that provide a communication path between two or more devices of a digital computer system is.
 (A) Car
 (B) Bus
 (C) Truck
 (D) None of these


 151. A fixed number of adjacent bits that represent a particular character or symbol are referred as (A) Byte
 (B) Octal
 (C) Bubble
 (D) None of these


 152. Cache memory is a.
 (A) Small buffer storage
 (B) Permanent storage
 (C) Main memory
 (D) None of these


 153. The total number of digits (symbols) available to represent numbers in a positional number system is referred as.
 (A) Number system
 (B) Base
 (C) Power
 (D) None of these


 154. Cache memory is.
 (A) Smaller and faster than main storage
 (B) Bigger and slower then main storage
 (C) Smaller but slower than main memory
 (C) Works in timesharing environment
 (D) Low level object oriented language 


 155. Cache memory.
 (A) Is a  Static RAM
 (B) Increases the speed of processing by making current programs and data available to the CPU at a rapid rate
 (C) Both A & B are true
 (D) Both A & B are false


 156. Following is false for BASIC.
 (A) Beginners All-Purpose Symbolic Instruction Code
 (B) High-level interactive programming language
 (C) Works in timesharing environment
 (D) Low level object oriented language


 157. A unit for measuring data transmission speed that describes the capacity of a carrier is referred as.
 (A) Baud
 (B) Bit
 (C) Bond
 (D) Batch


 158. A process of trying out a new product by independent users before it is finally manufactured/ developed.
 (A) Alpha test
 (B) Beta Test
 (C) Gamma test
 (D) None of these


 159. A selection, choice, or condition involving two possibilities is referred as.
 (A) Unary
 (B) Binary
 (C) Octal
 (D) None of these


 160. Base band System is.
 (A) A networking system
 (B) Where the channel support. a single digital signal.
 (C) Both A & B are true
 (D) None is true


 161. One of the early coding systems,  based on the idea of converting each digit of a decimal number into its binary equivalent rather than converting the entire decimal value into a pure binary form is.
 (A) ASCII code
 (B) BCD
 (C) ASCIl-8
 (D) None of these


 162. In Batch processing.
 (A) Several computer programs runs one after another without human interaction to run each program individually.
 (B) Several computer programs runs one after another with human interaction to run each program individually
 (C) Selected  computer programs runs one after another with human interaction to run each program individually
 (D) None is true


 163. BISYNC is.
 (A) Binary synchronous
 (B) A process of transmitting data
 (C) A half-duplex, character-oriented, synchronous data communications transmission method
 (D) All the above


 164. A device that is used to transmit data from one location to another is referred as.
 (A) Storage
 (B) Memory
 (C) Carrier
 (D) None of these




165. Programs developed by an outside supplier and provided to the user in a machine readable form is known as.
 (A) Canned Programs
 (B) Beta program
 (C) Alpha program
 (D) None of these


 166. A binary numbers are represented by.
 (A) Digits 0 and 1
 (B) Digits 0,1,….,8
 (C) Digits A,B, C,…
 (D) None of these


 167. BIOS is responsible for.
 (A) handling the particulars of input/output operations
 (B) output operations
 (C) input operations
 (D) None of these


 168. BIOS is an abbreviation for.
 (A) Binary Input/Binary Output
 (B) Binary synchronous
 (C) Binary digit
 (D) None of these


 169. BISYNC is an abbreviation for.
 (A) Binary Input/Binary Output
 (B) Binary synchronous
 (C) Binary digit
 (D) None of these


 170. The overall design, construction, organization and interconnecting of the various components of a computer system is referred as.
 (A) Computer Architecture
 (B) Computer Flow chart
 (C) Computer Algorithm
 (D) None of these

 171. A number system with a base of two is referred as.
 (A) Unary number system
 (B) Binary number system
 (C) Octal number system
 (D) None of these


 172. In the IBM PC’s, the CPU, the device drives, memory, expansion slots and active components are mounted on a single board referred as.
 (A) Motherboard
  (B) Breadboard
 (C) Daughter board
 (D) Father board.


 173. Instead of buying new computer, productivity of old one can be economically enhanced with the help of?
 (A) Motherboard
 (B) Breadboard
 (C) Daughter board
 (D) Grandmother board.




174. Following communications lines, best suites to interactive processing applications.
 (A) narrowband channels
 (B) simplex lines
 (C) full-duplex lines
 (D) mixed-band channels


 175. Advantage of a multiprogramming system is.
 (A) simultaneous execution of program instructions from two applications
 (B) concurrent processing of two or more programs
 (C) single processing at a time
 (D) none of these


 176. A remote batch-processing operation where data is solely input to a central computer would require.
 (A) telegraph line
 (B) simplex lines
 (C) mixed-band channel
 (D) none of these
Answer Sheet
1. (C) 2. (A) 3. (A) 4. (B) 5. (B) 6. (A) 7. (D) 8. (A) 9. (D) 10. (A) 11. (A) 12. (B) 13. (A) 14. (A) 15. (A) 16. (B) 17. (C) 18. (C) 19. (A) 20. (A) 21. (A) 22. (A) 23. (A) 24. (A) 25. (A) 26. (C) 27. (A) 28. (B) 29. (C) 30. (B)

31. (C) 32. (A) 33. (A) 34. (C) 35. (A) 36. (C) 37. (A) 38. (A) 39. (A) 40. (B) 41. (A) 42. (A) 43. (D) 44. (A) 45. (A) 46. (D) 47. (D) 48. (C) 49. (B) 50. (A) 51. (B) 52. (C) 53. (D) 54. (D) 55. (C) 56. (A) 57. (D) 58. (B) 59. (B) 60. (C) 61. (B) 62. (A) 63. (B) 64. (C) 65. (C) 66. (D) 67. (B) 68. (D) 69. (B) 70. (A) 71. (A) 72. (A) 73. (A) 74. (A) 75. (A) 76. (C) 77. (B) 78. (A) 79. (A) 80. (C) 81. (D) 82. (A) 83. (A) 84. (C) 85. (D) 86. (A) 87. (A) 88. (B) 89. (A) 90. (A) 91. (A) 92. (A) 93. (B) 94. (A) 95. (D) 96. (A) 97. (A) 98. (A) 99. (A) 100. (A) 101. (A) 102. (C) 103. (A) 104. (B) 105. (A) 106. (A) 107. (C) 108. (A) 109. (A) 110. (A) 111. (A) 112. (A) 113. (A) 114. (D) 115. (B) 116. (B) 117. (B) 118. (A) 119. (D) 120. (D) 121. (C) 122. (A) 123. (C) 124. (C) 125. (D) 126. (C) 127. (B) 128. (A) 129. (C) 130. (B) 131. (C) 132. (C) 133. (A) 134. (A) 135. (A) 136. (A) 137. (C) 138. (A) 139. (D) 140. (A) 141. (A) 142. (A) 143. (C) 144. (A) 145. (A) 146. (D) 147. (A) 148. (B) 149. (A) 150. (B) 151. (A) 152. (A) 153. (B) 154. (A) 155. (C) 156. (D) 157. (A) 158. (B) 159. (B) 160. (C) 161. (B) 162. (A) 163. (D) 164. (A) 165. (A) 166. (A) 167. (A) 168. (A) 169. (A) 170. (A) 171. (B) 172. (A) 173. (C) 174. (C) 175. (B) 176. (B)





1. A vulnerability scanner is.
 (A) a   prepared   application   that  takes advantage of a known weakness.
 (B) a tool used to quickly check computers on a network for known weaknesses.

 (C) an application that captures TCP/IP data packets, which can maliciously be used to capture passwords and other data while it is in transit either within the computer or over the network.
 (D) a  situation  in  which  one  person  or program successfully masquerades as another by falsifying data and thereby gaining illegitimate access


. 2. A packet sniffer is.
 (A) a   prepared   application   that   takes advantage of a known weakness.
 (B) a tool used to quickly check computers on a network for known weaknesses.
 (C) an application that captures TCP/IP data packets, which can maliciously be used to capture passwords and other data while it is in transit either within the computer or over the network.
 (D) a   situation   in   which   one   person  or program successfully masquerades as another by falsifying data and thereby gaining illegitimate access.


 3. These hacker breaks security for altruistic or at least non-malicious reasons.
 (A) White hat
 (B) Grey hat
 (C) Blue hat
 (D) None of these


 4. This hacker is a hacker of ambiguous ethics and/or borderline legality, often frankly admitted.
 (A) White hat
 (B) Grey hat
 (C) Blue hat
 (D) None of these


 5. This hacker is someone outside computer security consulting firms that are used to bug test a system prior to its launch, looking for exploits so they can be closed.
 (A) White hat
 (B) Grey hat
 (C) Blue hat
 (D) None of these


6. It is a software program designed to record (‘log’) every keystroke on the machine on which it runs (A) Keylogger
 (B) Worm
 (C) Virus
 (D) Cracker


 7. It is a self-replicating program that infects computer and  spreads by inserting copies of   itself   into   other   executable   code  or documents.
 (A) Keylogger
 (B) Worm
 (C) Virus
 (D) Cracker


 8. Like  a  virus,  it  is  also  a  self-replicating program. The difference between a virus and it  is that a worm does not create copies of itself on one system: it propagates through computer networks.
 (A) Keylogger
 (B) Worm
 (C) Cracker
 (D) None of these


9. Viruses that fool a user into downloading and/or executing them by pretending to be useful applications are also sometimes called?
 (A) Trojan horses
 (B) Keylogger
 (C) Worm
 (D) Cracker



10. These are program designed as to seem to being or be doing one thing, but actually being or doing another.
 (A) Trojan horses
 (B) Keylogger
 (C) Worm
 (D) Cracker


 11. It is a toolkit for hiding the fact that a computer’s security has been compromised, is a general description of a set of programs which work to subvert control of an operating system from its legitimate (in accordance with established rules) operators.
 (A) Rootkit
 (B) Keylogger
 (C) Worm
(D) Cracker


12. Packet Sniffer is.
 (A) an application that captures TCP/IP data packets, which can maliciously be used to capture passwords and other data while it is in transit either within the computer or over the network.

 (B) a situation in which one person or program successfully masquerades as another by falsifying data and thereby gaining illegitimate access.

(C) a toolkit for hiding the fact that a computer’s security has been compromised, is a general description of a set of programs which work to subvert control of an operating system from its legitimate (in accordance with established rules) operators.
(D) None of these


 13. Rootkit is.
 (A) an application that captures TCP/IP data packets, which can maliciously be used to capture passwords and other data while it is in transit either within the computer or over the network.
 (B) a situation in which one person or program successfully masquerades as another by falsifying data and thereby gaining illegitimate access.
 (C) a toolkit for hiding the fact that a computer’s security has been compromised, is a general description of a set of programs which work to subvert control of an operating system from its legitimate (in accordance with established rules) operators.
 (D) None of these


 14. Spoofing attack is.
 (A) an application that captures TCP/IP data packets, which can maliciously be used to capture passwords and other data while it is in transit either within the computer or over the network.
 (B) a situation in which one person or program successfully masquerades as another by falsifying data and thereby gaining illegitimate access.
 (C) a toolkit for hiding the fact that a computer’s security has been compromised, is a general description of a set of programs which work to subvert control of an operating system from its legitimate (in accordance with established rules) operators.
 (D) None of these

15. Security exploit  is.
 (A) a prepared application that takes advantage of a known weakness.
 (B) a tool used to quickly check computers on a network for known weaknesses.
 (C) an application that captures TCP/IP data packets, which can maliciously be used to capture passwords and other data while it is in transit either within the computer or over the network.
 (D) a situation in which one person or program successfully masquerades as another by falsifying data and thereby gaining illegitimate access.


 16. A spoofing attack is.
 (A) a prepared application that takes advantage of a known weakness.
 (B) a tool used to quickly check computers on a network for known weaknesses.
 (C) an application that captures TCP/IP data packets, which can maliciously be used to capture passwords and other data while it is in transit either within the computer or over the network.
 (D) a situation in which one person or program successfully masquerades as another by falsifying data and thereby gaining illegitimate access.


 17. White hat is.
 (A) hacker breaks security for altruistic or at least non-malicious reasons.
 (B) hacker of ambiguous ethics and/or borderline legality, often frankly admitted.
 (C) someone outside computer security consulting firms that are used to bug test a system prior to its launch, looking for exploits so they can be closed.
 (D) None of these


 18. Grey hat is.
 (A) hacker breaks security for altruistic or at least non-malicious reasons.
 (B) hacker of ambiguous ethics and/or borderline legality, often frankly admitted.
 (C) someone outside computer security consulting firms that are used to bug test a system prior to its launch, looking for exploits so they can be closed.
 (D) None of these


19. Blue hat is.
 (A) hacker breaks security for altruistic or at least non-malicious reasons.
 (B) hacker of ambiguous ethics and/or borderline legality, often frankly admitted.
 (C) someone outside computer security consulting firms that are used to bug test a system prior to its launch, looking for exploits so they can be closed.
 (D) None of these


 20. Black hat is.
 (A) someone who subverts computer security without authorization or who uses technology (usually a computer or the Internet) for terrorism, vandalism (malicious destruction), credit card fraud, identity theft, intellectual property theft, or many other types of crime.
 (B) a person, usually not an expert in computer security, who breaks into computer systems by using prepackaged automated tools written by others.
 (C) hacker who utilizes technology to announce a political message.
 (D) None of these


 21. Script kiddie is.
 (A) someone who subverts computer security without authorization or who uses technology (usually a computer or the Internet) for terrorism, vandalism (malicious destruction), credit card fraud, identity theft, intellectual property theft, or many other types of crime.
 (B) a person, usually not an expert in computer security, who breaks into computer systems by using prepackaged automated tools written by others.
 (C) hacker who utilizes technology to announce a political message.
 (D) None of these


 22.  Hacktivism is.
 (A) someone who subverts computer security without authorization or who uses technology (usually a computer or the Internet) for terrorism, vandalism (malicious destruction), credit card fraud, identity theft, intellectual property theft, or many other types of crime.
(B) a person, usually not an expert in computer security, who breaks into computer systems by using prepackaged automated tools written by others.
 (C) hacker who utilizes technology to announce a political message.
 (D) None of these


23. It is a prepared application that takes advantage of a known weakness.
 (A) security exploit
 (B) vulnerability scanner
 (C) packet sniffer
 (D) rootkit


24. It is a tool used to quickly check computers on a network for known weaknesses.
 (A) security exploit
 (B) vulnerability scanner
 (C) packet sniffer
 (D) rootkit


 25. It is an application that captures TCP/IP data packets, which can maliciously be used to capture passwords and other data while it is in transit either within the computer or over the network.
 (A) security exploit
 (B) vulnerability scanner
 (C) packet sniffer
 (D) rootkit


 26. It is a situation in which one person or program successfully masquerades as another by falsifying data and thereby gaining illegitimate access.
 (A) security exploit
 (B) vulnerability scanner
 (C) packet sniffer
 (D) rootkit



Answer Sheet

1. (B) 2. (C) 3. (A) 4. (B) 5. (C) 6. (A) 7. (C) 8. (B) 9. (A) 10. (A) 11. (A) 12. (A) 13. (B) 14. (C) 15. (A) 16. (D) 17. (A) 18. (B) 19. (C) 20. (A) 21. (B) 22. (C) 23. (A) 24. (B) 25. (C) 26. (A)


1. In Windows operating system the ———— ——— is the main screen area that one sees after he turn on a computer and log on to Windows.
 (A) Desktop
 (B) Icons
 (C) Taskbar
 (D) None of these


 2. In Windows operating system it sits at the bottom of windows desktop screen. It shows you which programs are running and allows you to switch between them. It also contains the Start button which one can use to access programs, folders, and computer settings.
 (A) Sidebar
 (B) Icons
 (C) Taskbar
 (D) None of these


 3. In Windows operating system these are small pictures that represent files, folders, programs, and other items. Each one is used to make the computer do something.
 (A) Sidebar
 (B) Icons
 (C) Taskbar
 (D) None of these


 4. In Windows operating system it is the long horizontal bar at the bottom of a screen. Unlike the desktop, which can get obscured by the windows on top of it, it is visible almost all the time.
 (A) Sidebar
 (B) Icons
 (C) Taskbar
 (D) None of these


 5. In Windows operating system it is  a very important part of Windows, clicking on it opens up what is called the start menu.
 (A) Start button
 (B) Sidebar
 (C) Icons
 (D) None of these


 6. In Windows operating system when you delete a file or folder, it doesn’t actually get deleted right away, it goes to the ————.
 (A) Recycle Bin
 (B) Dust Bin
 (C) Cycle Bin
 (D) None of these


 7. In Windows operating system the clock in windows xp sits on the ————— and displays the system time.
 (A) Taskbar
 (B) Start menu
 (C) Desktop
 (D) None of these


8. Word Processors that is the part of Windows operating system.
 (A) Wordpad
 (B) Notepad
 (C) Adobe Photoshop
 (D) Jasc Paint Shop


9. Microsoft   Windows   provides   a  graphics application named.
(A) Paint
(B) Adobe Photoshop
(C) Jasc Paint Shop
(D) None of these



10. Text  Editor  that  is  the  part  of  Windows operating system.
 (A) Wordpad
 (B) Notepad
 (C) Adobe Photoshop
 (D) Jasc Paint Shop


 11. It is  a visual aspect that indicates that a control is ready to receive input from you in Windows operating system.
 (A) Control’s Focus
 (B) Dialog Boxes
 (C) Command Buttons
 (D) Text Boxes


 12. In Windows operating system it is a window that is used to display text or to receive text from you. The type of text it displays or the type of text you are asked to provide depends on the application or the situation.
(A) Control’s Focus
(B) Dialog Boxes
(C) Command Buttons
(D) Text Boxes


Answer Sheet

1. (A) 2. (C) 3. (B) 4. (C) 5. (A) 6. (A) 7. (A) 8. (A) 9. (A) 10. (B) 11. (A) 12. (D)


1. In Windows operating system to display or hide the Start menu.
 (A) Windows Logo
 (B) Windows Logo + BREAK
 (C) Windows Logo + D
 (D) Windows Logo + M


 2. In Windows operating system the shortcut key Windows Logo+SHIFT+M is used for.
 (A) Restore the minimized windows
 (B) Open My Computer
 (C) Search for a file or a folder
 (D) Search for computers


 3. In Windows operating system the shortcut key Windows Logo+E is used for.
 (A) Restore the minimized windows
 (B) Open My Computer
 (C) Search for a file or a folder
 (D) Search for computers


 4. In Windows operating system the shortcut key Windows Logo+F.
 (A) Restore the minimized windows
 (B) Open My Computer
 (C) Search for a file or a folder
 (D) Search for computers


 5. In Windows operating system shortcut key CTRL+Windows Logo+F.
 (A) Restore the minimized windows
 (B) Open My Computer
 (C) Search for a file or a folder
 (D) Search for computers


 6. In Windows operating system  shortcut key Windows Logo+F1.
(A) Display Windows Help
(B) Lock the keyboard
(C) Open the Run dialog box
(D) Open Utility Manager


 7. In Windows operating system shortcut key Windows Logo+ L.
 (A) Display Windows Help
 (B) Lock the keyboard
 (C) Open the Run dialog box
 (D) Open Utility Manager



8. In Windows operating system shortcut key Windows Logo+R.
 (A) Display Windows Help
 (B) Lock the keyboard
 (C) Open the Run dialog box
 (D) Open Utility Manager


 9. In Windows operating system to Display the System Properties dialog box.
 (A) Windows Logo
 (B) Windows Logo + BREAK
 (C) Windows Logo + D
 (D) Windows Logo + M


 10. In Windows operating system to Display the desktop.
 (A) Windows Logo
 (B) Windows Logo + BREAK
 (C) Windows Logo + D
 (D) Windows Logo + M


 11. In Windows operating system to minimize all of the windows.
 (A) Windows Logo
 (B) Windows Logo + BREAK
 (C) Windows Logo + D
 (D) Windows Logo + M


 12. In Windows operating system to move forward through the tabs.
 (A) CTRL+TAB
 (B) CTRL+SHIFT+TAB
 (C) SHIFT+TAB
 (D) None of these


 13. In Windows operating system to move backward through the tabs.
 (A) CTRL+TAB
 (B)  CTRL+SHIFT+TAB
 (C) SHIFT+TAB
 (D) None of these


 14. In Windows operating system to move backward through the options.
 (A) CTRL+TAB
 (B) CTRL+SHIFT+TAB
 (C) SHIFT+TAB
 (D) None of these


 15. In Windows operating system one press F1 key to.
 (A) Display help
 (B) Cut
 (C) Paste
 (D) None of these




16. In Windows operating system after you double-click a character on the grid of characters, keyboard shortcut DOWN ARROW is used for.
 (A) Move to the right or to the beginning of the next line
 (B) Move to the left or to the end of the previous line
 (C) Move up one row
 (D) Move down one row


 17. In Windows operating system after you double-click a character on the grid of characters, keyboard shortcut PAGE UP  is used for.
 (A) Move up one screen at a time
 (B) Move down one screen at a time
 (C) Move to the beginning of the line
 (D) Move to the end of the line


 18. In Windows operating system after you double-click a character on the grid of characters, keyboard shortcut PAGE DOWN is used for.
 (A) Move up one screen at a time
 (B) Move down one screen at a time
 (C) Move to the beginning of the line
 (D) Move to the end of the line


 19. In Windows operating system after you double-click a character on the grid of characters, keyboard shortcut HOME is used for.
 (A) Move up one screen at a time
 (B) Move down one screen at a time
 (C) Move to the beginning of the line
 (D) Move to the end of the line


 20. In Windows operating system after you double-click a character on the grid of characters, keyboard shortcut END is used for.
 (A) Move up one screen at a time
 (B) Move down one screen at a time
 (C) Move to the beginning of the line
 (D) Move to the end of the line


 21. In Windows operating system after you double-click a character on the grid of characters, keyboard shortcut CTRL+HOME is used for.
 (A) Move to the first character
 (B) Move to the last character
 (C) Switch between Enlarged and Normal mode when a character is selected
 (D) None of these



22. In  Windows  operating  system  after  you double-click a character on the grid of characters, keyboard shortcut CTRL+END is used for.
 (A) Move to the first character
 (B) Move to the last character
 (C) Switch between Enlarged and Normal mode when a character is selected
 (D) None of these


 23. In  Windows  operating  system  after  you double-click a character on the grid of characters, keyboard shortcut SPACEBAR is used for
 (A) Move to the first character
 (B) Move to the last character
 (C) Switch between Enlarged and Normal mode when a character is selected*
 (D) None of these


 24. In Windows operating system to copy something the following shortcut  is used.
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 25. In Windows operating system to cut something the following shortcut is used.
(A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 26. In Windows operating system Shortcut CTRL+Z  is for.
 (A) Undo something
 (B) Delete something
 (C) Paste something
 (D) None of these


 27. In Windows operating system shortcut DELETE is for.
 (A) Undo something
 (B) Delete something
 (C) Paste something
 (D) None of these


 28. In   Windows   operating   system   shortcut SHIFT+DELETE is used for.
 (A) Delete the selected item permanently without placing the item in the Recycle Bin
 (B) Copy the selected item
 (C) Rename the selected item
 (D) Create a shortcut to the selected item


 29. In Windows operating system shortcut CTRL while dragging an item.
 (A) Delete the selected item permanently without placing the item in the Recycle Bin
 (B) Copy the selected item
 (C) Rename the selected item
 (D) Create a shortcut to the selected item



30. In   Windows   operating   system   shortcut CTRL+SHIFT while dragging an item.
 (A) Delete the selected item permanently without placing the item in the Recycle Bin
 (B) Copy the selected item
 (C) Rename the selected item
 (D) Create a shortcut to the selected item


 31. In Windows operating system to delete the selected item permanently without placing the item in the Recycle Bin.
 (A) Shortcut SHIFT+DELETE
 (B) Shortcut CTRL while dragging an item
 (C) Shortcut CTRL+SHIFT while dragging an item
 (D) None of these


 32. In Windows operating system move the insertion point to the beginning of the next word.
 (A) Shortcut CTRL+RIGHT ARROW
 (B) Shortcut CTRL+LEFT ARROW
 (C) Shortcut CTRL+DOWN ARROW
 (D) None of these


 33. In Windows operating system move the insertion point to the beginning of the previous word.
 (A) Shortcut CTRL+RIGHT ARROW
 (B) Shortcut CTRL+LEFT ARROW
 (C) Shortcut CTRL+DOWN ARROW
 (D) None of these


 34. In Windows operating system move the insertion point to the beginning of the next paragraph (A) Shortcut CTRL+RIGHT ARROW
 (B) Shortcut CTRL+LEFT ARROW
 (C) Shortcut CTRL+DOWN ARROW
 (D) None of these


 35. In Windows operating system move the insertion point to the beginning of the previous paragraph.
(A) CTRL+RIGHT ARROW
(B) CTRL+LEFT ARROW
(C) CTRL+DOWN ARROW
(D) None of these


 36. In Windows operating system move the insertion point to the beginning of the previous paragraph.
 (A) CTRL+RIGHT ARROW
 (B) CTRL+LEFT ARROW
 (C) CTRL+DOWN ARROW
 (D) CTRL+UP ARROW



37. In Windows operating system CTRL+SHIFT with any of the arrow keys.
 (A) Highlight a block of text
 (B) Delete something
 (C) Paste something
 (D) None of these


 38. In Windows operating system SHIFT with any of the arrow keys.
 (A) Highlight a block of text
 (B) Delete something
 (C) Paste something
 (D) Select more than one item in a window or on the desktop, or select text in a document


 39. In Windows  operating  system  shortcut CTRL+A is to.
 (A) Select all
 (B) Highlight a block of text
 (C) Delete something
 (D) Paste something


 40. In Windows operating system shortcut for paste is.
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 41. In Windows operating system Shortcut for copy is.
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 42. In Windows operating system to paste something after cutting the following shortcut is used.
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 43. In   Windows   operating   system  shortcut CTRL+C  is used for.
 (A) Cut
 (B) Paste
 (C) Copy
 (D) None of these


 44. In Windows operating system the shortcut key CTRL+B is used for.
 (A) Open the Organize Favorites dialog box
 (B) Open the Search bar
 (C) Start the Find utility
 (D) Open the History bar


 45. In Windows operating system the shortcut key CTRL+E is used for.
 (A) Open the Organize Favorites dialog box
 (B) Open the Search bar
 (C) Start the Find utility
 (D) Open the History bar



46. In Windows operating system the shortcut key CTRL+F is used for.
 (A) Open the Organize Favorites dialog box
 (B) Open the Search bar
 (C) Start the Find utility
 (D) Open the History bar


 47. In Windows operating system the shortcut key CTRL+H is used for.
 (A) Open the Organize Favorites dialog box
 (B) Open the Search bar
 (C) Start the Find utility
 (D) Open the History bar


 48. In Windows operating system the shortcut key CTRL+I is used for.
 (A) Open the Favorites bar
 (B) Open the Open dialog box
 (C) Start another instance of the browser with the same Web address
 (D) Open the Open dialog box, the same as CTRL+L


 49. In Windows operating system the shortcut key CTRL+L is used for.
 (A) Open the Favorites bar
 (B) Open the Open dialog box
 (C) Start another instance of the browser with the same Web address
 (D) Open the Open dialog box, the same as CTRL+L


 50. In Windows operating system the shortcut key CTRL+N is used for.
 (A) Open the Favorites bar
 (B) Open the Open dialog box
 (C) Start another instance of the browser with the same Web address
 (D) Open the Open dialog box, the same as CTRL+L



51. In Windows operating system the shortcut key CTRL+O is used for.
 (A) Open the Favorites bar
 (B) Open the Open dialog box
 (C) Start another instance of the browser with the same Web address
 (D) Open the Open dialog box, the same as CTRL+L


 52. In Windows operating system the shortcut key CTRL+P is used for.
 (A) Open the Print dialog box
 (B) Update the current Web page
 (C) Close the current window
 (D) None of these


 53. In Windows operating system the shortcut key CTRL+R is used for.
 (A) Open the Print dialog box
 (B) Update the current Web page
 (C) Close the current window
 (D) None of these


 54. In Windows operating system the shortcut key CTRL+W is used for.
 (A) Open the Print dialog box
 (B) Update the current Web page
 (C) Close the current window
 (D) None of these

Answer Sheet

1. (A) 2. (A) 3. (B) 4. (C) 5. (D) 6. (A) 7. (B) 8. (C) 9. (B) 10. (C) 11. (D) 12. (A) 13. (B) 14. (C) 15. (A) 16. (D) 17. (A) 18. (B) 19. (C) 20. (D) 21. (A) 22. (B) 23. (C) 24. (A) 25. (B) 26. (A) 27. (B) 28. (A) 29. (B) 30. (D) 31. (A) 32. (A) 33. (B) 34. (A) 35. (D) 36. (D) 37. (A) 38. (D) 39. (A) 40. (C) 41. (C) 42. (C) 43. (A) 44. (A) 45. (B) 46. (C) 47. (D) 48. (A) 49. (B) 50. (C) 51. (D) 52. (A) 53. (B) 54. (C)



1. Microsoft Office is.
 (A) Desktop applications
 (B) Operating system
 (C) Command window
 (D) None of these


 2. Microsoft Office is  an office suite, for the.
 (A) Microsoft Windows operating systems
 (B) Mac OS X operating systems
 (C) Both A and B are true
 (D) None is true


 3. Microsoft Word, Microsoft Excel, and Microsoft PowerPoint are the part of.
 (A) Microsoft  Office  Suite
 (B) Microsoft Windows
 (C) Mac OS X
 (D) None of these


 4. The very first version of Microsoft Office was released for.
 (A) Windows operating system
 (B) Apple Macintosh OS
 (C) Unix
 (D) None of these


 5. The first version of  MS Office to be released for the Microsoft Windows operating system is.
 (A) Microsoft Office 3.0
 (B) Microsoft Office 2003
 (C) Microsoft Office 2007
 (D) Microsoft Office XP


 6. The word processor in MS office suite is.
 (A) Microsoft Word
 (B) Microsoft Excel
 (C) Microsoft PowerPoint
 (D) None of these


 7. Microsoft Word is a word processor  that saves in its proprietary————format.
 (A) .doc
 (B) .pdf
 (C) .txt
 (D) None of these

8. Microsoft Office Suite  spreadsheet program is.
 (A) Microsoft Excel
 (B) Microsoft  Word
 (C) Microsoft  Powerpoint
 (D) None of these


 9. A competitor to the dominant Lotus 1-2-3 is.
 (A) Microsoft Excel
 (B) Microsoft  Word
 (C) Microsoft  PowerPoint
 (D) None of these


 10. A personal information manager and e-mail communication software in MS Office is.
 (A) Microsoft Outlook
 (B) Microsoft  Word
 (C) Microsoft  PowerPoint
 (D) None of these


 11. A popular presentation program for Windows and Mac in Microsoft  Office is.
 (A) Microsoft  Word
 (B) Microsoft  PowerPoint
 (C) Microsoft Access
 (D) None of these


 12. To create slideshows, composed of text, graphics, movies and other objects, which can be displayed on-screen and navigated through by the presenter or printed out on transparencies or slides one uses.
 (A) Microsoft  Word
 (B) Microsoft  PowerPoint
 (C) Microsoft Access
 (D) None of these


 13. For Database management one uses.
 (A) Microsoft Access
 (B) Microsoft  PowerPoint
 (C) Microsoft Access
 (D) None of these


14. It is software for creating newsletters, business cards, flyers, greeting cards or postcards.
 (A) Microsoft Publisher
 (B) Microsoft  PowerPoint
 (C) Microsoft Access
 (D) None of these


 15. It is a  Note-taking software for use with tablet PCs or regular PCs.
 (A) Microsoft OneNote
 (B) Microsoft  PowerPoint
 (C) Microsoft Access
 (D) None of these


 16. Microsoft Office SharePoint Designer is used for.
 (A) A WYSIWYG HTML editor and web design program for customizing SharePoint applications, it replaces Microsoft Office FrontPage
 (B) Project management software to keep track of events and to create network charts and Gantt charts
 (C) Diagram and flowcharting software
 (D) None of these


 17. Microsoft Project is.
 (A) A WYSIWYG HTML editor and web design program for customizing Share Point applications, it replaces Microsoft Office FrontPage.
 (B) Project management software to keep track of events and to create network charts and Gantt charts
 (C) Diagram and flowcharting software
 (D) None of these


 18. Microsoft Visio is a.
 (A) A WYSIWYG HTML editor and web design program for customizing SharePoint applications, it replaces Microsoft Office FrontPage
 (B) Project management software to keep track of events and to create network charts and Gantt charts
 (C) Diagram and flowcharting software
 (D) None of these


 19. Microsoft Office Accounting is.
 (A) A tool for managing business finances
 (B) Project management software to keep track of events and to create network charts and Gantt charts
 (C) Diagram and flowcharting software
 (D) None of these


20. Microsoft Office Communicator is.
 (A) Integrated communications client for conferences and meetings in real time
 (B) Project management software to keep track of events and to create network charts and Gantt charts
 (C) Diagram and flowcharting software
 (D) None of these


21. Microsoft Office Document Imaging  is.
 (A) An application that supports editing scanned documents
 (B) A scanning and OCR application
 (C) Diagram and flowcharting software
 (D) None of these


22. Microsoft Office Document Scanning is.
 (A) An application that supports editing scanned documents
 (B) A scanning and OCR application
 (C) Diagram and flowcharting software
 (D) None of these


23. Microsoft Office Groove is.
 (A) A proprietary peer-to-peer software package aimed at businesses
 (B) An   application   that   supports   editing scanned documents
 (C) A scanning and OCR application
 (D) Diagram and flowcharting software


24. Microsoft Office InterConnect is.
 (A) Business-relationship database
 (B) An application that supports editing scanned documents
 (C) A scanning and OCR application
 (D) None of these


25. Microsoft Office Picture Manager is.
 (A) Basic photo management software
 (B) An application that supports editing scanned documents
 (C) A scanning and OCR application
 (D) None of these


Answer Sheet
1. (A) 2. (C) 3. (A) 4. (B) 5. (A) 6. (A) 7. (A) 8. (A) 9. (A) 10. (A) 11. (B) 12. (B) 13. (A) 14. (A) 15. (A) 16. (A) 17. (B) 18. (C) 19. (A) 20. (A) 21. (A) 22. (B) 23. (B) 24. (A) 25. (A)



1. In Microsoft Word to cut something the following shortcut is used.
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V


 In Microsoft Word shortcut CTRL+Z  is for.
 (A) Undo something
 (B) Delete something
 (C) Paste something
 (D) None of these


 3. In Microsoft Word shortcut DELETE is for.
 (A) Undo something
 (B) Delete something
 (C) Paste something
 (D) None of these


 4. A program which helps to create written document and lets you go back and make corrections as necessary.
(A) Home row keys
(B) Tool bar
(C) Spreadsheet
(D) Word processor


 5. Graphics for word processor.
 (A) Peripheral
 (B) Clip art
 (C) Highlight
 (D) Execute


 6. What type of software is used for creating letters papers and other documents?
 (A) Database
 (B) Word Processor
 (C) Spreadsheet
 (D) Operating Program


 7. What   does   the   Ctrl + I   shortcut  key accomplish in Ms-Word?
 (A) It converts selected text into the next larger size of the same font
 (B) It adds a line break to the document
 (C) It makes the selected text bold
 (D) It applies Italic formatting t the selected text


. 8. What is the file extension of Ms-Word972003 document?
 (A) Dot
 (B) Doc
 (C) Dom
 (D) Txt



9. Why   are   headers    and   footers   used  in document?
 (A) To enhance the overall appearance of the document
 (B) To mark the starting and ending of a page
 (C) To make large document more readable
 (D) To allow page headers and footers to appear on document when it is printed


 10. Which of the following shortcut key is used to check spelling?
 (A) F1
 (B) F2
 (C) F7
 (D) F9


 11. What does Ctrl + B shortcut accomplish in Ms-Word?
 (A) It converts selected text into the next larger size of the same font
 (B) It adds a line break to the document
 (C) It makes the selected text bold
 (D) It applies Italic formatting t the selected text.


 12. What is the minimum number of rows and columns that a word table can have?
 (A) Zero
 (B) 2 rows and 1 column
 (C) 2 rows and 2 column
 (D) 1 row and 1 column


 13. In Microsoft Word shortcut key CTRL+R is used for.
 (A) Open the Print dialog box
 (B) Update the current Web page
 (C) Close the current window
 (D) None of these


 14. In Microsoft Word shortcut key CTRL+W is used for.
 (A) Open the Print dialog box
 (B) Update the current Web page
 (C) Close the current window
 (D) None of these


15. In Microsoft Word system to copy something the following shortcut  is used.
 (A) CTRL+C.
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


16. In Microsoft Word shortcut SHIFT+DELETE is used for.
 (A) Delete the selected item permanently without placing the item in the Recycle Bin
 (B) Copy the selected item
 (C) Rename the selected item
 (D) Create a shortcut to the selected item


 17. In   Microsoft   Word   shortcut   CTRL   while dragging an item.
 (A) Delete the selected item permanently without placing the item in the Recycle Bin
 (B) Copy the selected item
 (C) Rename the selected item
 (D) Create a shortcut to the selected item


 18. In   Microsoft   Word   shortcut  CTRL+SHIFT while dragging an item.
 (A) Delete the selected item permanently without placing the item in the Recycle Bin
 (B) Copy the selected item
 (C) Rename the selected item
 (D) Create a shortcut to the selected item


 19. In Microsoft Word to delete the selected item permanently without placing the item in the Recycle Bin.
 (A) Shortcut SHIFT+DELETE
 (B) Shortcut CTRL while dragging an item
 (C) Shortcut CTRL+SHIFT while dragging an item
 (D) None of these


 20. In Microsoft Word move the insertion point to the beginning of the next word.
 (A) Shortcut CTRL+RIGHT ARROW
 (B) Shortcut CTRL+LEFT ARROW
 (C) Shortcut CTRL+DOWN ARROW
 (D) None of these


 21. In Microsoft Word move the insertion point to the beginning of the previous word.
 (A) Shortcut CTRL+RIGHT ARROW
 (B) Shortcut CTRL+LEFT ARROW
 (C) Shortcut CTRL+DOWN ARROW
 (D) None of these


 22. In Microsoft Word move the insertion point to the beginning of the next paragraph.
 (A) Shortcut CTRL+RIGHT ARROW
 (B) Shortcut CTRL+LEFT ARROW
 (C) Shortcut CTRL+DOWN ARROW
 (D) None of these


23. In Microsoft Word move the insertion point to the beginning of the previous paragraph.
 (A) CTRL+RIGHT ARROW
 (B) CTRL+LEFT ARROW
 (C) CTRL+DOWN ARROW
 (D) None of these


 24. In Microsoft Word move the insertion point to the beginning of the previous paragraph.
 (A) CTRL+RIGHT ARROW
 (B) CTRL+LEFT ARROW
 (C) CTRL+DOWN ARROW
 (D) CTRL+UP ARROW


 25. In Microsoft Word using CTRL+SHIFT with any of the arrow keys.
 (A) Highlight a block of text
 (B) Delete something
 (C) Paste something
 (D) None of these


 26. In Microsoft Word using SHIFT with any of the arrow keys.
 (A) Highlight a block of text
 (B) Delete something
 (C) Paste something
 (D) Select more than one item in a window or on the desktop, or select text in a document


 27. In Microsoft Word shortcut CTRL+A is to
 (A) Select all
 (B) Highlight a block of text
 (C) Delete something
 (D) Paste something


 28. In Microsoft Word shortcut for paste is
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 29. In Microsoft Word shortcut for copy is.
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 30. In Microsoft Word to paste something after cutting the following shortcut is used.
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 31. In Microsoft Word shortcut CTRL+C  is used for.
 (A) Cut
 (B) Paste
 (C) Copy
 (D) None of these


 32. In Microsoft Word shortcut key CTRL+B is used for.
 (A) Open the Organize Favorites dialog box
 (B) Open the Search bar
 (C) Start the Find utility
 (D) Open the History bar


33. In Microsoft Word shortcut key CTRL+E is used for.
 (A) Open the Organize Favorites dialog box
 (B) Open the Search bar
 (C) Start the Find utility
 (D) Open the History bar


 34. In Microsoft Word shortcut key CTRL+F is used for.
 (A) Open the Organize Favorites dialog box
 (B) Open the Search bar
 (C) Start the Find utility
 (D) Open the History bar


 35. In Microsoft Word shortcut key CTRL+H is used for.
 (A) Open the Organize Favorites dialog box
 (B) Open the Search bar
 (C) Start the Find utility
 (D) Open the History bar


 36. In Microsoft Word shortcut key CTRL+I is used for.
 (A) Open the Favorites bar
 (B) Open the Open dialog box
 (C) Start another instance of the browser with the same Web address
 (D) Open the Open dialog box, the same as CTRL+L


 37. In Microsoft Word shortcut key CTRL+L is used for.
 (A) Open the Favorites bar
 (B) Open the Open dialog box
 (C) Start another instance of the browser with the same Web address
 (D) Open the Open dialog box, the same as CTRL+L


38. In Microsoft Word shortcut key CTRL+N is used for.
 (A) Open the Favorites bar
 (B) Open the Open dialog box
 (C) Start another instance of the browser with the same Web address
 (D) Open the Open dialog box, the same as CTRL+L


39. In Microsoft Word shortcut key CTRL+O is used for.
 (A) Open the Favorites bar
 (B) Open the Open dialog box
 (C) Start another instance of the browser with the same Web address
 (D) Open the Open dialog box, the same as CTRL+L


40. In Microsoft Word shortcut key CTRL+P is used for.
 (A) Open the Print dialog box
 (B) Update the current Web page
 (C) Close the current window
 (D) None of these


Answer Sheet

1. (B) 2. (A) 3. (B) 4. (D) 5. (B) 6. (B) 7. (D) 8. (B) 9. (D) 10. (C) 11. (B) 12. (D) 13. (B) 14. (C) 15. (A) 16. (A) 17. (B) 18. (D) 19. (A) 20. (A) 21. (B) 22. (A) 23. (D) 24. (D) 25. (A) 26. (D) 27. (A) 28. (C) 29. (C) 30. (C) 31. (A) 32. (A) 33. (B) 34. (C) 35. (D) 36. (A) 37. (B) 38. (C) 39. (D) 40. (A)


1. In Excel default header for a worksheet is
 (A) Your name
 (B) The date and time
 (C) None
 (D) The sheet tab name


2. In Excel which of the following is not an option in the spelling dialog box.
 (A) Edit
 (B) Ignore
 (C) Ignore all
 (D) Change


 3. Excel uses the …. Function when creating a data table.
 (A) Average
 (B) Count
 (C) Sum
 (D) Table


 4. In Excel you can copy cell formats from one cell to another by using the.
 (A) Backspace key
 (B) Default font
 (C) Format painter
 (D) Formatting toolbar


 5. In Excel accounting style shows negative numbers in.
 (A) Bold
 (B) Brackets
 (C) Parentheses
 (D) Quotes


 6. In Excel you can use drag and drop to embed excel worksheet data in a word document.
(A) By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key (B) By dragging a range of excel data to the Word   button   on  the  taskbar  while pressing Shift key (C) By displaying both applications side-byside and dragging a selected range of Excel  data  into  the  word  application window while pressing the Ctrl key
 (D) (A) and (C)


 7. In Excel the chart wizard.
 (A) Can place a chart on a new chart sheet or on any sheet in the workbook
 (B) Can only place a chart on new chart sheet
 (C) Can only place a chart on a new blank worksheet
 (D) Can only be used to create embedded charts


8. In Excel which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004     (A) Workday
 (B) Date
 (C) Networkdays
 (D) All of the above


 9. In Excel data marker on a chart are linked to data points in a worksheet, therefore,
 (A) You can automatically apply formatting to a data series
 (B) You can change the position of a data marker and automatically change the data point value in the worksheet
 (C) You can change a data print value and automatically are draw the chart
 (D) (A) and (B)


 10. In Excel when you group worksheets.
 (A) You can enter variable data on multiple worksheets at one time
 (B) You can print more than one worksheet at a time
 (C) You can enter common data, formats, and formulas on multiple worksheets at one time
 (D) (B) and (C)


 11. In Excel you can zoom a worksheet.
 (A) With the mouse pointer in Print Preview
 (B) With the zoom button on the Print Preview toolbar
 (C) With the Zoom command on the view menu
 (D) All of the above


 12. You cannot link Excel worksheet data to a Word document.
 (A) With the right drag method
 (B) With a hyperlink
 (C) With   the   copy   and   paste  special commands
 (D) With the copy and paste buttons on the standard toolbar


13. In Excel this type of software is similar to an accountant’s worksheet.
 (A) Word processing
 (B) Database
 (C) Spreadsheets
 (D) Graphics


 14. In Excel you can use the format painter multiple times before you turn it off by
 (A) You can use the format painter button only one time when you click it
 (B) Double clicking the format painter button
 (C) Pressing the Ctrl key and clicking the format painter button
 (D) Pressing Alt key and clicking the format painter button


 15. In Excel default header for a worksheet is.
 (A) Your name
 (B) The date and time
 (C) None
 (D) The sheet tab name


 16. In Excel which of the following is not an option in the spelling dialog box.
 (A) Edit
 (B) Ignore
 (C) Ignore all
 (D) Change


 17. In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….. Menu.
 (A) Edit
 (B) View
 (C) Format
 (D) Tools


 18. In Excel….. is a group of cells that form a rectangle on the screen.
 (A) Calculation
 (B) Formula
 (C) Range
 (D) Range address


 19. In Excel following term describes explanatory text attached to a cell.
 (A) Callout
 (B) Comment
 (C) Dialog
 (D) Extension


 20. In Excel the drag and drop method of copying or moving.
 (A) Can be used between worksheets but not workbooks
 (B) Can be used between workbooks but not worksheets
 (C) Can be used between workbooks but not worksheets
 (D) None


 21. In Excel 3-D reference in a formula
 (A) Cannot be modified
 (B) Only appears on summary worksheets
 (C) Limits the formatting options
 (D) Spans worksheets


 22. In Excel the auto calculate feature
 (A) Can only add values in a range of cells
 (B) Provides a quick way to view the results of an arithmetic operation on a range of cells
 (C) Automatically creates formulas and adds them to a worksheet
 (D) None of the above


 23. In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu.
 (A) Edit
 (B) Format
 (C) Tools
 (D) Data


 24. In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
 (A) Edit
 (B) Insert
 (C) Format
 (D) Tools 


25. In Excel which of the following is not a worksheet design criterion.
 (A) Efficiency
 (B) Auditability
 (C) Description
 (D) Clarity Correct Answer:


  26. In Excel to copy cell contents using drag and drop, press the
 (A) End key
 (B) Shift key
 (C) Esc key
 (D) None of above


 27. In Excel if you press …….., the cell accepts your typing as its contents.
 (A) Enter
 (B) Ctrl + Enter
 (C) TAB
 (D) Insert


 28. In Excel  the auto fill feature.
 (A) Extends a sequential series of data
 (B) Automatically adds a range of cell values
 (C) Applies a boarder around selected cells
 (D) None of above


 29. In Excel  the keyboard shortcut (button or buttons to be presse(D) for creating a chart from the selected cells.
 (A) F3
 (B) F5
 (C) F7
 (D) F11


 30. In Excel you can use the formula palette to.
 (A) Format cells containing numbers
 (B) Create and edit formulas containing functions
 (C) Entered assumptions data
 (D) Copy a range of cells


 31. What excel feature can you use if you want to work with one record at a time?
 (A) Auto Complete
 (B) Auto Filter
 (C) Data Form
 (D) Sub Totals


32. In Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?
 (A) Category axis
 (B) Data marker
 (C) Data point
 (D) Gridline


 33. In Excel value used in a formula that does not change is called a.
 (A) Cell address
 (B) Constant
 (C) Function
 (D) Range


 34. In Excel which elements of worksheet can be protected from accidental modification ?
 (A) Contents
 (B) Objects
 (C) Scenarios
 (D) All of above


 35. In Excel  you  can  use  the  drag  and  drop method to.
 (A) Copy cell contents
 (B) Move cell contents
 (C) Add cell contents
 (D) (A) and (B)


 36. In Excel it is acceptable ot let long text flow into adjacent cells on a worksheet when.
 (A) Data will be entered in the adjacent cells
 (B) No data will be entered in the adjacent cells
 (C) There is nt suitable abbreviation of the text
 (D) There is not time to format the next


 37. In Excel how can you delete a record?
 (A) Delete the column from the worksheet
 (B) Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
 (C) Select Data > Delete Record from the menu
 (D) Click the Delete button on the Standard toolbar


 38. Right clicking something in Excel.
 (A) Deletes the object
 (B) Nothing the right mouse button is there for left handed people
 (C) Opens   a   shortcut   menu   listing everything you can do to the object
 (D) Selects the object


 39. In Excel Documentation should include.
 (A) Destination and users of the output data
 (B) Source of input data
 (C) Information   on   the   purpose   of   the workbook
 (D) All of the above


40. Files   created   with   Lotus   1-2-3    have   an extension.
 (A) DOC
 (B) XLS
 (C) 123
 (D) WK1


 41. In Excel to delete an embedded objects, first.
 (A) Double click the object
 (B) Select the object by clicking it
 (C) Press the Shift + Delete keys
 (D) Select it and then press the delete key


 42. In Excel comments can be added to cells using.
 (A) Edit > Comments
 (B) Insert > Comments
 (C) File > Comments
 (D) View > Comments


 43. In   Excel   which   of   the  following   is   not  a worksheet design criterion?
 (A) Efficiency
 (B) Aditibility
 (C) Description
 (D) Clarity


 44. In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?
 (A) Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.
 (B) Click page setup on the file menu, click the page tab, click the options button, then enter your choices.
 (C) Click page setup on the finle menu, click the sheet tab, and make a selection under the print heading.
 (D) All of above


 45. In Excel  a fast way to add up this column of number is to click in the cell below  the numbers and then.
 (A) Click subtotals on the data menu
 (B) View the sum in the formula bar
 (C) Click the autosum button on the standard toolbar, then press enter
 (D) All of above


 46. In Excel which of the following is an absolute cell reference?
 (A) !A!1
 (B) $A$1
 (C) #a#1
 (D) A1


 47. In Excel what symbol is used before a number to make it a label?
 (A) “ (quote)
 (B) = (equal)
 (C) _ (underscore)
 (D) ‘ (apostrophe)



48. In Excel which symbol must all formula begin with?
 (A) = (B) + (C) ( (D) @ 49. In Excel which of the following formulas is not entered correctly? (A) =10+50
 (B) =B7*B1
 (C) =B7+14
 (D) 10+50 50


49. In Excel which of the following formulas will Excel not be able to calculate?
 (A) =SUM(Sales)-A3
 (B) =SUM(A1:A5)*.5
 (C) =SUM(A1:A5)/(10-10)
 (D) =SUM(A1:A5)-10


 51. In Excel typical worksheet has …. Number of columns.
 (A) 128
 (B) 256
 (C) 512
 (D) 1024


 52. In Excel how many characters can be typed in a single cell?
 (A) 256
 (B) 1024
 (C) 32,000
 (D) 65,535


 53. In Excel worksheet can have a maximum of …. Number of rows.
 (A) 256
 (B) 1024
 (C) 32,000
 (D) 65,535


 54. In Excel  the following is not an example of a value.
 (A) 350
 (B)  May 10, 2001
 (C) 57&per cent
 (D) Serial Number 50771


 55. In Excel chart wizard term data series refers to.
 (A) A chart legend
 (B) A collection of chart data markers
 (C) A set of values you plot in a chart
 (D) A data label


 56. In Excel  Chart wizard term data categories refers to.
 (A) A chart plot area
 (B) A horizontal axis
 (C) The organization of individual values with a chart’s data series
 (D) The data range that supply chart data


 57. In Excel worksheet range is a.
 (A) A command used for data modeling
 (B) A range of values such as from
 23 to 234
 (C) A group of cells
 (D) A group of worksheets



58. In Excel getting data from a cell located in a different sheet is called.
 (A) Accessing.
 (B) Referencing.
 (C) Updating
 (D) Functioning


 59. In Excel Tab scrolling button.
 (A) Allow you to view a different worksheet
 (B) Allow you to view additional worksheet rows down
 (C) Allow you to view additional worksheet columns to the right
 (D) Allow you to view additional sheets tabs


 60. In Excel  numeric value can be treated as a label value if it precedes with.
 (A) Apostrophe (‘)
 (B) Exclamation (!)
 (C) Hash (#)
 (D) Ampersand (&)


 61. In Excel concatenation of text can be done using.
 (A) Apostrophe (‘)
 (B) Exclamation (!)
 (C) Hash (#)
 (D) Ampersand (&)


 62. In Excel data can be arranged in a worksheet in a easy to understand manner using.
 (A) Auto formatting
 (B) Applying styles
 (C) Changing fonts
 (D) All of above


 63. In Excel you can use drag-and-drop to embed excel worksheet data in a word document.
 (A) By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key   (B) By dragging a range of excel data to the word button on the taskbar while pressing Shift key
 (C) By dragging a range of excel data to the word button on the taskbar while pressing Alt key
 (D) None of above


 64. In Excel  the auto calculate feature.
 (A) Can only add values in a range of cells
 (B) Provides a quick way to view the result of an arithmetic operation on a range of cells
 (C) Automatically creates formulas and adds them to a worksheet
 (D) (A) and (C)


 65. In Excel to view a cell comment.
 (A) Click the edit comment commands on the Insert menu
 (B) Click the Display comment command on the window menu
 (C) Position the mouse pointer over the cell
 (D) Click the comment command on the view menu


66. In Excel  say that you want to paste a formula result – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?
 (A) Click the Paste button on the standard toolbar
 (B) Click the arrow on the paste button on the standard toolbar, then click formulas
 (C) Click the arrow on the paste button on the standard toolbar, then click values.
 (D) All of above


 67. In Excel you can select a single range of cells by.
 (A) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
 (B) Pressing the Ctrl key while dragging over the desired cells
 (C) Pressing the Shift key and an arrow key
 (D) Dragging over the desired cells


 68. All formula in Excel start with.
 (A) &percent;
 (B) +
 (C) =
 (D)


 69. In Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?
 (A) & (ampersan(D)
 (B) = (equal sign)
 (C) (space)
 (D) All of the above


 70. In Excel two common wildcard characters that Excel recognizes are.
 (A) * and ?
 (B) < and >
 (C) ^ and /
 (D) + and


 71. In Excel divide symbol is.
 (A) /
 (B) D
 (C) \ 
(D) ) 


72. In Excel to add two cells (A1 and A2) together you use the following formula.
 (A) =A1 + A2
 (B) =Add(A1+A2)
 (C) =together(A1:A2)
 (D) A1 plus A2


 73. In Excel on an excel sheet the active cell in indicated by.
 (A) A dark wide boarder
 (B) A dotted border
 (C) A blinking border
 (D) None of above

74. In Excel on an Excel sheet the active cell in indicated by.
 (A) A dark wide border
 (B) A dotted border
 (C) A blinking border
 (D) None of above


 75. In Excel using the F11 shortcut key to create a chart on chart sheet creates.
 (A) A default chart
 (B) A 2-dimensional column chart
 (C) A 2-dimensional bar chart
 (D) A 3-dimensional  line chart


 76. In Excel you can print.
 (A) A range of cells by range name
 (B) An entire worksheet
 (C) A single worksheet
 (D) All of the above


 77. In Excel you can create only a horizontal page break by first selecting.
 (A) A row below the row where you want the page break to occure
 (B) A cell in row 1
 (C) A cell in column A
 (D) (A) and (C)


 78. In Excel you can create hyperlinks from the Excel workbook to.
 (A) A webpage on company internet
 (B) A web page on the internet
 (C) Other Office application documents
 (D) All


 79. In Excel cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is.
 (A) B1-G10
 (B) B1.G10
 (C) B1;G10
 (D) B1:G10*


 80. In Excel advantage of using a spreadsheet is.
 (A) calculations can be done automatically.
 (B) changing data automatically updates calculations
 (C) more flexibility
 (D) all of the above


 81. In Excel intersection of a row and column is called :
 (A) Cata
 (B) A field
.(C) A cell
 (D) An equation.


 82. There are three types of data found in a spreadsheet.
 (A) data, words, numbers
 (B) equations, data, numbers
 (C) words, numbers, labels
 (D) numbers formulas, labels




83. In Excel to select a column the easiest method is to.
 (A) Double click any cell in the column
 (B) Drag from the top cell in the column to the last cell in the column
 (C) Click the column heading
 (D) Click the column label


 84. In Excel if you press ……, the cell accepts your typing as its contents.
 (A) Enter
 (B) Ctrl+Enter
 (C) Tab
 (D) Insert


 85. In Excel to view a cell comment.
 (A) Click the edit comment command on the insert menu
 (B) Click the display comment command on the window menu
 (C) Position the mouse pointer over the cell
 (D) Click the comment command on the view menu


 86. In Excel when you want to insert a blank imbedded excel object in a word document you can.
 (A) Click the object command on the insert menu
 (B) Click the office links button on the standard toolbar
 (C) Click the create worksheet button on the formatting toolbar
 (D) Click the import excel command on the file menu


 87. In Excel to save a workbook, you.
 (A) Click the save button on the standard toolbar from the menu
 (B) Press Ctrl+F5
 (C) Click Save on the Windows Start button
 (D) Select Edit>Save


 88. In Excel you can edit a cell by.
 (A) Clicking the formula button
 (B) Double clicking the cell to edit it in-place
 (C) Selecting Edit>Edit Cell from the menu
 (D) None of above


 89. In Excel you can select a single range of cells by.
 (A) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
 (B) Pressing the Ctrl key while dragging over the desired cells
 (C) Pressing the Shift key and an arrow key
 (D) Dragging over the desired cells


90. In Excel to copy cell contents using drag and drop press the.
 (A) End key
 (B) Shift key
 (C) Ctrl key
 (D) Esc key


 91. In Excel when you copy a formula.
 (A) Excel erases the original copy of the formula
 (B) Excel edits cell references in the newly copied formula
 (C) Excel adjusts absolute cell references
 (D) Excel doesn’t adjust relative cell references


 92. In Excel  autofill feature.
 (A) Extends a sequential series of data
 (B) Automatically adds range of cell values
 (C) Applies a boarder around the selected cells
 (D) None of the above


 93. In Excel which menu option can be sued to split windows into two.
 (A) Format > window
 (B) View > window > split
 (C) Window > split
 (D) View > split


 94. In Excel which of the following special function keys allow the content in cell.
 (A) Esc
 (B) Shift
 (C) Return
 (D) Tab


 95. In Excel which is not an advantage of using computerized spreadsheets?
 (A) Flexibility of moving entries
 (B) Speed of calculation
 (C) Ability of generate tables
 (D) Cost of initial setup


 96. In Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the.
 (A) Unfreeze panes command on the window menu
 (B) Freeze panes command on the window menu
 (C) Hold titles command on the edit menu
 (D) Split command on the window menu


 97. In Excel  the following will not cut information.
 (A) Pressing Ctrl + C
 (B) Selecting Edit>Cut from the menu
 (C) Clicking the Cut button on the standard
 (D) Pressing Ctrl+X


 98. In Excel which of the following is not a way to complete a cell entry?
 (A) Pressing enter
 (B) Pressing any arrow key on the keyboard
 (C) Clicking the Enter button on the Formula bar
 (D) Pressing spacebar


99. In Excel you can activate a cell by.
 (A) Pressing the Tab key
 (B) Clicking the cell
 (C) Pressing an arrow key
 (D) All of the above


 100. In Excel Text formulas.
 (A) Replace cell references
 (B) Return ASCII values of characters
 (C) Concatenate and manipulate text
 (D) Show formula error value


 101. In Excel  how do you insert a row?
 (A) Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
 (B) Select the row heading where you want to insert the new row and select Edit >Row from the menu
 (C) Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
 (D) All of the above


 102. In Excel  the following is not a basic step in creating a worksheet.
 (A) Save workbook
 (B) Modifiy the worksheet
 (C) Enter text and data
 (D) Copy the worksheet


 103. In Excel  how do you select an entire column?
 (A) Select Edit > Select > Column from the menu
 (B) Click the column heading letter
 (C) Hold down the shift key as you click anywhere in the column.
 (D) Hold down the Ctrl key as you click anywhere in the column


 104. In Excel  how can you print three copies of a workbook?
 (A) Select File>Properties form the menu and type 3 in the Copies to print text box.
 (B) Select File >Print from the menu and type 3 in the Number of copies text box.
 (C) Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made
 (D) Press Ctrl+P+3


 105. In Excel  to create a formula, you first.
 (A) Select the cell you want to place the formula into
 (B) Type the equals sign (=) to tell Excel that you’re about to enter a formula

(C) Enter the formula using any input values and the appropriate mathematical operators that make up your formula
 (D) Choose the new command from the file menu


 106. In Excel  to center worksheet titles across a range of cells, you must.
 (A) Select the cells containing the title text plus the range over which the title text is to be centered (B) Widen the columns
(C) Select the cells containing the title text plus the range over which the title text is to be enfettered (D) Format the cells with the comma style


 107. In Excel how do you delete a column?
 (A) Select the column heading you want to delete and select the Delete Row button on the standard toolbar
 (B) Select the column heading you want to delete and select Insert Delete from the menu
 (C) Select the row heading you want to delete and select Edit>Delete from the menu
 (D) Right click the column heading you want to delet and select delete from the shortcut menu


 108. In Excel  how can you find specific information in a list?
 (A) Select Tools > Finder from the menu
 (B) Click the Find button on the standard toolbar
 (C) Select Insert > Find from the menu
 (D) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button


 109. In Excel when integrating word and excel, word is usually the.
 (A) Server
 (B) Destination
 (C) Client
 (D) Both (A) and (C)


 110. In Excel  when a label is too long to fit within a worksheet cell, you typically must.
 (A) Shorten the label
 (B) Increase the column width
 (C) Decrease the column width
 (D) Adjust the row height


 111. In Excel  name box.
 (A) Shows the location of the previously active cell
 (B) Appears to the left of the formula bar
 (C) Appears below the status bar
 (D) Appears below the menu bar



112. In Excel  Comments put in cells are called.
 (A) Smart tip
 (B) Cell tip
 (C) Web tip
 (D) Soft tip


 113. In Excel  which is used to perform what if analysis?
 (A) Solver
 (B) Goal seek
 (C) Scenario Manager
 (D) All of above


 114. In Excel  you can use the horizontal and vertical scroll bars to.
 (A) Split a worksheet into two panes
 (B) View different rows and columns edit the contents of a cell
 (C) Edit the contents of a cell
 (D) View different worksheets


 115. In Excel  Multiple calculations can be made in a single formula using.
 (A) standard formulas
 (B) array formula
 (C) complex formulas
 (D) smart formula


 116. In Excel To select several cells or ranges that are not touching each other, you would … while selecting.
 (A) hold down the Ctrl key
 (B) hold down the Shift key
 (C) hold down the Alt key
 (D) hold down Ctrl + Shift key


 117. In Excel A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white background. The cells in row 26 that contain data have a dark grey background, when you click the Print button.
 (A) nothing will print because some cells with data have been omitted
 (B) only the cells with gray background will print
 (C) the whole sheet will print
 (D) only the cells with white background will print


 118. In Excel  constant is another name for this type of data.
 (A) number
 (B) equation
 (C) formula
 (D) description


 119. In Excel the view that puts a blue a blue line around each page that would be printed is the
 (A) Print Preview
 (B) Normal View
 (C) Page Break Preview
 (D) Split View


 120. In Excel AutoCalculate will quickly add selected cells if you.
 (A) right click on the status bar and select Sum
 (B) click the AutoCalculate button on the toolbar
 (C) use the key combination Ctrl+$
 (D) double click the selection


 121. In Excel the cell labeled F5 refers to.
 (A) row F column 5
 (B) column F row 5
 (C) function available in cells
 (D) function key F4


 122. In Excel when you are typing an equation into a cell the first thing that must be entered is.
 (A) the first cell referenced
 (B) parenthesis
 (C) quotation marks
 (D) an equal sign


 123. In Excel using the AutoSum button will replace in the selected cell.
 (A) the sum of values  in the cell’s column
 (B) nothing until you select a range of cells
 (C) the sum of the cell’s row unless you change the range
 (D) a formula which will add values in the range Excel guesses you want to add


 124. In Excel Book1 is an example of how … are numbered and named during each work session   (A) Active cell
 (B) Formula bar
 (C) Menu bar
 (D) Name box


 125. In Excel the following displays the contents of the active cell.
 (A) Active cell
 (B) Formula bar
 (C) Menu bar
 (D) Name box


 126. In Excel Graphics objects on a chart are used to.
 (A) Add emphasis to chart data
 (B) Add interest to a chart
 (C) Help explain the chart data
 (D) All the above


 127. In Excel to select a column the easiest method is to.
 (A) Double click any cell in the column
 (B) Drag from the top cell in the column to the last cell in the column
 (C) Click the column heading
 (D) Click the column label


 128. In Excel to select an individual data marker or data label, you must.
 (A) Double click the data series
 (B) Right click selected marker
 (C) Click once to select the series markers or labels and click the desired marker or label again
 (D) Double click the marker or label


129. In Excel to delete and embedded object, first.
 (A) Double click the object
 (B) Select the object by clicking it
 (C) Press the Shift + Delete keys
 (D) Select it and then press Delete key


 130. This type of software contains rows and columns.
 (A) Drawing
 (B) Spreadsheet
 (C) Database
 (D) Word processing


 131. In Excel to open an existing workbook, you can click the Open button on the …… toolbar.
 (A) Drawing
 (B) Formatting
 (C) Forms
 (D) Standard


 132. In Excel you can activate a cell by.
 (A) Pressing the Tab key
 (B) Clicking the cell
 (C) Pressing an arrow key
 (D) All of above


 133. In Excel the following setup options cannot be set in the page setup dialog box?
 (A) Printer selection
 (B) Vertical or horizontal placement
 (C) Orientation
 (D) Row and column titles


 134. In Excel  term refers to a specific set of values saved with the workbook.
 (A) Range
 (B) Scenario
 (C) Trend line
 (D) What-if analysis


 135. In Excel got functions? No? You need the insert function dialog box. How do you get it?
 (A) Right click a cell and then click insert
 (B) Click the insert menu and then click function
 (C) Type = in a cell
 (D) All of the above


 136. In Excel the following describes how to select all the cells in a single column?
 (A) Right click on column and select Pick from list
 (B) Use data – text to columns menu item
 (C) Left click on the gray column title button
 (D) Pressing Ctrl + A on the keyboard


 137. In Excel when you use the fill effects in the format data series dialog box, you cannot.
(A) Rotate text on the chart
(B) Select a fore ground color 
(C) Select a pattern
(D) Select a background color


 138. In Excel Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
 (A) Rows and columns
 (B) Headings
 (C) Speed
 (D) None



139. In Excel the following is not a basic step in creating a worksheet.
 (A) Save the workbook
 (B) Modify the worksheet
 (C) Enter text and data
(D) Copy the worksheet


 140. In Excel what does SUMIF function do?
 (A) Adds up cell values based on a condition
 (B) Adds all the numbers in a range of cells
 (C) Returns a subtotal in a list or database
 (D) All of above


 141. In Excel you can insert labels for.
 (A) All the data markers on a chart
 (B) A data series
 (C) A selected data marker
 (D) All of the above


 142. In Excel Tab scrolling buttons.
 (A) Allow you to view a different worksheet
 (B) Allow you to view additional worksheet row down
 (C) Allow you to view additional worksheet columns to the right
 (D) Allow you to view additional sheet tabs


 143. In Excel All macro keyboard shortcuts include the ….. key.
 (A) Alt
 (B) Ctrl
 (C) F11
 (D) Shift


 144. In Excel to open the Format Cells dialog box, press.
 (A) Alt + 1
 (B) Ctrl + 1
 (C) Ctrl + Shift + 1
 (D) F1


 145. In Excel you can add a hyperlink to your worksheet by pressing.
 (A) Alt + K
 (B) Ctrl + H
 (C) Ctrl + K
 (D) Ctrl + Shift + K


 146. In Excel to move to the previous worksheet, press.
 (A) Alt + PgUp
 (B) Ctrl + PgUp
 (C) Ctrl + PgDn
 (D) Shift + Tab


 147. In Excel you can select a single range of cells by.
 (A) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
 (B) Pressing the Ctrl key while dragging over the desired cells
 (C) Pressing the Shift key and an arrow key
 (D) Dragging over the desired cells




148. In Excel which of these will not select all the cells in a document?
 (A) Clicking three times with the right mouse button in the spreadsheet
 (B) Using the Edit – Select All menu
 (C) Pressing Ctrl + A on the keyboard
 (D) Pressing Ctrl + A on the keyboard


 149. In Excel you can use the formula palette to.
 (A) Format cells containing numbers
 (B) Create and edit formulas containing functions
 (C) Enter assumptions data
 (D) Copy a range of cells


 150. In Excel you can convert existing excel worksheet data an charts to an HTML document by using.
 (A) FTP wizard
 (B) Internet assistant wizard
 (C) Intranet wizard
 (D) Import wizard


 151. In Excel circular reference is.
 (A) Geometric modeling tool
 (B) A cell that points to a drawing object
 (C) A formula that either directly or indirectly depends on itself
 (D) Always erroneous


 152. In Excel when you insert an excel file into a word document. The data are.
 (A) Hyperlinked placed in a word table
 (B) Linked
 (C) Embedded
 (D) Use the word menu bar and toolbars


 153. In Excel the following is not information you can specify using the solver.
 (A) Input cells
 (B) Constraints
 (C) Target cell
 (D) Changing cells


 154. In Excel each excel file is called a workbook because.
 (A) It can contain text and data
 (B) It can be modified
 (C) It can contain many sheets including worksheets and chart sheets
 (D) You have to work hard to create it


 155. In Excel you can enter which types of data into worksheet cells?
 (A) Labels, values, and formulas
 (B) Labels and values but not formulas
 (C) Values and formulas but not labels
 (D) Formulas only


156. In Excel all worksheet formula.
 (A) Manipulate values
 (B) Manipulate labels
 (C) Return a formula result
 (D) Use the addition operator


 157. In Excel which of the following is a correct order of precedence in formula calculation?
 (A) Multiplication and division exponentiation positive and negative values
 (B) Multiplication and division, positive and negative values, addition and subtraction
 (C) Addition and subtraction, positive and negative values, exponentiation
 (D) All of above


 158. In Excel the Paste Special command lets you copy and paste.
 (A) Multiply the selection by a copied value
 (B) Cell comments
 (C) Formatting options
 (D) The   resulting   values   of   a   formula instead of the actual formula


 159. In Excel the numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this?
 (A) None of these
 (B) Select Format > Money from the menu
 (C) Click the Currency Style button on the formatting toolbar
 (D) You have to retype everything and manually add the dollar signs, commas, and decimals.


 160. In Excel which of the following is not a valid data type in excel.
 (A) Number
 (B) Character
 (C) Label
 (D) Date/time


 161. Excel worksheet cells work very similarly to what common element of the windows graphical user interface.
 (A) Option buttons
 (B) List boxes
 (C) Text boxes
 (D) Combo boxes


 162. In Excel which of the following options is not located in the Page Setup dialog box?
 (A) Page Break Preview.
 (B) Page Orientation
 (C) Margins
 (D) Headers and Footers


 163. In Excel one want to track the progress of the stock market on a daily basis. Which type of chart should one use?
 (A) Pie chart
 (B) Row chart
 (C) Line chart
 (D) Column chart


164. In Excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
 (A) Press Ctrl +Home
 (B) Press Home
 (C) Press Shift + Home
 (D) Press Alt + Home


 165. Which of the following methods cannot be used to edit the contents of a cell In Excel?
 (A) Press the Alt key
 (B) Clicking the formula bar
 (C) Pressing the F2 key
 (D) Double clicking the cell


 166. In Excel if you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you
 (A) Press the Erase key
 (B) Press Esc
 (C) Press the Enter button
 (D) Press the Edit Formula button


 167. In Excel  default style for new data keyed in a new workbook is.
 (A) Comma
 (B) Currency
 (C) Normal
 (D) Per cent


 168. In Excel LEN function does what?
 (A) Compares the content in two cells
 (B) Counts the numbers of characters in a cell
 (C) Deletes extra space in text
 (D) All of above


 169. In Excel this function converts miles to kilometers, kilograms to pounds, and so on.
 (A) Convert
 (B) Product
 (C) Change
 (D) All of above


 170. In Excel you can use the drag and drop method to.
 (A) Copy cell contents
 (B) Delete cells contents
 (C) Add cell contents
 (D) All of above


 171. In Excel to balance your checkbook, your best method is.
 (A) Copy your check amounts into Excel so that you’ll have a neat printout to work on
 (B) Use Excel to check your arithmetic
(C) Download     the    Checkbook    register templates from Templates on Microsoft Office Online (D) All of above




172. In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell.
 (A) Count
 (B) Average
 (C) Sum
 (D) None of above


 173. In Excel to name a constant, you use the …… dialog box.
 (A) Create names
 (B) Define name
 (C) Paste name
 (D) Format cells


 174. In Excel to cancel the marquee, press.
 (A) Ctrl + End
 (B) End
 (C) Esc
 (D) Shift + Esc


 175. In Excel the function calculates depreciation at the same amount each year over an asset’s useful life.
 (A) DB (fixed-declining balance)
 (B) SLN (straight line)
 (C) DDB (double-declining)
 (D) All of above


 176. In Excel the following is not an underline option in the format cells dialog box.
 (A) Double
 (B) Single Engineering
 (C) Single Accounting
 (D) Double Accounting


 177. In Excel to center worksheet titles across a range of cell, you must.
 (A) Select the cells containing the title text and use the fill handle to center the text across a range of cells
 (B) Widen the columns
 (C) Select the cells containing the title text and use the fill handle to center the text across a range of cells
 (D) Widen the column


 178. In Excel when integrating Ms-Word and Excel, Word is usually the.
 (A) Server
 (B) Source
 (C) Client
 (D) None


 179. In Excel Charts tips can.
 (A) Show the formatting of a data label
 (B) Show the name of a data series
 (C) Show the value of data point
 (D) Both (B) and (C)


 180. In Excel the Name box.
 (A) Shows the location of the previously active cell
 (B) Appears t the left of the formula bar
 (C) Appears below the status bar
 (D) Appears below the menu bar



181. In Excel how do you change column width to fit the contents?
 (A) Single-click the boundary to the left to the column heading
 (B) Double click the boundary to the right of the column heading
 (C) Press Alt and single click anywhere in the column
 (D) All of above


 182. In Excel when you work with large worksheets, you may need to.
 (A) Size the worksheet to fit on the specific number of pages
 (B) Add and remove page breaks
 (C) Specify only certain print areas
 (D) All of above


 183. In Excel Hyperlinks cannot be.
 (A) Special shapes like stars and banners
 (B) Drawing objects like rectangles ovals
 (C) Pictures
 (D) All can be hyperlinks


 184. In Excel you can use the horizontal and vertical scroll bars to.
 (A) Split a worksheet into two panes
 (B) View different rows and columns
 (C) Edit the contents of a cell
 (D) View different worksheets


 185. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer
. (A) Spreadsheet program
 (B) Database program
 (C) Word processor program
 (D) Desktop publisher program


 186. In Excel you can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
 (A) Standard
 (B) Formatting
 (C) Drawing
 (D) Picture


 187. In Excel to drag a selected range of data to another worksheet in the same workbook, use the (A) Tab key
 (B) Alt key
 (C) Shift key
 (D) Ctrl key


 188. In Excel when creating a vertical page break.
 (A) The active cell must be A1
 (B) The active cell can be anywhere in the worksheet
 (C) The active cell must be in row 1
 (D) The active cell must be in column A


 189. In Excel to activate the previous cell in a preselected range, press.
 (A) The Alt key
 (B) The Tab key
 (C) The Enter key
 (D) None of above


190. In Excel when the formula bar is activated, you can see.
 (A) The Edit Formula button
 (B) The Cancel button
 (C) The Enter button
 (D) All of above


 191. In a worksheet you can select.
 (A) Etire worksheet
 (B) Rows
 (C) Columns
 (D) All of the above


 192. When you print preview a worksheet.
 (A) the entire worksheet is displayed
 (B) the selected range is displayed
 (C) the active portion of the worksheet is displayed
 (D) All of the above


 193. In Excel to access the Go To Special feature, you can press.
 (A) Ctrl + G
 (B) Ctrl + O
 (C) Ctrl + Shift + G
 (D) Ctrl + 1


 194. In Excel which do you press to enter the current date in a cell?
 (A) Ctrl + Shift + :
 (B) Ctrl + ;
 (C) Ctrl + F10
 (D) All of above


 195. In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when.
 (A) Data will be entered in the adjacent cells
 (B) No data will be entered in the adjacent cells
 (C) There is no suitable abbreviation for the text
 (D) There is not time to format the text


 196. In Excel you can group noncontiguous worksheets with.
 (A) The group button on the standard toolbar
 (B) The shift key and the mouse
 (C) The ctrl key and mouse
 (D) The alt+enter key


 197. In Excel  Weight refers to
 (A) The print density of characters
 (B) The height of the printed character
 (C) Upright or slanted shape
 (D) The design and appearance of characters


 198. When you link data maintained in Excel workbook to a Word document.
 (A) The Word document cannot be edited
 (B) The Word document contains a reference to the original source application
 (C) The word document must contain a hyperlink
 (D) The word document contains a copy of the actual data


 199. In Excel when you see a cell with a red triangle in the top right corner, what does this signify? (A) There is an error in the cell
 (B) There is a comment associated with the cell
 (C) The font color for text in the cell is red
 (D) A formula cannot be entered into the cell


200. In Excel to hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the.
 (A) Unfreeze panes command on the window menu
 (B) Freeze panes command on the window menu
 (C) Hold titles command on the edit menu
 (D) Split command on the window menu


 201. In Excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
 (A) Use Ctrl to select all three cells, then click the paste button on the standard toolbar
 (B) Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
 (C) Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
 (D) All of above


 202. To edit data in an embedded Excel worksheet object in a Word document
 (A) Use the Excel menu bar and toolbars inside the word application
 (B) Edit the hyperlink
 (C) Edit the data in a Excel source application
 (D) Use the Word menu bar and toolbars


 203. In Excel Status indicators are located on the.
 (A) Vertical scroll bar
 (B) Horizontal scroll bar
 (C) Formula bar
 (D) Standard toolbar


 204. In Excel Rounding errors can occur.
 (A) When you use multiplication, division, or exponentiation in a formula
 (B) When you use addition and subtraction in a formula
 (C) Because excel uses hidden decimal places in computation
 (D) When you show the results of formulas with different decimal places that the calculated results 


205. In Excel one can copy data or formulas.
 (A) With the copy, paste and cut commands on the edit menu
 (B) With commands on ta shortcut menu
 (C) With buttons on the standard toolbars
 (D) All of the above


 206. In Excel you cannot link excel worksheet data to a word document.
 (A) With the right drag method
 (B) With a hyperlink
 (C) With the copy and paste special commands
 (D) With the copy and paste buttons on the standard toolbar


207. An excel workbook is a collection of.
 (A) Workbooks
 (B) Worksheets
 (C) Charts
 (D) Worksheets and charts


 208. Excel files have a default extension of.
 (A) Xls
 (B) Xlw
 (C) Wk1
 (D) 123


 209. In Excel one can use the format painter multiple times before one turn it off by.
 (A) You can use the format painter button on ly one time when you click it
 (B) Double clicking the format painter button
 (C) Pressing the Ctrl key and clicking the format painter button
 (D) Pressing the Alt key and clicking the format painter button


 210. In Excel Status indicators are located on the.
 (A) Vertical scroll bar
 (B) Horizontal scroll bar
 (C) Formula bar
 (D) Formatting toolbar


 211. In Excel you can open the scenario Manager dialog box by choosing scenarios from the ….. menu.
 (A) View
 (B) Insert
 (C) Format
 (D) Tools


 212. In Excel you can open the Sort dialog box by choosing Sort from the ….. menu.
 (A) View
 (B) Format
 (C) Tools
 (D) Data


 213. In Excel to edit in an embedded excel worksheet object in a word document.
 (A) Use the excel menu bar and toolbars inside the word application
 (B) Edit the hyperlink
 (C) Edit the data in a excel source application
 (D) Use the word menu bar and toolbars


 214. In Excel to create a formula, you can use.
 (A) Values but not cell references
 (B) Cell references but not values
 (C) Values or cell references although not both at the same time
 (D) Value and cell references


 215. In Excel when working in the page break preview, you can.
 (A) View exactly where each page break occurs
 (B) Add or remove page breaks
 (C) Change the print area
 (D) All of above


 216. In Excel A data map is helpful.
 (A) When you have too much data to chart
 (B) To show a geographic distribution of data
 (C) To compare data points
 (D) To show changes in data over time


 217. In Excel Rounding errors can occur.
 (A) When you use multiplication, division or exponentiation in a formula
 (B) When you use addition and subtraction in a formula
 (C) Because Excel uses hidden decimal places in computation
 (D) When you show the results of formulas with different decimal places than the calculated results 


218. In Excel you can copy data or formulas.
 (A) With the copy, paste and cut commands on the edit menu
 (B) With commands on a shortcut menu
 (C) With buttons on the standard toolbar
 (D) All of the above


 219. In Excel Hyperlinks can be.
 (A) Text
 (B) Drawing objects
 (C) Pictures
 (D) All of above


 220. In Excel to activate the previous cell in a preselected range, press.
 (A) The Alt key
 (B) The Tab key
 (C) The Enter key
 (D) None of the above


 221. In Excel when the formula bar is active, you can see.
 (A) The edit formula button
 (B) The cancel button
 (C) The enter button
 (D) All of the above


 222. To   copy   formatting   from   one   area   in   a worksheet and apply it to another area you would use.
 (A) The Edit>Copy Format and Edit>Paste Format commands form the menu.
 (B) The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu. (C) There   is   no   way   to   copy  and  apply formatting in Excel – You have to do it manually
 (D) The   Format   Painter   button   on   the standard toolbar


 223. In Excel In a worksheet you can select.
 (A) The entire worksheet
 (B) Rows
 (C) Columns
 (D) All of the above


 224. When you link data maintained in an excel workbook to a word document.
 (A) The word document cannot be edit
 (B) The  word  document   contains   a reference to the original source application
 (C) The word document must contain a hyperlink
 (D) The word document contains a copy of the actual data


 225. Which area in an excel window allows entering values and formulas ?
 (A) Title bar
 (B) Menu bar
 (C) Formula bar
 (D) Standard toolbar Answer Sheet

1. (C) 2. (A) 3. (D) 4. (C) 5. (C) 6. (D) 7. (B) 8. (D) 9. (B) 10. (D) 11. (D) 12. (D) 13. (C) 14. (B) 15. (C) 16. (A) 17. (C) 18. (C) 19. (B) 20. (C) 21. (D) 22. (B) 23. (C) 24. (D) 25. (C) 26. (D) 27. (A) 28. (D) 29. (D) 30. (B) 31. (C) 32. (D) 33. (B) 34. (D) 35. (D) 36. (B) 37. (B) 38. (C) 39. (D) 40. (C) 41. (D) 42. (B) 43. (C) 44. (A) 45. (C) 46. (B) 47. (B) 48. (A) 49. (D) 50. (A) 51. (B) 52. (D) 53. (D) 54. (D) 55. (B) 56. (B) 57. (C) 58. (B) 59. (D) 60. (A) 61. (D) 62. (D) 63. (A) 64. (B) 65. (C) 66. (C) 67. (D) 68. (D) 69. (A) 70. (A) 71. (A) 72. (A) 73. (A) 74. (A) 75. (B) 76. (D) 77. (D) 78. (D) 79. (D) 80. (D) 81. (C) 82. (D) 83. (C) 84. (A) 85. (C) 86. (A) 87. (A) 88. (B) 89. (D) 90. (D) 91. (B) 92. (B) 93. (C) 94. (C) 95. (D) 96. (B) 97. (A) 98. (D) 99. (D) 100. (C) 101. (A) 102. (D) 103. (A) 104. (B) 105. (A) 106. (A) 107. (D) 108. (D) 109. (D) 110. (B) 111. (B) 112. (B) 113. (D) 114. (B) 115. (B) 116. (A) 117. (D) 118. (A) 119. (C) 120. (B) 121. (B) 122. (D) 123. (D) 124. (D) 125. (B) 126. (D) 127. (C) 128. (D) 129. (D) 130. (B) 131. (D) 132. (D) 133. ( A) 134. (B) 135. (B) 136. (C) 137. (A) 138. (C) 139. (D) 140. (A) 141. (D) 142. (D) 143. (A) 144. (B) 145. (C) 146. (D) 147. (D) 148. (A) 149. (B) 150. (B) 151. (C) 152. (B) 153. (A) 154. (C) 155. (A) 156. (C) 157. (D) 158. (D) 159. (C) 160. (B) 161. (C) 162. (A) 163. (C) 164. (A) 165. (A) 166. (B) 167. (C) 168. (A) 169. (A) 170. (A) 171. (C) 172. (C) 173. (B) 174. (C) 175. (B) 176. (B) 177. (A) 178. (C) 179. (D) 180. (B) 181. (B) 182. (D) 183. (D) 184. (B) 185. (A) 186. (D) 187. (D) 188. (C) 189. (D) 190. (D) 191. (D) 192. (D) 193. (A) 194. (B) 195. (B) 196. (C) 197. (A) 198. (B) 199. (B) 200. (B) 201. (C) 202. (A) 203. (C) 204. (A) 205. (D) 206. (D) 207. (D) 208. (A) 209. (B) 210. (C) 211. (D) 212. (D) 213. (A) 214. (D) 215. (D) 216. (B) 217. (A) 218. (D) 219. (D) 220. (D) 221. (D) 222. (D) 223. (B) 224. (B) 225. (C)




1. In Microsoft PowerPoint to add a header or footer to your handout, you can use.
 (A) The title master
 (B) The slide master
 (C) The handout master
 (D) All of above


 2. In Microsoft PowerPoint the following will not advance the slides in a slide show view.
 (A) Esc key
 (B) The spacebar
 (C) The Enter key
 (D) The mouse button


 3. In Microsoft PowerPoint to select all of the boxes of an organization chart.
 (A) Clicking and edit and select all
 (B) Right click the chart background and then click select all
 (C) Press and hold the SHIFT key and click each box
 (D) All of above


 4. In Microsoft PowerPoint what are lines, curve, freeform, and scribble
 (A) Emphasis effects that can be applied to animations
 (B) Types of custom motion paths
 (C) Predefined entrance and exit effects
 (D) All of the above


 5. When using PowerPoint, to play a PowerPoint show for previewing the show, select.
 (A) View, slide sorter
 (B) View, slide
 (C) View, slide show
 (D) View outline


 6. In Microsoft PowerPoint in order to see all the slides on one screen use.
 (A) View, slide sorter
 (B) View, slide
 (C) View, master
 (D) View, slide show


 7. In Microsoft PowerPoint  the best place to find animated images for your presentation.
 (A) Microsoft online
 (B) Word clipart
 (C) PowerPoint tools and ins
 (D) All of the above


8. In Microsoft PowerPoint  the easy way to apply varied animations to test on slides.
 (A) Apply effects in the custom animation text pane
 (B) Apply an animation scheme
 (C) Customize bullets with animated clipart
 (D) All of above


 9. In  Microsoft  PowerPoint  using  a  custom animation effect, how do you make text appear on a slide by letter.
 (A) Apply the animation scheme fade in one by one.
 (B) Apply an entrance effect, and then set it to by letter in the effect option dialog box*
 (C) Apply the fly in entrance to the text, and then set its speed to very slow.
 (D) All of above


 10. In Microsoft PowerPoint to exit the PowerPoint application, you should.
 (A) Click the application minimize button
 (B) Click the document close button
 (C) Double click the application control menu icon
 (D) Double click the document control menu icon


 11. In Microsoft PowerPoint you can create a new presentation by completing all of the following except.
 (A) Clicking the new button on the standard toolbar
 (B) Clicking file, new
 (C) Clicking file open
 (D) Pressing Ctrl + N


 12. In     Microsoft     PowerPoint     you    have customized a design template in one presentation and you want to use it in another presentation. What the best way to do this?
 (A) Use the browse feature in the slide design task pane to find the file that has your design template and apply it to the current file.
 (B) Copy and paste the slide with the design template you want to include the new presentation; inserted slide will inherit the design
(C) Save the presentation that has the design template with a new name, and then use a new file to your presentation
 (D) All of the above.


 13. In   Microsoft   PowerPoint     the   following displays when an image is selected.
 (A) Add clip art only if it relates to your topic
 (B) Be sure to place at least one clipart image per slide
 (C) Resize the image so it takes up as much space as your text
 (D) Both (A) and (B)


 14. The Microsoft clip gallery allows you to.
 (A) Add word art images to a slide
 (B) Spell check your presentation
 (C) Add clip art images to a slide or slides
 (D) Add slides to a presentation


 15. In Microsoft PowerPoint the following command select all object at one time when selecting multiple objects to be deleted.
 (A) Alt + A
 (B) Ctrl + A
 (C) Shift + Enter
 (D) Edit, Select All


 16. In Microsoft PowerPoint  to edit the text within the boxes of an organization chart, you.
 (A) Select the box and text, then make changes
 (B) Select the box, then make the dchanges
 (C) Highlight   the   text,   them   make  the changes
 (D) (A) and (B) both


 17. In Microsoft PowerPoint  the following allow you to select more than one slide in a presentation (A) Alt + Click each slide
 (B) Shift + drag each slide
 (C) Shift + Click each slide
 (D) Ctrl + Click each slide


 18. In Microsoft PowerPoint the following options in the printer dialog box would you select to prit slides 5 and 12 in a presentation?
 (A) Slides
 (B) Custom shows
 (C) Current slide
 (D) All of the above


 19. In   Microsoft   PowerPoint   the   following toolbars provides different options in various master views.
 (A) Common tasks toolbar
 (B) Drawing toolbar
 (C) Formatting toolbar
 (D) Standard toolbar



20. In Microsoft PowerPoint you can tell when an object is active because.
 (A) The object is highlighted
 (B) Eight small sizing handles appear surrounding the text
 (C) A box frame appears surrounding the text
 (D) (B) and (C) both


 21. In Microsoft PowerPoint the following is not an option when printing handouts.
 (A) Six slides per page
 (B) Five slides per page
 (C) Three slides per page
 (D) Two slides per page


 22. In Microsoft PowerPoint the best way to design the layout for your slides.
 (A) Create layouts for slides, handouts and notes using the Master Layout dialog box in slide master view
 (B) For each new slide, select a layout from the Slide Layout task pane
 (C) Apply templates from the Slide Design task pane
 (D) None of above


 23. In Microsoft PowerPoint any and every command can be found on the.
 (A) Drawing toolbar
  (B) Formatting toolbar
 (C) Standard toolbar
 (D) Menu bar


 24. In Microsoft PowerPoint slide that is used to introduce a topic and set the tone for the presentation is called the.
 (A) Table slide
 (B) Graph slide
 (C) Bullet slide
 (D) Title slide


 25. In Microsoft PowerPoint the following features should you use when typing in he notes text box (A) Slide shows
 (B) Insert
 (C) Slide master
 (D) Zoom


 26. In Microsoft PowerPoint following should be used when you want to add a slide to an existing presentation
 (A) File, add a new slide
 (B) Insert, new slide
 (C) File, open
 (D) File, new


 27. In Microsoft PowerPoint the following is the default page setup orientation for notes pages, outlines and handouts.
 (A) Vertical
 (B) Landscape
 (C) Portrait
 (D) None of above



28. In Microsoft PowerPoint the following is the default page setup orientation for slides in PowerPoint.
 (A) Vertical
 (B) Landscape
 (C) Portrait
 (D) None of above


 29. In Microsoft PowerPoint are symbols used to identify items in a list.
 (A) Icons
 (B) Markers
 (C) Bullets
 (D) Graphics


 30. In Microsoft PowerPoint toolbars that are displayed by default in the PowerPoint window includes.
 (A) Menu bar, standard toolbar, formatting toolbar, drawing toolbar, status bar
 (B) Menu bar, standard toolbar, formatting toolbar, drawing toolbar, status bar
 (C) Standard toolbar, formatting toolbar, drawing toolbar, status bar
 (D) Menu bar, standard toolbar, status bar, drawing toolbar


 31. In Microsoft PowerPoint view that displays the slides on a presentation as miniature representations of the slides is called.
 (A) Slide show
 (B) Slide sorter view
 (C) Notes page view
 (D) Outline view


 32. In Microsoft PowerPoint view that displays only text (title and bullets) is.
 (A) Slide show
 (B) Slide sorter view
 (C) Notes page view
 (D) Outline view


 33. In Microsoft PowerPoint the entry effect as one slide replaces another in a show is called.
 (A) Animation
 (B) Slide transition
 (C) Custom animation
 (D) Preset animation


 34. In Microsoft PowerPoint  the following presentation elements can you modify using the slide master.
 (A) Slide comments
 (B) Slide transitions
 (C) Speaker note font and color
 (D) All of above


 35. In   Microsoft   PowerPoint    the   following provides a printed copy of your presentation.
 (A) Outline
 (B) Speaker notes
 (C) Audience handouts
 (D) All of the above


36. In Microsoft PowerPoint  slide show options available to the presenter include all of the following except.
 (A) Transitions command
 (B) Speaker notes command
 (C) Meeting reminder command
 (D) Navigation commands


 37. In Microsoft PowerPoint presentation designs regulate the formatting and layout for the slide and are commonly called.
 (A) Design plates
 (B) Templates
 (C) Placeholders
 (D) Blueprints


 38. In Microsoft PowerPoint  the following bypasses the print dialog box when printing individual slides or an entire presentation.
 (A) File, print, preview
 (B) The print button
 (C) File, print
 (D) Ctrl + P


 39. In Microsoft PowerPoint you can show the shortcut menu during the slide show by.
 (A) Clicking the shortcut button on the formatting toolbar
 (B) Right clicking the current slide
 (C) Clicking an icon on the current slide
 (D) (A) and (B) both


 40. In Microsoft PowerPoint auto clipart is a feature that.
 (A) Automatically places clipart in your presentation
 (B) Scans your presentation for incorrect spelling in your words on each slide
 (C) Scans your presentation for incorrect spelling in Word Arts objects
 (D) All of above


 41. Which   file   format   can   be   added   to   a PowerPoint show?
 (A) .jpg
 (B) .giv
 (C) .wav
 (D) All of the above


 42. In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are (A) .wav files and .mid files
 (B) .wav files and .gif files
 (C) .wav files and .jpg files
 (D) .jpg files and .gif files


 43. In   Microsoft   PowerPoint   the  following includes special effects that can be applied to drawing objects.
 (A) Gradient fills
 (B) Line color and style
 (C) Rotating
 (D) All of above


44. In Microsoft PowerPoint the term used when a clip art image changes the direction it faces.
 (A) Group
 (B) Flip
 (C) Rotate
 (D) (A) and (B) both true


 45. In Microsoft PowerPoint  the term used when you press and hold the left mouse key and move the mouse around the slide.
 (A) Highlighting
 (B) Dragging
 (C) Selecting
 (D) (B) and (C) both true


 46. In Microsoft PowerPoint size of a table object
 (A) Is dependent on the amount of text within the table
 (B) Is determined by the presentation design but can be changed
 (C) Is determined by the presentation design and cannot be changed
 (D) (A) and (C) both are true


 47. In    Microsoft     PowerPoint   size   of  an organization chart object.
 (A) Is  determined  by  the  presentation design and cannot be changed
 (B) Is  determined   by   the   presentation design   but   can   be   changed  in PowerPoint
 (C) Is dependent on the amount of text within the organization chart
 (D) Both (A) and (C) are true


 48. In Microsoft PowerPoint  special effects used to introduce slides in a presentation are called.
 (A) Effects
 (B) Custom animations
 (C) Transitions
 (D) Present animations


 49. In Microsoft PowerPoint you can edit an embedded organization chart object by.
 (A) Clicking edit object
 (B) Double clicking the organization chart object
 (C) Right clicking the chart object, then clicking edit MS-Organizaiton Chart object
 (D) (B) and (C) are true 


50. In Microsoft PowerPoint  the term used when you press and hold the left mouse key and more the mouse around the slide.
 (A) Highlighting
 (B) Dragging
 (C) Selecting
 (D) Moving


 51. In Microsoft PowerPoint  the following is not one of PowerPoint’s views.
 (A) Slide show view
 (B) Slide view
 (C) Presentation view
 (D) Outline view


52. In Microsoft PowerPoint the following format options should be used to display dollars on an axis (A) Normal
 (B) Percentage
 (C) Currency
 (D) Comma


 53. In Microsoft PowerPoint to maintain the perspective (height and width ratio) of an object when resizing, you need to.
 (A) Press and hold the shift key while dragging a corner sizing handle
 (B) Press and hold the alt + ctrl keys while dragging a middle handle
 (C) Drag a corner sizing handle
 (D) (A) and (C) both true


 54. In Microsoft PowerPoint the following is/are true about rulers and guides.
 (A) Rulers and guides can be turned on or off
 (B) Rulers and guides print on the slide
 (C) Rulers and guides help place objects on the slide
 (D) (A) and (C) both true


 55. In Microsoft PowerPoint to edit the text within the boxes of an organization chart, you.
 (A) Select the box and text, then make the changes
 (B) Select the box, then make the changes
 (C) Highlight the text, then make the changes
 (D) Highlight the text then make the change


 56. In Microsoft PowerPoint  the following best describes serifs.
 (A) Serifs on characters help to differentiate between similar looking letters
 (B) Serifs fonts are best for viewing test at a distance
 (C) Serifs are fine cross strokes that appear at the bottom and top of a letter
 (D) Serif font are very simple in appearance


 57. In Microsoft PowerPoint the following options changes the fill color of an object back to the default color.
 (A) Template
 (B) Automatic
 (C) Patterns
 (D) Fill colors


 58. In Microsoft PowerPoint  the following  you use to add shading to a drawing object on or an auto shape object.
 (A) Text box tool
 (B) Line tool
 (C) Fill color
 (D) (B) and (C) both true





59. In Microsoft PowerPoint the following tools enable you to add text to a slide without using the standard placeholders.
 (A) Text box tool
 (B) Line tool;
 (C) Fill color
 (D) Auto shapes tool


 60. In Microsoft PowerPoint cell is defined as.
 (A) The intersection of a column and a row
 (B) An input box
 (C) A rectangular marker
 (D) All of the above


 61. In Microsoft PowerPoint the following must be used with the mouse when you want to resize an image from the center and keep it proportioned.
 (A) The space bar
 (B) The alt key
 (C) The ctrl key
 (D) The shift key


 62. In Microsoft PowerPoint the following should be used with the mouse when you want to draw a perfect shape.
 (A) The spacebar
 (B) The alt key
 (C) The ctrl key
 (D) The shift key


 63. In Microsoft PowerPoint on which part of the chart are the values entered in a data sheet displayed.
 (A) The title area
 (B) The legend
 (C) The y-axis
 (D) The x-axis


 64. In Microsoft PowerPoint one way to make a PowerPoint slide display animations is to.
 (A) Select the slide in normal view; and click Format, Animation
 (B) Click the PowerPoint window and move it around vigorously with the mouse for a manual animation effect
 (C) Select the slide in slide sorter view, right click and choose preset animations from the shortcut menu
 (D) PowerPoint does not have an animation feature


 65. In Microsoft PowerPoint the following is not a way to cut ext.
 (A) Select the text and press the delete button
 (B) Select the text and select Edit, Cut from the menu
 (C) Select the text and click the Cut button on the toolbar
 (D) Select the text and press Ctrl + X


 66. In   Microsoft   PowerPoint   which   of   the following can you use to add times to the slides in a presentation
 (A) Slice Show menu
 (B) Rehearse timing button
 (C) Slide transition button
 (D) All of the above


67. In Microsoft PowerPoint  in order to edit a chart, you can.
 (A) Triple click the chart object
 (B) Click and drag the chart object
 (C) Double click the chart object
 (D) Click the chart objects


 68. In Microsoft PowerPoint an image is selected, it displays which of the following?
 (A) Two corner handles
 (B) Six middle handles
 (C) Eight sizing handles
 (D) Six boxes


 69. In Microsoft PowerPoint material consisting of text and numbers is best presented as.
 (A) A table slide
 (B) A bullet slide
 (C) A title slide
 (D) All of the above


 70. In Microsoft PowerPoint is a motion path.
 (A) A type of animation entrance effect
 (B) A method of advancing slides
 (C) A method of moving items on a slide
 (D) All of the above


 71. In Microsoft PowerPoint what is a slide-title master pair?
 (A) The title area and text area of a specific slide
 (B) A slide master and title master merged into a single slide
 (C) A slide master and title master for a specific design template
 (D) All of above


 72. In Microsoft PowerPoint  the following should you use if you want all the slide in the presentation to have the same “look”.
 (A) The slide layout option
 (B) Add a slide option
 (C) Outline view
 (D) A presentation design template


 73. In Microsoft PowerPoint in the context of animations, what is a trigger?
 (A) An action button that advances to the next slide
 (B) An item on the slide that performs an action when clicked
 (C) The name of a motion path
 (D) All of above


 74. In  Microsoft  PowerPoint  if  you  have  a PowerPoint show you created and want to send using email to another teacher you can add the show to your email message as.
 (A) Inclusion
 (B) Attachment
 (C) Reply
 (D) Forward


75. In Microsoft PowerPoint in order to edit a chart, you can.
 (A) Triple click the chart object
 (B) Click and drag the chart object
 (C) Double click the chart object
 (D) Click the chart object


 76. In Microsoft PowerPoint to exit the PowerPoint.
 (A) Click the application minimize button
 (B) Click the document close button
 (C) Double click the applications control menu icon
 (D) Double click the document control menu icon


 77. In Microsoft PowerPoint  to preview a motion path effect using the custom animation task pane, you should.
 (A) Click the play button
 (B) Click the show effect button
 (C) Double click the motion path
 (D) All of above


 78. In Microsoft PowerPoint you can create a new presentation by completing all of the following except.
 (A) Clicking the new button on the standard toolbar
 (B) Clicking file, new
 (C) Clicking file open
 (D) Pressing Ctrl + N


 79. Which of the following will not advance the slides in a slide show view?
 (A) The esc key
 (B) The space bar
 (C) The enter key
 (D) The mouse button


 80. To import text from a word document that uses headings into a PowerPoint presentation:
 (A) This can not be done in PowerPoint
 (B) Click Insert, Slides from Outline
 (C) Click Import, Word Document Headings
 (D) Click File, New, Presentation from Word Headings


 81. Format painter.
 (A) To paint pretty pictures on your slides
 (B) To copy formatting from one object or piece of text and then apply it elsewhere
 (C) To change the background color of your slides
 (D) To paint pretty pictures on background of slides


 82. Slide show options available to the presenter include all of the following except.
 (A) Transitions command
 (B) Speaker notes command
 (C) Meeting minder command
 (D) Navigation commands



83. Which of the following is an example for automatic text formatting.
 (A) Underlining hyperlink
 (B) Adjusting extra space
 (C) Replacing two -’s with an em hyphens
 (D) All of above


 84. Which of the following is not a way to create a new presentation?
 (A) Using the Scan-In Slides feature
 (B) From scratch (create a blank presentation
 (C) Using a template
 (D) Using the auto content wizard


 85. The quickest way to create a PowerPoint presentation is to use the.
 (A) Word for windows templates
 (B) Auto creation wizard
 (C) Auto content wizard
 (D) Presentation wizard


 86. Which of the following toolbars provide different options in various master views?
 (A) Common tasks toolbar
 (B) Drawing toolbar
 (C) Formatting toolbar
 (D) Standard toolbar


 87. How can you create a uniform appearance by adding a background image to all slides?
 (A) Create a template
 (B) Edit the slide master
 (C) Use the autocorrect wizard
 (D) All of the above


 88. How do you create speaker note pages that show the slides, related notes, and your company logo on each page?
 (A) Edit the notes master and add your company logo
 (B) Edit the slide master and insert your company logo and notes pane
 (C) Edit the handout master to include your company logo and one slide per page with additional note space
 (D) All of the above


 89. Which option on the custom animation task pane allows you to apply a preset or custom motion path?
 (A) Add effect
 (B) Emphasis
 (C) Animate now
 (D) All of the above


 90. What is the term used when a clip art image changes the direction of faces?
 (A) Group
 (B) Flip
 (C) Rotate
 (D) All of the above





91. The slide that is used to introduce a topic and set the tone for the presentation is called the.
 (A) Table slide
 (B) Graph slide
 (C) Bullet slide
 (D) Title slide


 92. Which of the following features should you use when typing in the notes text box?
 (A) Slide show
 (B) Insert
 (C) Slide maser
 (D) Zoom


 93. Which option allows you to select line, curve, freeform or scribble tools?
 (A) Create effect
 (B) Insert motion path
 (C) Draw custom path
 (D) All of the above


 94. In Microsoft PowerPoint you can embed a MS-Organization Chart in a slide by.
 (A) Clicking the object command on the edit menu
 (B) Clicking the object command on the edit menu
 (C) Clicking the insert new slide button the standard toolbar, then double click the organization chart button on the formatting toolbar
 (D) Clicking the MS-Organization Chart button on the standard toolbar


 95. In Microsoft PowerPoint to select one hyperlink after another during a slide presentation, what do you press?
 (A) Tab
 (B) Ctrl + K
 (C) Ctrl + h
 (D) All of above


 96. In Microsoft PowerPoint which application view works best for adding slide transitions?
(A) Slide show view
(B) Slide sorter view
(C) Slide view
(D) Notes view


 97. Which of the following views is the best view to use when setting transition effects for all slides in a presentation ?
 (A) Slide sorter view
 (B) Notes page view
 (C) Slide view
 (D) Outline view


 98. 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


 99. Which of the following should be used when you  want  to  add  a  slide  to  an  existing presentation?
 (A) File, add a new slide
 (B) Insert, New slide
 (C) File Open
 (D) File, New


100. Which of the following tool enables you to add text to a slide without using the standard placeholders?
 (A) Text tool box
 (B) Line tool
 (C) Drawing tool
 (D) Auto shapes tool


 101. Want your logo in the same position on every slide, automatically. Insert it on the.
 (A) Handout master
 (B) Notes master
 (C) Slide master
 (D) All of the above


 102. Which of the following views is the best view to use when setting transition effects for all slides in a presentation?
 (A) Slide sorter view
 (B) Notes pages view
 (C) Slide view
 (D) Outline view


 103. Objects on the slide that hold text are called.
 (A) Placeholders
 (B) Object holders
 (C) Auto layouts
 (D) Text holders


 104. Which of the following provides a means of printing out feature notes with a miniature slide on a printed page?
 (A) Slide with animation
 (B) Outline view
 (C) Notes page
 (D) Audience handout


 105. Which command brings you to the first slide in your presentation?
 (A) Next slide button
 (B) Page up
 (C) Ctrl + Home
 (D) Ctrl + End


 106. In normal view, how can you quickly change to handout master view?
 (A) Click the outline tab and select handout master view
 (B) Press the shift key and click the handout master view button
 (C) On the view menu, click slide sorter, and click handouts.
 (D) All of above


 107. How can you quickly reinstate a deleted footer placeholder in master view?
 (A) Create a new slide master
 (B) Re-apply the footer placeholder
 (C) Re-apply the slide layout
 (D) All of the above


 108. Which of the following can you use to add times to the slides in a presentation?
 (A) Slide show menu
 (B) Rehearse timings button
 (C) Slide transition button
 (D) All of the above


 109. Objects on the slide that hold text are called.
 (A) Placeholders
 (B) Object holders
 (C) Auto layout
 (D) Text holders


110. You have got a bunch of digital holiday photo you want to put into a slide show. What the quickest method?
 (A) Apply a multiple-picture layout to several slides, and use the clipart icon on the slides to import your picture
 (B) On the insert menu, point to the picture, click from file, and select your picture in a group for each slide
 (C) On the insert menu, point the picture and click new photo album
 (D) All of the above


 111. In Microsoft PowerPoint Line spacing refers to.
 (A) The space between the lines of text
 (B) The height of the line
 (C) The length of the line
 (D) (A) and (C) both


 112. In Microsoft PowerPoint which of the following uses the spelling and grammar feature to indicate an incorrect spelling?
 (A) The incorrect word appears in all capital letters
 (B) The incorrect word has a wavy red line under it
 (C) The incorrect word appears italicized
 (D) The incorrect word appears bold


 113. In Microsoft PowerPoint in Microsoft PowerPoint which of the following bypasses the print dialog box when printing individual slides or an entire presentation?
 (A) File, Print Preview
 (B) The print button
 (C) File, print
 (D) Ctrl + P


 114. In Microsoft PowerPoint how do you add degrees of transparency to shapes such as arrows, so that the slide background shows though?
 (A) Use #D style 4 button on the drawing toolbar
 (B) Use the Set Transparent Color button on the Picture toolbar
 (C) Use the Transparency slider in the Format AutoShapes dialog box
 (D) All of above


 115. In Microsoft PowerPoint material consisting of text and numbers is best presented as.
 (A) A table slide
 (B) A bullet slide
 (C) A title slide
 (D) All of above


 116. In Microsoft PowerPoint   auto clip art is a feature that.
 (A) Automatically places clip art in your presentation
 (B) Scans your presentation for incorrect spelling of words on each slide

(C) Scans your presentation for incorrect spelling in word art objects
(D) All of the above


 117. In Microsoft PowerPoint to select all the boxes of an organization chart.
 (A) Click edit, select all
 (B) Right click the chart background click select all
 (C) Press and hold the shift key and click each box
 (D) All of the above


 118. In Microsoft PowerPoint to adjust the width of table columns, you.
 (A) Click table menu. Column width, then make adjustments
 (B) Drag the vertical gridline between two columns
 (C) Drag the column markers on the table ruler bar
 (D) Both (B) and (C)


 119. In Microsoft PowerPoint   to add a new row to a table you would.
 (A) Click the insert rows command on the insert menu
 (B) Press the enter key
 (C) Click the insert rows button on the standard toolbar
 (D) None of the above


 120. In Microsoft PowerPoint after moving a clip art image to a particular location on the slide, you can immediately reverse the action using the.
 (A) Click the not do move object command on the edit menu
 (B) Click on the undo button
 (C) Click on redo button
 (D) All of above


 121. In Microsoft PowerPoint you can edit an embedded organization chart object by.
 (A) Clicking the edit object
 (B) Double clicking the organization chart object
 (C) Right clicking the chart object, then clicking edit MS-Organization Chart object
 (D) (B) and (C) both are true


 122. You edit an embedded table object by.
 (A) Clicking the edit sub command of the document object command on the edit menu
 (B) Double clicking the table object
 (C) Right clicking the table object, then clicking edit document on the edit menu
 (D) All of above



123. In Microsoft PowerPoint you can embed a Microsoft Word tale in a slide by.
 (A) Clicking the insert new slide button on the standard toolbar, then double clicking table
 (B) Clicking the insert Microsoft word table button on the formatting toolbar
 (C) Clicking the insert Microsoft word table button on the standard toolbar
 (D) Both (A) and (C)


 124. In Microsoft PowerPoint  you can embed a organization chart in a slide by.
 (A) Clicking the object command on the edit menu
 (B) Clicking the insert new slide button on the standard toolbar, then double clicking the organization chart auto layout
 (C) Clicking the ms organization chart button on the formatting toolbar
 (D) Clicking   the   ms   organization   chart button on the standard toolbar


 125. In Microsoft PowerPoint you can add multiple subordinates to a position by.
 (A) Clicking the subordinate button as you press and hold shift
 (B) Clicking the subordinate button each and every time you add a subordinate
 (C) Clicking the subordinate button as many times as the desired boxes
 (D) All of above



 126. How would you create the following diagram in PowerPoint.
 (A) Use auto shapes and the drawing toolbar to create the diagram and design it
 (B) Open   the   diagram   gallery   from   the drawing   toolbar   and   choose   this diagram type
 (C) Use the chart command on the insert menu to import the diagram
 (D) All of above



 127. Which of the following provides a means of printing out features notes with a miniature slide on a printed page?
 (A) Slides with animation
 (B) Outline view
 (C) Notes page
 (D) Audience handout


 128. Which command brings you to the first slide in your presentation?
 (A) Next slide button
 (B) Page up
 (C) Ctrl + home
 (D) Ctrl + end


129. In Microsoft PowerPoint you were giving your presentation, and you need to click a slide that’s few slides back. How do you get there?
 (A) Press ESC to get back into a normal view; click the slide thumbnail in normal view; then click the resume slide show button
 (B) Press backspace until your desired slide
 (C) Right click, point to go on the shortcut menu, point to by title, and click the slide you want to go to
 (D) All of above


 130. In Microsoft PowerPoint which of the following should you do to bring a bullet back to a previous level?
 (A) Press the shift + tab keys
 (B) Press the shift key
 (C) Press the enter key
 (D) Press the tab key


 131. In   Microsoft   PowerPoint   good   design determines.
 (A) Credibility
 (B) Readability
 (C) First impression
 (D) All of above


 132. In Microsoft PowerPoint your presentation is ready to go, but you don’t know if PowerPoint is installed on the computer, you will use to present with what’s the safe way.
 (A) Save your presentation as a web page
 (B) Set up your presentation to be ”browse as a kiosk”
 (C) Use the Pack and Go wizard
 (D) All of the above


 133. In Microsoft PowerPoint  view that displays the slides of a presentation as miniature representations of the slides is called.
 (A) Slide show
 (B) Slide sorter view
 (C) Notes page view
 (D) Outline view


 134. In Microsoft PowerPoint  view that displays only text (title and bullets) is.
 (A) Slide show
 (B) Slide sorter view
 (C) Notes page view
 (D) Outline view


 135. In   Microsoft   PowerPoint   the   following provides a printed copy of your presentation.
 (A) Outlines
 (B) Speaker notes
 (C) Audience handouts
 (D) All of above


 136. In Microsoft PowerPoint presentation designs regulate the formatting and layout for the slide and are commonly called.
 (A) Design templates
 (B) Templates
 (C) Placeholders
 (D) Blueprints


137. In Microsoft PowerPoint  the following should you use if you want all the slides in the presentation to have the same look.
 (A) The slid layout option
 (B) The add a slide option
 (C) Outline view
 (D) A presentation design template


 138. In Microsoft PowerPoint the key deletes text before, or the left of, the insertion point.
 (A) Backspace
 (B) Page up
 (C) Delete
 (D) Page down


 139. Which of the following is not a transition effect?
 (A) Blinks diagonal
 (B) Dissolve
 (C) Fade through black
 (D) Blinds vertical


 140. In Microsoft PowerPoint to create a PowerPoint presentation from a template.
 (A) Click File, New, select the presentations tab and choose a template
 (B) Click File, New Template and choose a template
 (C) Import a presentation template from PowerPoint’s template wizard
 (D) Click Create Template from scratch, Now


 141. In Microsoft PowerPoint to save a presentation you.
 (A) click save on the windows start button
 (B) press Ctrl + F5
 (C) select File, Save from the menu
 (D) click the saver button on the formatting toolbar


 142. In Microsoft PowerPoint to change font size of a selected slide title, you.
 (A) Click the toolbars font dropdown arrow and choose the font you prefer
 (B) Click format, title and choose a font from the font tab
 (C) Click the toolbar’s increase font size button
 (D) Click title, new font, ok.


 143. In Microsoft PowerPoint  to change font size of a selected slide title, you.
 (A) Click the toolbars Font dropdown arrow and choose the font you prefer
 (B) Click Format, Title and choose a font from the font tab
 (C) Click the toolbar’s Increase Font Size button
 (D) Click Title, New Font, OK




144. In Microsoft PowerPoint you can show the shortcut menu during the slide show by.
 (A) Clicking the shortcut button in the formatting toolbar
 (B) Right clicking the current slide
 (C) Clicking an icon on the current slide
 (D) A and b


 145. In Microsoft PowerPoint  to insert a new slide in the current presentation, we can choose.
 (A) Ctrl + M
 (B) Ctrl + N
 (C) Ctrl + O
 (D) Ctrl + F


 146. Microsoft PowerPoint is a.
 (A) Database program
 (B) Spreadsheet program
 (C) Presentation program
 (D) Word processing program


 147. In Microsoft PowerPoint  the name of the form used to input chart values.
 (A) Datasheet
 (B) Microsoft Excel
 (C) Microsoft graph
 (D) Auto form


 148. In Microsoft PowerPoint  Right clicking something in PowerPoint.
 (A) Deletes the object
 (B) Selects the object
 (C) Opens a shortcut menu listing for the object
 (D) Nothing he right mouse button for operation


 149. In Microsoft PowerPoint after choosing a predefine template, …………. option has to be chosen to change a background color.
 (A) Design template
 (B) Color scheme
 (C) Animation scheme
 (D) Color effects


 150. In Microsoft PowerPoint ellipse Motion is a predefined.
 (A) Design template
 (B) Color scheme
 (C) Animation scheme
 (D) None of these


 151. In Microsoft PowerPoint 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


 152. In Microsoft PowerPoint  special effects used to introduce slides in a presentation are called.
 (A) Effects
 (B) Custom animations
 (C) Transitions
 (D) Preset animations


 153. In Microsoft PowerPoint the key on the keyboard can be used to view slide show.
 (A) F1
 (B) F2
 (C) F5
 (D) F10




154. In Microsoft PowerPoint it  is the name of the form used to input chart values.
 (A) Datasheet
 (B) Microsoft Excel
 (C) Microsoft graph
 (D) Auto form


 155. Which of the following you must first complete in order to delete an object?
 (A) Double click the image
 (B) Select the image
 (C) Resize the image
 (D) Move the image to a new location


 156. In Microsoft PowerPoint the term used to describe the separation of a clip art object into different parts so that it becomes a PowerPoint object.
 (A) Embedding
 (B) Regrouping
 (C) Ungrouping
 (D) Grouping


 157. In Microsoft PowerPoint auto shapes tool provides you with.
 (A) Fancy text to place on your slide
 (B) usually found shapes
 (C) Any shape you want to add on a slide
 (D) Clip art that is related to your presentation


 158. In Microsoft PowerPoint the following should be used when you want to add a slide to an existing presentation.
 (A) File, add a new slide
 (B) Insert, new slide
 (C) File, open
 (D) File, new


 159. An  organization  has  a  president,  vice president, managers and supervisors. On what level of an organization chart are the vice presidents.
 (A) Fourth level
 (B) Third level
 (C) Second level
 (D) First level


 160. In Microsoft PowerPoint press animation effects allows you to.
 (A) Add clip art images to your slides
 (B) Create a custom transition to the nect slide
 (C) Show bullet items as they are discussed
 (D) None of above


 161. In Microsoft PowerPoint the following features allows you to view slides in a slide show without manually advancing each slide.
 (A) Adding build effects
 (B) Setting slide times
 (C) Adding transitions
 (D) All of these


162. In Microsoft PowerPoint Animation schemes can be applied to ….. in the presentation.
 (A) All slides
 (B) Select slides
 (C) Current slide
 (D) All of the above


 163. In Microsoft PowerPoint  the following feature allows you to select more than one slide in slide sorter view.
 (A) Alt + Click each slide
 (B) Shift + drag each slide
 (C) Shift + Click each slide
 (D) Ctrl + Click each slide


 164. In Microsoft PowerPoint one thing the common tasks button allows you to do is.
 (A) Apply a design template to a slide
 (B) Insert a new slide
 (C) Choose a new layout for a slide
 (D) All of above


 165. In Microsoft PowerPoint file which contains readymade styles that can be used for a presentations is called.
 (A) Auto style
 (B) Template
 (C) Wizard
 (D) Pre-formatting


 166. In Microsoft PowerPoint  the following fill effects can you use for the slide background.
 (A) Gradient
 (B) Texture
 (C) Picture
 (D) All of the above


 167. In Microsoft PowerPoint  the following statements is not true.
 (A) Holding down the Shift key while you draw an object creates perfect squares, circles and straight lines
 (B) The text in a text box can’t be formatted
 (C) The drawing toolbar contains tools for drawing shapes, lines, arrows, and more
 (D) Ctrl + S save the document


 168. In Microsoft PowerPoint chart can be put as a part of the presentation using.
 (A) Insert -> Chart
 (B) Insert -> Pictures -> Chart
 (C) Edit -> Chart
 (D) View -> Chart


 169. The arrangement of elements such as Title and Subtitle text, pictures, tables etc. is called.
 (A) Layout
 (B) Presentation
 (C) Design
 (D) Scheme


 170. In Microsoft PowerPoint the following are types of sound files.
 (A) LOG files
 (B) DAT files
 (C) WAV files
 (D) DRV files


171. In Microsoft PowerPoint the following can you use to add times to the slides in a presentation (A) Microsoft graph
(B) Microsoft Table
(C) Microsoft Excel
(D) Microsoft Word


 172. In Microsoft PowerPoint  view  can be used to enter speaker comments.
 (A) Normal
 (B) Slide show
 (C) Slide sorter
 (D) Notes page view


 173. In Microsoft PowerPoint  best way to insert a new slide in a presentation is to use the.
 (A) Normal view
 (B) Special view
 (C) Slide show view
 (D) Slide sorter view


 174. In Microsoft PowerPoint the best view for getting your thoughts for a presentation out on the computer
 (A) Outline view
  (B) Notes page view
 (C) Slide sorter view
 (D) Slide view


 175. In Microsoft PowerPoint boxes that are displayed to indicate that the text, pictures or objects are placed in it is called.
 (A) Placeholder
 (B) Auto text
 (C) Text box
 (D) Word art


 176. In Microsoft PowerPoint the following is not a feature of PowerPoint.
 (A) Printing transparencies
 (B) Printing the speaker’s notes along with slide images
 (C) Linking a slide transition with a laser pointer
 (D) Drawing with a pen


 177. In Microsoft PowerPoint the  option can be used to create a new slide show with the current slides but presented in a different order.
 (A) Rehearsal
 (B) Custom slider show
 (C) Slide show setup
 (D) Slide show view


 178. In Microsoft PowerPoint the following are actions you can assign to an action button or slide object.
 (A) Run a macro
 (B) Play a sound
 (C) Hyper link
 (D) All of above


 179. Which option in PowerPoint allows to carry slides from one computer to another?
 (A) Save As
 (B) Save and Go
 (C) Pack and Go
 (D) Web and Go


180. In Microsoft PowerPoint the handout master contains placeholders fro all of the following except.
 (A) Slide number
 (B) Title
 (C) Footer
 (D) Header


Answer Sheet

1. (C) 2. (A) 3. (D) 4. (B) 5. (C) 6. (A) 7. (B) 8. (B) 9. (B) 10. (C) 11. (C) 12. (A) 13. (D) 14. (C) 15. (D) 16. (A) 17. (C) 18. (A) 19. (A) 20. (A) 21. (B) 22. (B) 23. (D) 24. (D) 25. (D) 26. (B) 27. (C) 28. (B) 29. (C) 30. (B) 31. (B) 32. (D) 33. (B) 34. (B) 35. (C) 36. (A) 37. (B) 38. (D) 39. (B) 40. (D) 41. (D) 42. (A) 43. (D) 44. (D) 45. (D) 46. (B) 47. (D) 48. (C) 49. (D) 50. (B) 51. (C) 52. (C) 53. (A) 54. (D) 55. (A) 56. (C) 57. (B) 58. (D) 59. (A) 60. (A) 61. (C) 62. (D) 63. (C) 64. (C) 65. (A) 66. (B) 67. (C) 68. (C) 69. (A) 70. (C) 71. (C) 72. (D) 73. (B) 74. (B) 75. (C) 76. (C) 77. (A) 78. (C) 79. (A) 80. (B) 81. (B) 82. (A) 83. (D) 84. (A) 85. (C) 86. (A) 87. (B) 88. (A) 89. (B) 90. (C) 91. (D) 92. (D) 93. (C) 94. (B) 95. (B) 96. (B) 97. (A) 98. (C) 99. (B) 100. (C) 101. (C) 102. (A) 103. (A) 104. (D) 105. (C) 106. (B) 107. (B) 108. (B) 109. (A) 110. (A) 111. (D) 112. (B) 113. (B) 114. (C) 115. (A) 116. (D) 117. (D) 118. (D) 119. (D) 120. (B) 121. (D) 122. (D) 123. (D) 124. (B) 125. (D) 126. (B) 127. (D) 128. (C) 129. (C) 130. (A) 131. (D) 132. (C) 133. (B) 134. (D) 135. (C) 136. (B) 137. (D) 138. (A) 139. (A) 140. (A) 141. (C) 142. (C) 143. (C) 144. (B) 145. (A) 146. (C) 147. (A) 148. (C) 149. (B) 150. (C) 151. (D) 152. (C) 153. (C) 154. (A) 155. (B) 156. (C) 157. (B) 158. (B) 159. (C) 160. (C) 161. (B) 162. (D) 163. (C) 164. (D) 165. (B) 166. (D) 167. (B) 168. (B) 169. (A) 170. (C) 171. (A) 172. (D) 173. (D) 174. (A) 175. (A)176. (C) 177. (B) 178. (D) 179. (B) 180. (B)



2. In Access to open an existing database press.
 (A) CTRL+N
 (B) CTRL+O
 (C) ALT+F4
 (D) None of these


 3. In Access, to Exit Office Access 2007Access,
 (A) CTRL+N
 (B) CTRL+O
 (C) ALT+F4
 (D) None of these


 4. In Access press CTRL+N to.
 (A) Open a new database
 (B) Open an existing database
 (C) Exit Office Access 2007Access
 (D) None of these


 5. In Access press CTRL+O to (A) Open a new database.
 (B) Open an existing database
 (C) Exit Office Access 2007Access
 (D) None of these


 6. In Access press ALT+F4 to.
 (A) Open a new database
 (B) Open an existing database
 (C) Exit Office Access 2007Access
 (D) None of these


 7. Press the following keys in Access to  Print the current or selected object.
 (A) CTRL+P
 (B) P or CTRL+P
 (C) S
 (D) C or ESC


 8. Press the following keys in Access to  Open the Print dialog box from Print Preview.
 (A) CTRL+P
 (B) P or CTRL+P
 (C) S
 (D) C or ESC


 9. Press the following keys in Access to  Open the Page Setup dialog box from Print Preview.
 (A) CTRL+P
 (B) P or CTRL+P
 (C) S
 (D) C or ESC


 10. Press the following keys in Access to  Cancel Print Preview or Layout Preview.
 (A) CTRL+P
 (B) P or CTRL+P
 (C) S
 (D) C or ESC




11. Press the following keys in Access to Save a database object.
 (A) CTRL+P
 (B) P or CTRL+P
 (C) CTRL+S or SHIFT+F12
 (D) F12


 12. Press the following keys in Access to Open the Save As dialog box.
 (A) CTRL+P
 (B) P or CTRL+P
 (C) CTRL+S or SHIFT+F12
 (D) F12


 13. In Access to Open a combo box.
 (A) F4 or ALT+DOWN ARROW
 (B) DOWN ARROW
 (C) PAGE DOWN
 (D) F9


 14. In Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.) list box or combo box.
 (A) F4 or ALT+DOWN ARROW
 (B) DOWN ARROW
 (C) PAGE DOWN
 (D) F9


 15. In Access to Move down one page.
 (A) F4 or ALT+DOWN ARROW
 (B) DOWN ARROW
 (C) PAGE DOWN
 (D) F9


 16. When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters.
 (A) Report
 (B) Table
 (C) Query
 (D) Tools


 17. In Access to Move down one line.
 (A) F4 or ALT+DOWN ARROW
 (B) DOWN ARROW
 (C) PAGE DOWN
 (D) F9





18. In Access press…………………….to Move the selected control to the left (except controls that are part of a layout)
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 19. In Access press …………………….to Move the selected control to the right (except controls that are part of a layout)
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 20. In Access press …………………….to Paste the contents of the Clipboard in the upperleft corner of the selected section.
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 21. In Access press …………………….to Cut the selected control and copy it to the Clipboard.
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 22. In Access press …………………….to Copy the selected control to the Clipboard.
 (A) CTRL+C
 (B) CTRL+X
 (C) CTRL+V
 (D) None of these


 23. In Access press  RIGHT ARROW or CTRL+RIGHT ARROW.
 (A) Move the selected control to the right (except controls that are part of a layout)
 (B) Move the selected control to the left (except controls that are part of a layout)
 (C) Move the selected control up
 (D) None of these


 24. In Access press  LEFT ARROW or CTRL+LEFT ARROW.
 (A) Move the selected control to the right (except controls that are part of a layout)
 (B) Move the selected control to the left (except controls that are part of a layout)
 (C) Move the selected control up
 (D) None of these


 25. In Access press ALT+F11 to.
 (A) Display the Control menu
 (B) Display the shortcut menu
 (C) Close the active window
 (D) None of these


 26. In Access press ALT+F11 to.
 (A) Display the Control menu
 (B) Display the shortcut menu
 (C) Close the active window
 (D) Switch between the Visual Basic Editor and the previous active window


27. In Access press to Toggle the focus forward between controls in the wizard.
 (A) TAB
 (B) ALT+N
 (C) ALT+B
 (D) ALT+F


 28. In access press to Move to the next page of the wizard.
 (A) TAB
 (B) ALT+N
 (C) ALT+B
 (D) ALT+F


 29. In Access press  UP ARROW to.
 (A) Move up one line
 (B) Move up one page
 (C) Exit the combo box or list box
 (D) None of these


 30. In Access press  PAGE UP.
 (A) Move up one line
 (B) Move up one page
 (C) Exit the combo box or list box
 (D) None of these


 31. In Access press  TAB.
 (A) Move up one line
 (B) Move up one page
 (C) Exit the combo box or list box
 (D) None of these


 32. In Access to find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only).
 (A) CTRL+F
 (B) CTRL+H
 (C) SHIFT+F4
 (D) None of these


 33. In Access to open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only.)
 (A) CTRL+F
 (B) CTRL+H
 (C) SHIFT+F4
 (D) None of these


 34. In Access to open the Replace tab in the Find and Replace dialog box (Datasheet view and Form view only).
 (A) CTRL+F
 (B) CTRL+H
 (C) SHIFT+F4
 (D) None of these


 35. In  Access to switch between Edit mode (with insertion point displaye(D).
 (A) F2
 (B) F4
 (C) F5
 (D) F6


 36. In  Access to switch to the property sheet (Design view in forms and reports in both Access databases and Access projects).
 (A) F2
 (B) F4
 (C) F5
 (D) F6




37. In  Access to switch between the upper and lower portions of a window (Design view of queries, and the Advanced Filter/Sort window).
 (A) F2
 (B) F4
 (C) F5
 (D) F6


 38. In  Access to switch to Form view from form Design view.
 (A) F2
 (B) F4
 (C) F5
 (D) F6


 39. In Access press to Cycle through the field grid, field properties, Navigation Pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables).
 (A) F6
 (B) F7
 (C) F8
 (D) None of these


 40. In Access press to Open the Choose Builder dialog box (Design view window of forms and reports).
 (A) F6
 (B) F7
 (C) F8
 (D) None of these


 41. In Access press to Open the Visual Basic Editor from a selected property in the property sheet for a form or report.
 (A) F6
 (B) F7
 (C) F8
 (D) None of these


 42. In Access press to Switch from the Visual Basic Editor back to form or report Design view.
 (A) F6
 (B) F7
 (C) F8
 (D) None of these


 43. Switch from the Visual Basic Editor back to form or report Design view in Access press.
 (A) ALT+F11
 (B) SHIFT+F7
 (C) A and B both are true
 (D) None is true


 44. In Access press to Move to the previous page of the wizard.
 (A) TAB
 (B) ALT+N
 (C) ALT+B
 (D) ALT+F


 45. In Access press to Complete the wizard.
 (A) TAB
 (B) ALT+N
 (C) ALT+B
 (D) ALT+F


 46. In Access press  UP ARROW or CTRL+UP ARROW.
 (A) Move the selected control to the right (except controls that are part of a layout)
 (B) Move the selected control to the left (except controls that are part of a layout)
 (C) Move the selected control up
 (D) None of these


47. In  Access  press  DOWN ARROW or CTRL+ DOWN ARROW.
 (A) Move the selected control to the right (except controls that are part of a layout)
 (B) Move the selected control to the left (except controls that are part of a layout)
 (C) Move the selected control up
 (D) None of these


 48. In Access to Increase the height of the selected control.
 (A) SHIFT+RIGHT ARROW
 (B) SHIFT+DOWN ARROW
 (C) DOWN ARROW or CTRL+DOWN ARROW
 (D) None of these


 49. In Access press F11 to.
 (A) Toggle the Navigation Pane
 (B) Cycle between open windows
 (C) Restore the selected minimized window when all windows are minimized
 (D) Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window


 50. In Access press CTRL+F6 to.
 (A) Toggle the Navigation Pane
 (B) Cycle between open windows
 (C) Restore the selected minimized window when all windows are minimized
 (D) Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window


 51. In Access press ENTER to.
 (A) Toggle the Navigation Pane
 (B) Cycle between open windows
 (C) Restore the selected minimized window when all windows are minimized
 (D) Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window


 52. In Access press CTRL+F8 to.
 (A) Toggle the Navigation Pane
 (B) Cycle between open windows
 (C) Restore the selected minimized window when all windows are minimized
 (D) Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window


 53. In Access press ALT+SPACEBAR to.
 (A) Display the Control menu
 (B) Display the shortcut menu
 (C) Close the active window
 (D) None of these


54. In Access press SHIFT+F10 to.
 (A) Display the Control menu
 (B) Display the shortcut menu
 (C) Close the active window
 (D) None of these


 55. In Access press CTRL+W or CTRL+F4 to.
 (A) Display the Control menu
 (B) Display the shortcut menu
 (C) Close the active window
 (D) None of these


 56. In Access to reduce the height of the selected control.
 (A) SHIFT+RIGHT ARROW
 (B) SHIFT+DOWN ARROW
 (C) DOWN ARROW or CTRL+DOWN ARROW
 (D) None of these


 57. In Access  to  increase  the  width  of  the selected control.
 (A) SHIFT+RIGHT ARROW
 (B) SHIFT+DOWN ARROW
 (C) DOWN ARROW or CTRL+DOWN ARROW
 (D) None of these


 58. In Access to move the selected control down.
 (A) SHIFT+RIGHT ARROW
 (B) SHIFT+DOWN ARROW
 (C) DOWN ARROW or CTRL+DOWN ARROW
 (D) None of these 


59. A-  Press DOWN ARROW or CTRL+DOWN ARROW , B- Press SHIFT+LEFT ARROW: 1Move the selected control down, 2- Reduce the width of the selected control.
 (A) A-1, B-2
 (B) A-2, B-2
 (C) A-1, B-1
 (D) A-2, B-1


 60. According to Access Help, what’s a good way to design a database?
 (A) Start from data access pages and work backward
 (B) Sketch the design of your database using a pencil and paper
 (C) Use the Table Analyzer to reverseengineer your flat source data.
 (D) None of above


 61. Which editor was provided for use with Access Basic?
 (A) The Visual Basic 1.0 editor
 (B) Notepad
 (C) The QuickBasic editor
 (D) All of above


62. You add a table to the query design window.
 (A) Select Edit>Add Table from the menu
 (B) Select Tools>Add table from the menu
 (C) Click the Show Table button on the toolbar
 (D) Select the table from the Table list on the toolbar


 63. Which of the following type s of queries are action queries?
 (A) Update queries.
 (B) Crosstab Queries
 (C) Parameter queries
 (D) Append Queries


 64. A query prompts a user for a data and then displays only records that contain the specified date. The  type of of query is thi.
s (A) A parameter query
 (B) A crosstab query
 (C) An update query
 (D) An action query


 65. Which of the following is NOT a report section?
 (A) Report Header section
 (B) Summary section
 (C) Page header section
 (D) Details section


 66. You can display a database object in design view by.
 (A) Opening the database object and clicking the view button on the toolbar
 (B) Selecting the database object and clicking the design button on the database window
 (C) Selecting the database object and press Ctrl + V
 (D) Opening the database object and selecting Tools>Design view


 67. How can you display the relationship in a database?
 (A) Select View > Relationship form the menu
 (B) Click the Relationship button on the toolbar
 (C) Select Edit >Relationship from the menu
 (D) All the above are true


 68. If you are creating a cross tab query, what must table you are querying contain?
 (A) Lots of confusing information
 (B) More than 100 records
 (C) At least one field
 (D) None of the above


69. A query summarizes information in a grid, organized by regions and months. Which type of query is this?
 (A) A cross tab query
 (B) An update query
 (C) A parameter query
 (D) An action query


 70. What type of text box does the toolbox and to a form?
 (A) Unbound
 (B) Bound
 (C) Rebound
 (D) Calculated


 71. The filter by selection feature allows you to filter.
 (A) Those records that match an entity in a field
 (B) Records  based  on  a  criterion  you specify
 (C) Records that meet any of several criteria you specify
 (D) All of above


 72. What is the memo data type field used for?
 (A) To add table
 (B) To   store   objects   created   in  other programs
 (C) For long text entries
 (D) For shout text entries of no more than


 255 characters 73. What is the purpose of the description column in Table Design View?
 (A) To define the data type applied to each field within the table
 (B) To describe the data that should be entered in each field
 (C) To enter lookup data that the field should refer to
.(D) None of the above


 74. What is the propose to a sub datasheet?
 (A) To provide a hierarchial view of related tables or queries in a single window
 (B) To display grouped data in a report
 (C) To display summarized data.
 (D) All of the above


 75. Which  of  the  following  is  not  a  selection technique ?
 (A) To select a word, double click the word
 (B) To select an entire table click the empty bosx to the left of the field names
 (C) To select a row, click the record selector box to the left of the row
 (D) To   select   a   column,   double  click anywhere in the column


76. How can you display Pivot Table report summary data in a currency format?
 (A) Use custom calculation
 (B) Type in the currency symbol
 (C) Modify the field settings
 (D) None of the above


 77. What method can you use to add a new table to your database?
 (A) Use Design View to create a table
 (B) Enter data directly by using a datasheet
 (C) Both of above
 (D) All of the above


 78. Which action do you use in a a macro to automatically send a report snapshot in an email message?
 (A) Use mail
 (B) Send object
 (C) Run macro
 (D) All of the above


 79. How can you display sales grouped by country, region, and salesperson, all at the same time?
 (A) Use the Sort Descending command.
 (B) Use the Pivot table view command
 (C) Use the find command on specified groups
 (D) All of above


 80. The checking operation performed on input data is called the.
 (A) Validation of data
 (B) Verification of data
 (C) Cross check
 (D) Control of data


 81. A form defines.
 (A) Where data is placed on the screen
 (B) The width of each field
 (C) Both (A) and (B)
 (D) All of the above


 82. The following method  you can  use to add a new table to your database.
 (A) Use Design View to create a table
 (B) Enter data directly by using a datasheet
 (C) Both of above
 (D) All of the above


 83. The following you can use in a macro to automatically send a report snapshot in an email message.
 (A) Use mail
 (B) Send object
 (C) Run macro
 (D) All of the above


 84. To display sales grouped by country, region, and salesperson, all at the same time.
 (A) Use the Sort Descending command.
 (B) Use the Pivot table view command
 (C) Use the find command on specified groups
 (D) All of above


85. The   checking   operation   performed   on input data is called the.
 (A) Validation of data
 (B) Verification of data 
 (C) Cross check
 (D) Control of data


 86. A form defines.
 (A) Where data is placed on the screen
 (B) The width of each field
 (C) Both (A) and (B)
 (D) All of the above


 87. To  insert a graphic of your company’s logo on a report.
 (A) Click the image button on the toolbox and drag on the report to draw a place holder for the graphics
 (B) You can’t. Microsoft Access won’t let you insert graphics files.
 (C) Select Insert > Picture from the menu
 (D) Select Tools > Insert Picture from the menu


 88. The Fill/Back Color button on the formatting toolbar applies color to:
 (A) The border fo the selected control
 (B) The text in the selected control
 (C) All aspects of the control
 (D) The background of the selected control


 89. The  type of query extract the data and put them into separate table.
 (A) A parameter query
 (B) A make-table query
 (C) An update query
 (D) A crosstab query


 90. The following criterion is NOT written using the proper syntax?
 (A) “Haris”
 (B) <500
 (C) NO VALUE
 (D) Between #1/1/2000# and #12/31/2000#


 91. (IF [Age]>65, “Senior”,”Adult”) This expression is an example of:
 (A) A conditional expression
 (B) Algebraic expression
 (C) Something that belongs in a Microsoft Excel book
 (D) A financial expression


 92. The following property determines what is displayed in a control.
 (A) The control source property
 (B) The display property
 (C) The comes from property
 (D) The data property


 93. You view the properties of a form.
 (A) Select View>Form properties form the menu
 (B) Right click anywhere on the form and select properties from the shortcut menu
 (C) Double click the form selector box in the upper left corner of the form
 (D) All of the above


 94. You can keep the sum([Sales]) to calculate the totals for each month in.
 (A) the report footer section
 (B) the page footer section
 (C) the month group footer section
 (D) the summary section


 95. The procedure for selecting multiple controls on a report?
 (A) Hold down the Shift key as you click each object that you want to select
 (B) If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler above or to the left of the controls
 (C) Hold down the Ctrl key as you click each object that you want to select
 (D) All of these above are true


 96. The following database object can you import from one Microsoft Access database to another? (A) Queries
 (B) Tables
 (C) Forms
 (D) All of the above


 97. What field type is used to store picture in a table?
 (A) Memo
 (B) OLE
 (C) Hyperlink
 (D) None

Answer Sheet

1. (A) 2. (B) 3. (C) 4. (A) 5. (B) 6. (C) 7. (A) 8. (B) 9. (C) 10. (D) 11. (C) 12. (D) 13. (A) 14. (D) 15. (C) 16. (C) 17. (B) 18. (D) 19. (D) 20. () 21. (B) 22. (A) 23. (A) 24. (B) 25. (D) 26. (D) 27. (A) 28. (B) 29. (A) 30. (B) 31. (C) 32. (C) 33. (A) 34. (A) 35. (A) 36. (B) 37. (D) 38. (C) 39. (A) 40. (B) 41. (B) 42. (D) 43. (C) 44. (C) 45. (D) 46. (C) 47. (D) 48. (B) 49. (A) 50. (B) 51. (C) 52. (A) 53. (A) 54. (B) 55. (C) 56. (D) 57. (A) 58. (C) 59. (A) 60. (B) 61. (B) 62. (C) 63. (D) 64. (A) 65. (B) 66. (B) 67. (B) 68. (C) 69. (A) 70. (A) 71. (A) 72. (C) 73. (B) 74. (A) 75. (D) 76. (C) 77. (C) 78. (B) 79. (B) 80. (A) 81. (C) 82. (C) 83. (B) 84. (B) 85. (A) 86. (C) 87. (A) 88. (B) 89. (B) 90. (C) 91. (A) 92. (A) 93. (B) 94. (C) 95. (A) 96. (D) 97. (B)