COMPUTER FUNDAMENTALS

SET - 1
1. Which Protocol Provides E-mail facility among different hosts ?
A- FTP
B- SMTP
C- SNMP
D- TELNET
Ans- B

2. The Basic architecture of Computer was developed by

A- Jhon Von Neumann
B- Blaise Pascal
C- Charles Babbage
D- Garden Moore
Ans- A

3. In how many Generations a Computer can be classified ?

A- 3
B- 4
C- 5
D- 6
Ans- C

4. Fifth Generation Computer are based on

A- Artificial Intelligence
B- System Knowledge
C- Programming Intelligence
D- VVLSI
Ans- A
5. First Generation Computer was Based on Which technology ?
A- Transistor
B- LSI
C- VLSI
D- Vaccum Tube
Ans- D

6. Microprocessor was introduced in Which Generation of Computer ?

A- Second Generation
B- Fourth Generation
C- Third Generation
D- Fifth Generation
Ans- B

7. Second Generation Computer are made of

A- Vaccum Tubes
B- Transistor
C- LSI
D- VLSI
Ans- B

8. Which of the among Memory is non-volatile

A- SRAM
B- DRAM
C- ROM
D- All of These
Ans- C

9. Any data or Instruction entered into the memory of a computer is considered as

A- Storage
B- Information
C- Output
D- Input
Ans- D

10. Which of the Following Circuit is used as a "Memory Device" in Computers ?

A- Rectifier
B- Flip Flop
C- Comparator
D- Attenuator
Ans- B

11. Which one of the Following is not an Application Software package ?

A- Red Hat Linux
B- Microsoft Office
C- Adobe Pagemaker
D- Open Office
Ans- A

12. An Error is also known as

A- Bug
B- Debug
C- Cursor
D- Icon
Ans- A

13. Who invented The Supercomputer ?

A- Charles Babbage
B- JH Van Tassel
C- Charles Ginsburg
D- Seymour Cray
Ans- D

14. Graphical Pictures that represent an object like file, folder etc are :
A- Task Bar
B- Windows
C- Icons
D- Desktop
Ans- C

15. The 0 and 1 in the binary numbering system are called Binary Digits or
A- Bytes
B- Kilobytes
C- Decimal Bytes
D- Bits
Ans- D

16. The "IC" chip, used in Computers, is made of

A- Chromium
B- Iron Oxide
C- Silica
D- Silicon
Ans- D

17. Which of the Following Operating systems is produced by IBM ?

A- OS- 2
B- Windows
C- DOS
D- UNIX
Ans- A

18. The Processor Which performs Arithmetical and logical Operations is called
A- Control
B- ALU
C- Register
D- Cache Memory
Ans- B

19. Which was an early mainframe Computer ?

A- UNIC
B- FUNTRIA
C- BRAINIA
D- ENIAC
Ans- D

20. Which of the Following was the First Intel Processor Introduced ?
A- 3080
B- 4004
C- 8080
D- 8086
Ans- B

21. When was the First e-mail sent ?

A- 1963
B- 1969
C- 1971
D- 1974
Ans- C

22. The Memory Which is programmed at the Time it is manufactured is

A- RAM
B- ROM
C- PROM
D- EPROM
Ans- B

23. Which of the Following Memory is Volatile

A- RAM
B- ROM
C- EPROM
D- PROM
Ans- A

24. Computer Virus is a ___ ?

A- Hardware
B- Software
C- Bacteria
D- Freeware
Ans- B

25. Another term for Main Memory is

A- Hard Disk
B- ROM
C- Floppy Disk
D- RAM
Ans- D

26. The file extension of MS-Word documents in Office 2007 is ___ ?

A- .doc
B- .docx
C- .pdf
D- .txt
Ans- B

27. One MB is Equal to ?

A- 1024 Byte
B- 1024 KB
C- 1000 KB
D- 1024 GB
Ans- B

28. Internet Explorer is a Type of

A- Operating System
B- Browser
C- IP Address
D- Compiler
Ans- B

29. AVI (Audio Video Interleave) Format was developed by ?

A- IBM
B- Apple
C- Microsoft
D- Adobe
Ans- C

30. ____ is the High speed Memory used in the Computer

A- RAM
B- Hard Disk
C- Cache
D- BIOS
Ans- C

31. Which one of the Following is an example of Operating System ?

A- Microsoft Word
B- Microsoft Excel
C- Microsoft Access
D- Microsoft Windows
Ans- D

32. Which of the Following is not used as Secondary storage ?

A- Semiconductor Memory
B- Magnetic Disks
C- Magnetic Drums
D- Magnetic Tapes
Ans- A

33. General purpose Computers are those that can be adopted to countless uses
simply by changing its
A- Output Device
B- Input Device
C- Program
D- Processor
Ans- C

34. A collection of 8 bits is called

A- Byte
B- Record
C- Word
D- Nibble
Ans- A

35. The term 'Memory' applies to Which One of the Following

A- Logic
B- Storage
C- Input Device
D- Output Device
Ans- B

36. The device Primarily used to Provide Hardcopy is the

A- CRT
B- Computer Console
C- Printer
D- Card Reader
Ans- C

37. Which of the Following is the most powerful Type of the Computer ?
A- Mainframe
B- Super Conductor
C- Micro Computer
D- Super Computer
Ans- D

38. A list of instructions used by a Computer is called

A- Text
B- CPU
C- Program
D- Output
Ans- C

39. The Process of Copying data from a memory Location is called ?

A- Writing
B- Controlling
C- Booting
D- Reading
Ans- D

40. The Process of putting data into a Storage Location is called

A- Reading
B- Writing
C- Controlling
D- Hand Shaking
Ans- B

41. Which of the Following is the product of data processing ?

A- Information
B- Data
C- Software Program
D- System
Ans- A

42. Which One is not an Input Device ?

A- Keyboard
B- Mouse
C- Speaker
D- Scanner
Ans- C

43. DNS in internet technology stands for

A- Distributed Name System
B- Data Name System
C- Dynamic Name System
D- Domain Name System
Ans- D

44. USB Stands for

A- Universal Serial Bus
B- Universal Sequential Bus
C- Unique Serial Bus
D- Unique Sequential Bus
Ans- A

45. ALU Stands for

A- Arithmetic Legal Unit
B- Arithmetic Logic Unit
C- Arithmetic Local Unit
D- Arithmetic Logic Utility
Ans- B

46. CPU Stands for

A- Central Performance Unit
B- Control Processing Unit
C- Common Processing Unit
D- Central Processing Unit
Ans- D

47. What Technology of memory is Cache RAM usually

A- DRAM
B- Flash
C- SRAM
D- PROM
Ans- C

48. Where is Computers BIOS stored ?

A- DRAM
B- Flash
C- SRAM
D- Hard Disk
Ans- B

49. Where does your PC store your Programs When the power is Off ?
A- DRAM
B- Cache
C- ROM
D- Hard Disk Drive
Ans- D

50. LAN Stands for

A- Last Affordable Network
B- Leased Area Network
C- Local Area Network
D- Latency Around Network
Ans- C

51. For move to the bottom of a Documents, press ___ ?

A- Home Key
B- Ctrl + Home Key
C- End Key
D- Ctrl + End Key
Ans- D

52. By default, your Documents print in ___ mode ?

A- Page Setup
B- Portrait
C- Landscape
D- Print preview
Ans- B

53. A wireless network uses ___ waves to transmit signals ?

A- Mechanical
B- Sound
C- Radio
D- Magnetic
Ans- C

54. What Device includes an adapter that decodes data sent in radio signals ?
A- Modem
B- Switch
C- Digital Translator
D- Router
Ans- D

55. Which of the Following is not a characteristic of a Computer ?

A- Intelligence
B- Speed
C- Versatility
D- Automation
Ans- A

56. Which of the Following is not a characteristic of E-mail ?

A- Low Cost
B- Record maintenance in database
C- High speed
D- Waste reduction
Ans- B

57. Which Input Device cannot be used to work in MS Office ?

A- Scanner
B- Mouse
C- Keyboard
D- Joy Stick
Ans- D
58. Loading Operating System onto RAM is called :
A- Printing
B- Saving
C- Booting
D- Starting
Ans- C

59. The bar at the top of a window that bears the Name of the window is known as :
A- Control Panel
B- Taskbar
C- Menu Bar
D- Title Bar
Ans- D

60. URL Stands for ?

A- Universal Research List
B- Universal Resource List
C- Uniform Resource Locator
D- Uniform Research Locator
Ans- C

61. What is the Shortcut key to "Undo" the last action in a document ?
A- Ctrl + X
B- Ctrl + Z
C- Ctrl + Y
D- Ctrl + U
Ans- B

62. A normal CD- ROM usually can Store up to --- ?

A- 680 KB
B- 680 Bytes
C- 680 MB
D- 680 GB
Ans- C

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

64. The programs Which are as permanent as hardware and stored in ROM is
known as :
A- Hardware
B- Software
C- ROM ware
D- Firmware
Ans- D

65. To save a Document in different Location use :

A- Save
B- Save as
C- Save as Web page
D- All of These
Ans- B

66. Instructions and Memory Address are represented by :

A- Character Code
B- Binary Code
C- Binary Word
D- Partiy bit
Ans- B

67. As compared to diskettes, the hard disks are :

A- More expensive
B- More portable
C- Less rigid
D- Slowly accessed
Ans- A

68. Which Company is the biggest player in the microprocessor industry ?

A- Motorola
B- IBM
C- Intel
D- AMD
Ans- C

69. Which Command is used to set a name to a disk in DOS ?

A- VOLUME
B- VOL
C- DISKLABEL
D- LABEL
Ans- D

70. Which file Starts MS word ?

A- Winword.exe
B- Word.exe
C- Msword.exe
D- Word2003.exe
Ans- A

71. Superscript, subscript, outline, emboss, engrave are known as ____ ?

A- Font Styles
B- Font Effects
C- Word Art
D- Text Effects
Ans- B

72. Shimmer, Sparkle text, Blinking Background etc. are known as :

A- Font Styles
B- Font Effects
C- Word Art
D- Text Effects
Ans- D

73. Bold, Italic, Regular are known as ____ ?

A- Font Styles
B- Font Effects
C- Word Art
D- Text Effects
Ans- A

74. What kind of software would you most likely use to keep track of billing account ?
A- Word Processing
B- Electronic Publishing
C- Spreadsheet
D- Web Authoring
Ans- C

75. Which of the Following is not a Computer Language ?

A- BASIC
B- C++
C- Microsoft
D- Java
Ans- C

76. Firewalls are used to protect against ___ ?

A- Unauthorized Access
B- Virus Attacks
C- Data Driven Attacks
D- Fire Attacks
Ans- A

77. Which of the Extensions suggest that the file is a backup copy ?
A- .bak
B- .bas
C- .com
D- .txt
Ans- A

78. For creating a Document, you select ____ Option at File Menu ?
A- Open
B- Close
C- New
D- Save
Ans- C

79. Programs such as Mozilla Firefox that serve as navigable windows into the Web
are called :
A- Hypertext
B- Network
C- Internet
D- Web Browser
Ans- D

80. What is the Function of Recycle Bin ?

A- Store deleted file
B- Store Temporary File
C- Store Corrupted File
D- Store Document File
Ans- A

81. Which is the Latest version of MS Office ?

A- Office XP
B- Windows XP
C- Office 2007
D- Office 2010
Ans- D

82. Which of the Following was an early Desktop operating system that included an
integrated graphic user interface with point and click features ?
A- MS- DOS
B- Mac OS
C- Unix
D- Gnome
Ans- B

83. The most recent version of the Mac OS is based on the ___ operating system ?
A- Windows
B- Linux
C- Unix
D- CMOS
Ans- C
84. Use of Icons and windows are Characteristic of a Interface ?
A- Command-Driven
B- Windows-oriented
C- graphical-user
D- menu-driven
Ans- C

85. In a network, the Computer that stores the files and Process the data is named
as :
A- Server
B- Terminal
C- Modern
D- All of These
Ans- A

86. MIPS Stands for :

A- Million Inputs Per Second
B- Monthly Instructions Per Second
C- Million Instructions Per Season
D- Million Instructions Per Second
Ans- D

87. What is the Super Computer developed in India ?

A- CRAY
B- PARAM
C- Both A and B
D- None of These
Ans- B

88. QWERTY is used with reference to :

A- Monitor
B- Printer
C- Keyboard
D- Mouse
Ans- C

89. "Zipping" a file means :

A- Encrypting the message
B- Compressing the message
C- Transfer the message
D- All of These
Ans- B

90. Integrated circuits (IC) chips used in Computers are made with :
A- Gold
B- Silver
C- Silicon
D- Copper
Ans- C

91. Which of the Following is different from other :

A- Internet
B- Windows
C- Unix
D- Linux
Ans- A

92. The Computer code for interchange of information between terminals is

A- ASCII
B- BCD
C- BCDIC
D- All of These
Ans- A

93. The term that we use to describe Physical components of the system ?
A- Hardware
B- Inout
C- Software
D- None of These
Ans- A

94. How are data organized in a spreadsheet ?

A- Rows and Columns
B- Boxes
C- Tables
D- None of These
Ans- A

95. Which was the First web Browser ?

A- Safari
B- Internet Explorer
C- Netscape Navigator
D- WorldWideWeb
Ans- D

96. What is Windows XP ?

A- Operating System
B- Storage Device
C- Processor
D- Output Device
Ans- A

97. Which Company is nick named "Big Blue" ?

A- TCS
B- IBM
C- Microsoft
D- Apple
Ans- B

98. In Computers, what is the smallest and basic unit of information storage ?
A- Newton
B- Mega Byte
C- Byte
D- Bit
Ans- D

99. WAV file Format is associated With what Type of files ?

A- Video
B- Image
C- Sound
D- Word Document
Ans- C

100. Which of These is the First web-based e-mail Service ?

A- Gmail
B- Yahoo Mail
C- Hotmail
D- Rediff Mail
Ans- C
COMPUTER FUNDAMENTALS
SET - 2
1. Which of the Following can store information in the form of microscopic pits on
metal disks ?
A- Laser disks
B- Tape Cassettes
C- RAM Cartridge
D- Punched Cards
Ans- A

2. A Storage system for small amounts of data is :

A- Magnetic Card
B- Magnetic Tape
C- Punched Card
D- Optical Mark reader
Ans- A

3. A pen shaped device Which can sense light, and is used to point at spots on a
Video screen ?
A- Mouse
B- Plotter
C- Light Pen
D- Joystick
Ans- C

4. Compression of digital data for efficient storage is :

A- Buffer
B- CPU
C- Packing
D- Field
Ans- C

5. Which Programming Language is based on AlgoI 60 ?

A- PILOT
B- SNOBOL
C- ADA
D- SIMULA
Ans- D

6. A Memory that doesn't change its contents without external causes is known as :
A- Dynamic Memory
B- Static Memory
C- RAM
D- EEPROM
Ans- B

7. The report card and Merit List forms the :

A- Output data
B- Data Processing
C- Central Processing
D- Input Data
Ans- A
8. A Memory that holds micro Programs is :
A- Core Memory
B- ROM
C- RAM
D- Control Memory
Ans- B

9. The organization and interconnection of the various components of a Computer

system is :
A- Architecture
B- Networks
C- Graphics
D- Designing
Ans- A

10. RAM is used as a short memory because it is :

A- Is Very expensive
B- Is Programmable
C- Volatile
D- Has small Capacity
Ans- C

11. Which is a Device that changes Information into digital form ?

A- Modem
B- Digitizer
C- Mouse
D- Light Pen
Ans- B

12. Symbolic Languages was developed in :

A- 1962
B- 1974
C- 1980
D- 1950
Ans- D

13. Which Network is a packet switching network ?

A- Ring Network
B- LAN
C- Star Network
D- EuroNET
Ans- D

14. What is the Name given to the molecular-scale Computer ?

A- Femtocomputer
B- Nanocomputer
C- Supercomputer
D- Microcomputer
Ans- B

15. Which Printer uses a combination of laser-beam & electro photographic

techniques ?
A- Laser Printers
B- Dot-Matrix
C- Line Printer
D- Daisy Wheel
Ans- A

16. When was the Apple Macintosh II Microcomputer introduced in the market ?
A- 1964
B- 1970
C- 1987
D- 1986
Ans- C

17. Control Unit of a digital computer is often called the :

A- Clock
B- Never Center
C- ICs
D- All of These
Ans- B

18. Time during which a job processed by the Computer is :

A- Delay Time
B- Real Time
C- Execution Time
D- Down Time
Ans- C

19. Off-line Operation is the operation of Devices without the control of :

A- Memory
B- CPU
C- ALU
D- Control Unit
Ans- B

20. Programs designed to perform specific tasks is known as :

A- System Software
B- Application Software
C- Utility Programs
D- Operating System
Ans- B
21. What is the name given to the weapons Which use computerised guidance
system ?
A- Starwars weapons
B- Dumb Weapons
C- Guided Weapons
D- Smart Weapons
Ans- D
22. The Language that is an Input for Statement translation is called :
A- Assembly Language
B- Object Language
C- Source Language
D- High-level Language
Ans- C

23. A high speed device used in CPU for temporary storage during processing is
called :
A- A Register
B- A Bus
C- A Databus
D- All of These
Ans- A

24. The First Electronic digital Computer contained ?

A- Electronic Valves
B- Vaccum Tubes
C- Transistors
D- Semiconductor Memory
Ans- A

25. EBCDIC Can code up to how many different characters ?

A- 16
B- 32
C- 64
D- 256
Ans- D

26. The Memory Which is ultraviolet light erasable and electrically programmable is :
A- ROM
B- PROM
C- RAM
D- EPROM
Ans- D

27. The Access method used for cassette tape is :

A- Direct
B- Random
C- Sequential
D- All of These
Ans- C
28. The arranging of Data in a logical sequence is called :
A- Sorting
B- Classifying
C- Reproducing
D- Summarizing
Ans- A

29. Who is the creator of the PASCAL Language ?

A- Dijkstra
B- Donald Knuth
C- Basic Pascal
D- Niklaus Wirth
Ans- D

30. When was Punched-card equipment used for the first time to Process the British
census ?
A- 1910
B- 1907
C- 1911
D- 1914
Ans- C

31. 1024 bytes represent a

A- Megabyte
B- Gigabyte
C- Kilobyte
D- None of These
Ans- C

32. A directly accessible appointment calendar is a feature of a ____ Resident

package ?
A- CPU
B- Memory
C- Buffer
D- ALU
Ans- B

33. Which Type device is a piece of equipment that receives information from a CPU
?
A- Input
B- Output
C- CPU
D- Memory
Ans- B

34. When was the IBM XT Microcomputer released in the Market ?

A- 1970
B- 1971
C- 1987
D- 1986
Ans- C

35. Which of the Following is used for Serial access storage only ?
A- RAM
B- Magnetic disk
C- Core Memory
D- Magnetic Tape
Ans- D

36. A Memory Space used for the temporary Storage of a data is :

A- PROM
B- SAM
C- Scratchpad Storage
D- Buffer
Ans- C

37. What is the name of the Logic Circuit which can add two Binary digits ?
A- Register
B- Buffer
C- Full adder
D- Half adder
Ans- D

38. One Byte can be used to encode any integer between 'O' and Inclusive :
A- 16
B- 256
C- 128
D- 255
Ans- D

39. How many types of storage loops exist in Magnetic bubble memory ?
A- 2
B- 4
C- 8
D- 16
Ans- A

40. The bubbles in a bubble Memory pack are created with the help of ?
A- Laser beam
B- Magnetic field
C- Electric field
D- X- ray
Ans- B

41. When did arch rivals IBM and Apple Computers Inc. decide to join hands ?
A- 1978
B- 1984
C- 1990
D- 1991
Ans- D

42. The transistorized Computer circuits were introduced in the :

A- First Generation
B- Second Generation
C- Third Generation
D- Fourth Generation
Ans- B
43. The Memory sizes in mainframe and advanced technology micro computers are
Expressed as :
A- Bytes
B- Kilo-bytes
C- Bits
D- Megabytes
Ans- D

44. Which of the Following devices can be used to directly input printed text ?
A- OCR
B- OMR
C- MICR
D- All of These
Ans- A

45. To locate a data item for storage is :

A- Field
B- Feed
C- Database
D- Fetch
Ans- D

46. Which of the Following Memory is capable of operating at Electronics speed ?

A- Semiconductor Memory
B- Magnetic disks
C- Magnetic drums
D- Magnetic tapes
Ans- A

47. A temporary Storage area, attached to the CPU, for I/O Operations is a :
A- Chip
B- Buffer
C- Register
D- Core
Ans- B

48. Which part of the Computer were is used for calculating and comparing ?
A- Disk Unit
B- Control Unit
C- ALU
D- Modem
Ans- C

49. The person contributing the idea of the stored program was :
A- Jhon von Neumann
B- Charles Babbage
C- Howard Aiken
D- Basic Pascal
Ans- A

50. A file containing relatively permanent data is :

A- Random File
B- Transaction File
C- Master File
D- Sequential File
Ans- C

51. Communication that involves Computers, establishing a link through the

telephone system is called :
A- Teleprocessing
B- Microprocessing
C- Telecommunications
D- All of These
Ans- C

52. Dot-matrix is a type of :

A- Tape
B- Printer
C- Disk
D- Bus
Ans- B

53. Where does a Computer add and compare data ?

A- Hard Disk
B- Floopy Disk
C- CPU Chip
D- Memory Chip
Ans- C

54. General purpose Computers are those that can be adopted to countless uses
simply by changing its :
A- Keyboard
B- Printer
C- Program
D- Display Screen
Ans- C
55. A Part located in the central Processing Unit that stores data & information is
known as :
A- Core Memory
B- PROM
C- EPROM
D- ROM
Ans- A

56. An Input device Which can Read Characters directly from an ordinary piece of
paper is :
A- OCR
B- OMR
C- MSI
D- POS
Ans- A

57. Which of the Following chips can be reprogrammed with Special electric pulses ?
A- EPROM
B- PROM
C- ROM
D- EEPROM
Ans- D

58. A collection of eight bits is called :

A- Byte
B- Word
C- Record
D- File
Ans- A

59. Which is a Secondary memory device ?

A- CPU
B- ALU
C- Floppy Disk
D- Mouse
Ans- C

60. In a PC, how much memory is available to Application software ?

A- 1024 KB
B- 760 KB
C- 640 KB
D- 560 KB
Ans- C

61. Which part of the diskette should never be touched ?

A- Hub
B- Centre
C- Oval Slot
D- Corner
Ans- C

62. The Storage Locations in the internal storage of a CPU are called ?
A- Contents
B- Addresses
C- Locations
D- Mask
Ans- B

63. Which Type of display is that Latest to be used for portable Computer ?
A- LED Display
B- LCD Display
C- Plasma display
D- Electroluminescent Display
Ans- D

64. The EAM Device that does not use a control panel is the :
A- Collator
B- Reproducer
C- Interpreter
D- Sorter
Ans- D

65. When an Input Electrical signal A= 10100 is applied to a NOT gate, its output
signal is :
A- 1011
B- 10001
C- 10101
D- 101
Ans- A

66. Large Computer system typically uses :

A- Line Printers
B- Ink-Jet Printers
C- Dot-matrix Printers
D- Daisy Wheel Printers
Ans- A

67. Can you tell what Passes into and out from the Computer via its ports ?
A- Data
B- Bytes
C- Graphics
D- Graphics
Ans- B

68. What is the General name of the device Which produces Hardcopy graphics ?
A- COM
B- Plotter
C- Printer
D- Microfilm
Ans- B

69. In Which Year was UK's premier computing event called "The Which Computer"
Started ?
A- 1980
B- 1985
C- 1986
D- 1987
Ans- A

70. The ALU of a Computer responds to the commands coming from :

A- Primary Memory
B- Control Section
C- External Memory
D- Cache Memory
Ans- B

71. The heart of any Computer is the :

A- CPU
B- Memory
C- I/O Unit
D- Disks
Ans- A

72. A 32 bit microprocessor has the word length equal to :

A- 2 Bytes
B- 32 Bytes
C- 4 Bytes
D- 8 Bytes
Ans- C

73. In a Computer System, Which is functionally opposite of a Key- board ?

A- Trackball
B- Mouse
C- Printer
D- Joystick
Ans- C

74. One of the Following is termed a combination Input-Output device ?

A- VDT
B- Keyboard
C- Printer
D- Laser Jet
Ans- A

75. The Process of Writing Computer instructions in a programming language is

known as :
A- Coding
B- Processing
C- Programming
D- File
Ans- A

76. What is the Name given to the 8-bit unit used for coding data ?
A- Block Of Characters
B- Byte
C- Word
D- KB
Ans- B

77. Magnetic tape can serve as :

A- Secondary storage media
B- Output Media
C- Input Media
D- All of These
Ans- A

78. Microfilm reader is a :

A- OCR Device
B- COM Device
C- MICR Device
D- All of These
Ans- B

79. In Magnetic disks, data is organized on the platter in a concentric sets of rings
called ?
A- Sector
B- Track
C- Head
D- Block
Ans- B

80. The data recording area between the blank gaps on Magnetic tape is called a/an
?
A- Record
B- Field
C- Database
D- Block
Ans- D

81. Which term is not used to describe the Memory component of a Computer ?
A- ROM
B- PROM
C- RAM
D- SAM
Ans- D
82. Who coordinates the sequencing of events within the Centeral Processor of a
Computer ?
A- Logic Unit
B- Arithmetic Unit
C- Register
D- Control Unit
Ans- D

83. The Equipment With Which the Computer talks to its users is called a :
A- Software
B- Diskette
C- Peripheral
D- Word Processor
Ans- B

84. The term Gigabyte refers to :

A- 1024 Bytes
B- 1024 Kilobytes
C- 1024 Megabytes
D- 1024 Gigabyte
Ans- C

85. The CPU Chip used in a Computer is partially made out of :

A- Silica
B- Carbon
C- Copper
D- Gold
Ans- A

86. Accessing records from a file directly without searching from the beginning of the
file is :
A- Time Sharing
B- Random
C- Direct Access
D- Access Time
Ans- C

87. When did IBM close the last of its Punched card manufacturing plant ?
A- June, 1989
B- December, 1984
C- March, 1982
D- November, 1979
Ans- B

88. The Monitor of a Computer is connected to it by a :

A- Bus
B- Line Driver
C- Wire
D- Cable
Ans- D

89. A single bus structure is primarily found in :

A- Main Frames
B- Super Computers
C- High Performance machines
D- Mini-and micro Computers
Ans- D

90. What is the highest Address possible if 16 bits are used for each Address ?
A- 65536
B- 12868
C- 16556
D- 643897
Ans- A

91. Which of the Following bus types are used by the Apple Macintosh computer ?
A- ISA
B- NuBus
C- EISA
D- MCA
Ans- B

92. Group of Instructions that Directs a Computer is called :

A- Storage
B- Memory
C- Logic
D- Program
Ans- D

93. The First microprocessor built by the Intel Corpn. was called :
A- 8008
B- 8080
C- 4004
D- 8800
Ans- C

94. The microelectronics is the technology of :

A- microwaves
B- Microcomputers
C- Chips
D- Automatic processing
Ans- C

95. When was the X Windows System born ?

A- 1984
B- 1989
C- 1988
D- 1990
Ans- A

96. Which Memory System is not as a mass Memory medium :

A- Semiconductor Memory
B- Magnetic tape
C- Magnetic Disk
D- Magnetic Drum
Ans- A

97. The General range of speed in Revolutions per Minute (rpm) at Which Floppy
disks rotate is :
A- 2400-4700
B- 390-600
C- 150-250
D- 300-600
Ans- C

98. One nibble is Equal to :

A- 4 bits
B- 8 bits
C- 6 bits
D- 16 bits
Ans- B

99. What is Required when more than one person uses a Central computer at the
same time ?
A- Light Pen
B- Mouse
C- Digitizer
D- Terminal
Ans- D

100. Which kind of Storage device can be carried around ?

A- Hard Disk
B- Floppy Disk
C- Hard Disk Drive
D- Floppy Disk Drive
Ans- B
MS WORD
SET - 3
1. The minimum numbers of rows and Columns in MS Word Documents is :
A- 1 and 1
B- 1 and 2
C- 2 and 1
D- 2 and 2
Ans- A

2. How many Columns can you insert in a word Document in Maximum ?

A- 55
B- 50
C- 45
D- 40
Ans- C

3. What is the smallest and largest font size available in font Size on formatting tool
on Formatting toolbar ?
A- 8 and 68
B- 8 and 72
C- 6 and 72
D- 6 and 68
Ans- B

4. A character that is raised and smaller Above the baseline is known as :

A- Raised
B- Outlined
C- Capscript
D- Superscript
Ans- D

5. Selecting text means, selecting ?

A- a word
B- an entire sentence
C- Whole Document
D- any of the Above
Ans- D

6. MS-word automatically moves the text to the next line when it reaches the right
edge of the screen and is called ?
A- Carriage Return
B- Enter
C- Word Warp
D- None of These
Ans- C

7. Using Find Command in word, we can search ?

A- Characters
B- Formats
C- Symbols
D- All of These
Ans- D
8. In MS-word, for what does ruler help ?
A- to set tabs
B- to set indents
C- to change page margins
D- All of These
Ans- D

9. By default, on Which page the header or the footer is printed ?

A- in First page
B- 9n alternet page
C- on every page
D- None of These
Ans- C

10. Which menu in MS word can be used to change Character size and typeface ?
A- View
B- Tools
C- Format
D- Data
Ans- C

11. Which key should be pressed to Start a new paragraph in MS word ?

A- Down Cursor Key
B- Enter Key
C- Shift+ Enter
D- Ctrl+ Enter
Ans- B

12. Which of These toolbars allows changing of fonts and their sizes ?
A- Standard
B- Formatting
C- Print Preview
D- None of These
Ans- B

13. Which bar is usually located below that Title Bar that provides Categorized
Options ?
A- Menu Bar
B- Status Bar
C- Tool Bar
D- Scroll Bar
Ans- A

14. Which Option in File Pull-down menu is used to close a file in MS Word ?
A- New
B- Quit
C- Close
D- Exit
Ans- C

15. What is the Function of Ctrl+ B 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 to the Selected text
Ans- C

16. Graphics for Word Processor :

A- Peripheral
B- Clip Art
C- Highlight
D- Execute
Ans- B

17. What is the Extension of files created in MS word 97-2003 ?

A- dot
B- doc
C- dom
D- txt
Ans- B

18. 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
Ans- C

19. Which Shortcut key is used to spell check in MS word ?

A- F1
B- F2
C- F7
D- F9
Ans- C

20. The Minimum Number of rows and Columns a word table can have is ?
A- Zero
B- 2 rows and 1 Columns
C- 2 rows and 2 columns
D- 1 rows and 1 columns
Ans- D

21 In MS- word Shortcut SHIFT + DELETE is used to :

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- Creat a Shortcut to the Selected Item
Ans- A

22. In MS word to move the Insertion point to the beginning of the Next word
Command used is :
A- CTRL + RIGHT ARROW
B- CTRL + LEFT ARROW
C- CTRL + DOWN ARROW
D- None of These
Ans- A

23. What is the default number of lines to drop for drop cap ?
A- 3
B- 10
C- 15
D- 20
Ans- A

24. Why are headers and footers used in Document ?

A- To Mark large Document more readable
B- To Mark the starting and ending of a page
C- To enhance the overall appearance of the Document
D- To allow page headers and footers to appear
on Document when it is printed
Ans- D

25. What is the Maximum number of Lines you can set for a drop cap ?
A- 10
B- 15
C- 20
D- Undefine
Ans- A

26. How can you insert a sound file in your word Document ?
A- From Insert > Sound Menu Option
B- From Insert > File Menu Option
C- From Insert > Object Menu Option
D- None of These
Ans- C

27. A template Stores :

A- Graphics, text, styles, macros
B- Customized word Command setting
C- Auto text entries
D- All of These
Ans- D

28. What do you mean by vertical separation between Columns ?

A- Orientation
B- Gutter
C- Margin
D- Index
Ans- C
29. Which of the Following is an absolute cell reference ?
A- A1
B- $A$1
C- !A!!
D- #a#1
Ans- B

30. Pressing F8 key for three times selects :

A- A Paragraph
B- A Sentence
C- A Word
D- Entire Document
Ans- B

31. Thesaurus tool in MS word is used for :

A- Spelling Suggestion
B- Synonyms and Antonyms
C- Grammar Options
D- All of These
Ans- A

32. Which of the Following is not valid version of MS Word ?

A- Office 2003
B- Office Vista
C- Office 2007
D- None of These
Ans- B

33. What features helps you to inserts the contents of the clipboard as text without
any formatting in MS word ?
A- Page Setup
B- Paste Special
C- Styles
D- Format Painter
Ans- B

34. What is place to the left of horizontal scroll bar ?

A- Indicators
B- View Buttons
C- Tap Stop Buttons
D- Split Buttons
Ans- B

35. Which file Start MS word ?

A- Word.exe
B- Word2003.exe
C- MSword.exe
D- Winword.exe
Ans- D

36. How many ways you can save a Document ?

A- 3
B- 4
C- 2
D- 1
Ans- 3

37. If you want to keep track of different editions of a Document Which features will
you use ?
A- Editions
B- Versions
C- Track Change
D- All of These
Ans- B

38. Background Color or Effects applied on a Document is not visible in :

A- Reading View
B- Print Layout View
C- Web Layout View
D- Print Preview
Ans- D

39. What is a portion of a Document in which you set certain page formatting Options
?
A- Page Setup
B- Page
C- Section
D- Document
Ans- C

40. Borders can be applied to :

A- Cells
B- Text
C- Paragraph
D- All of These
Ans- D

41. Which of the Following is not a Type of page margin ?

A- Right
B- Center
C- Left
D- Top
Ans- B

42. What is the default left margin in word 2003 Document ?

A- 1
B- 2
C- 1.25
D- 1.5
Ans- C
43. Portrait and Landscape are :
A- Page Orientation
B- Paper Size
C- Page Layout
D- All of These
Ans- A

44. If you need to Change the typeface of a Document, Which menu will you choose
?
A- Edit
B- View
C- Format
D- Tools
Ans- C

45. Which of the Following is not a font Style ?

A- Bold
B- Italic
C- Regular
D- Superscript
Ans- D

46. How can you disable extended Selection mode ?

A- Press Del to disable
B- Press F8 to disable
C- Press Esc to disable
D- Press Rnter to disable
Ans- C

47. What is the Maximum Number of Lines you can set for a drop cap ?
A- 3
B- 10
C- 15
D- 20
Ans- B

48. What is the default number of Lines to drop for drop cap ?
A- 3
B- 10
C- 15
D- 20
Ans- A

49. How many Columns can you insert in a word Document in Maximum ?
A- 35
B- 45
C- 50
D- 55
Ans- B

50. What is the smallest and largest font Size available in font Size tool on
Formatting toolbar ?
A- 8 and 72
B- 8 and 64
C- 12 and 72
D- 12 and 64
Ans- A

51. What is the Maximum font size you can Apply for any character ?
A- 163
B- 1638
C- 16038
D- None of These
Ans- B

52. Which of the Following is Graphics solution for word Processor ?

A- Clipart
B- WordArt
C- Drop Cap
D- All of These
Ans- A

53. A Character that is raised and smaller Above the baseline is known as :
A- Raised
B- Outlined
C- Subscript
D- Superscript
Ans- D

54. Thesaurus tool in MS Word is used for :

A- Grammar Options
B- Spelling Suggestions
C- Synonyms and Antonyms words
D- All of These
Ans- C

55. Why drop caps are used in Document ?

A- To drop all the Capital Letters
B- To automatically begin each paragraph with Capital letter
C- To begin a paragraph with a large dropped initial Capital Letter
D- None of These
Ans- C

56. A bookmark is an item or location in Document that you identify as a name for
future reference. Which of the Following task is accomplished by using bookmarks ?
A- To Mark the ending of a paragraph of document
B- To add anchors in web page
C- To add hyperlinks in Webpage
D- To quickly jump to specific Location in Document
Ans- D
57. A word Processor would most likely be used to do :
A- Type a biography
B- Maintain an Inventory
C- Do a Computer search in media center
D- Keep an account of money spent
Ans- A

58. What happens when you Click on insert >>Picture >>Clip Art ?
A- It insert a clipart picture into Document
B- It let's you choose clipart to insert into Document
C- It Opens Clip Art taskbar
D- None of These
Ans- C

59. Which Option is not available in insert Table Autofit Behavior ?

A- Fixed Column width
B- AutiFit to Contents
C- AutoFit to Column
D- AutoFit to Window
Ans- C

60. To autofit the width of column :

A- Double Click the left Border of Column
B- Double Click the right Border of Column
C- Double Click the Column header
D- All of These
Ans- B

61. From Which menu you Can insert Header and Footer ?
A- Format Menu
B- View Menu
C- Tools Menu
D- Insert Menu
Ans- B

62. Where can you change the vertical alignment ?

A- Paragraph dialog box
B- Formatting toolbar
C- Page setup dialog box
D- Standard toolbar
Ans- C

63. To get the 'Symbol' dialog box, click on the ____ menu and choose 'symbol' ?
A- Tools
B- Table
C- Insert
D- Format
Ans- C

64. Which of the Following symbol sets would be most likely to contain a
mathematical symbol such as a Degree sign, greater than or equal to, or a Greek
letter ?
A- Symbol
B- Wingdings
C- Webdings
D- None of These
Ans- A

65. Auto Correct was originally designed to replace ____ words as you type ?
A- Grammatically Incorrect
B- Short, repetitive
C- Misspelled
D- None of These
Ans- C

66. Which One of the Following is the Second step in creating a macro ?
A- Using your mouse or keyboard, perform the task you want to automate
B- Give the macro a name
C- Assign a keyboard shortcut to the macro
D- Start recording
Ans- C

67. If you will be displaying or printing your document on another computer, you'll
want to make sure and select the ___ Option under the 'Save' tap ?
A- Embed True Type Fonts
B- Embed Fonts
C- Save True Type Fonts
D- Save Fonts
Ans- A

68. In word, the mailing list is known as the ___ ?

A- Data Source
B- Sheet
C- Data Sheet
D- Source
Ans- A

69. It is possible to ____ a data source Before performing a merge ?

A- Modify
B- Sort
C- Creat
D- All of These
Ans- D

70. What is the default font Size of a new word Document based on Normal template
?
A- 9 pt
B- 12 pt
C- 14 pt
D- None of These
Ans- B

71. What is the default font used in MS word Document ?

A- Times New Roman
B- Arial
C- Algerian
D- None of These
Ans- A

72. Which tap in font dialog box contains Options to Apply font Effects ?
A- Text Effects
B- Standard Toolbar
C- Font Tab
D- Character Spacing
Ans- C

73. Drop cap Means :

A- Small Caps
B- Title Caps
C- All Caps
D- None of These
Ans- D

74. Which enables us to send the same letter to different persons ?

A- Macros
B- Template
C- Mail Merge
D- None of These
Ans- C

75. Which can be used for quick access to commonly used Commands and tools ?
A- Status bar
B- Tool bar
C- Menu bar
D- Title bar
Ans- B

76. Which of the Following line spacing is invalid ?

A- Multiple
B- Double
C- Triple
D- Single
Ans- C

77. On Which toolbar can you find Format Painter tool ?

A- Formatting Toolbar
B- Picture Toolbar
C- Drawing Toolbar
D- Standard Toolbar
Ans- D

78. Which indent marker controls all the lines except First line ?
A- Left Indent Marker
B- First Line Indent Marker
C- Right Indent Marker
D- Hanging Indent Marker
Ans- A

79. Which Operation you will perform if you Need to move a block of text ?
A- Copy and Paste
B- Paste and Cut
C- Cut and Paste
D- Paste and Delete
Ans- C

80. What is the Extension of Word files ?

A- DOT
B- TXT
C- FILE
D- DOC
Ans- D

81. Which of the Following Option is not available in insert >> Picture ?
A- Chart
B- Graph
C- Clip Art
D- Word Art
Ans- B

82. To Insert a drop cap in one of the Paragraph you should access ?
A- Format
B- Tools
C- Insert Menu
D- None of These
Ans- A

83. How many different positions can you set for drop cap ?
A- 1
B- 2
C- 3
D- 4
Ans- B

84. What is the Maximum number of Lines you Can set for Lines to drop box ?
A- 3
B- 5
C- 10
D- 15
Ans- C
85. Which of the Following can not be used to creat Parallel style column ?
A- Insert Textbox
B- Table Insert Table
C- Format Tabs
D- Format Columns
Ans- D

86. Which of the Following is used to creat newspaper style Columns ?

A- Format Columns
B- Insert Textbox
C- Table Insert Table
D- Format Tabs
Ans- A

87. Columns dialog box can be opened from :

A- Press Alt + O + C
B- Format menu Columns submenu
C- Double Click on Column space in ruler
D- All of These
Ans- D

88. You can jump to the next column by :

A- Press Alt + Down-arrow
B- Clicking with your Mouse on the next Column
C- Both A and B
D- None of These
Ans- C

89. Which of the Following Command is not available in tools menu ?

A- Auto Summarize
B- Macro
C- Autocorrect
D- Auto Text
Ans- D

90. Text boundary can be displayed or hidden from ?

A- Customize from Tools Menu
B- Auto Text Option from Insert Menu
C- Options from Tools Menu
D- All of These
Ans- C

91. Which of the Following are word processing software ?

A- MS Word
B- Easy Word
C- Word Perfect
D- All of These
Ans- D

92. MS Office provides help in many ways, which of These is One of them ?
A- Help Menu
B- What is this ?
C- Office Assistant
D- All of These
Ans- D

93. You wished to justify text over the Height of Paper, which Option will you choose
:
A- From Formatting Toolbar
B- Page Setup from File Menu
C- Font From Format Menu
D- Paragraph From Format Menu
Ans- B

94. Which of the Following is not of the merge process ?

A- Sort the data source Records
B- Merge the two files to print or create a new document
C- Edit a data source
D- Format a main document
Ans- A

95. Which of the Following not the part of Standard office suite ?
A- Database
B- File Manager
C- Image Editor
D- Word Processor
Ans- B

96. Where can you find the draw Table tool button ?
A- Formatting Toolbar
B- Drawing toolbar
C- Standard toolbar
D- Tables and Formatting toolbar
Ans- D

97. Which of the Following Option in file pull down menu is used to Close a MS Word
Document ?
A- Exit
B- Close
C- Quit
D- New
Ans- B

98. Superscript, Subscript, Outline, emboss, engrave are known as :

A- Font Effects
B- Text Effects
C- Font Styles
D- Word Art
Ans- A

99. Shimmer, Sparkle text, Blinking Background etc. are known as :

A- Font Effects
B- Text Effects
C- Font Styles
D- Word Art
Ans- B

100. A Winchester disk is a :

A- Disk Stack
B- Removable disk
C- Flexible disk
D- All of These
Ans- A
MS WORD
SET - 4
1. To Redo the last Work, press :
A- Ctrl + U
B- Ctrl + Y
C- Ctrl + Z
D- Ctrl + W
Ans- B

2. To undo the last Work, press :

A- Ctrl + U
B- Ctrl + Y
C- Ctrl + Z
D- Ctrl + W
Ans- C

3. Which key is used to select all the text in the documents ?

A- Ctrl + T
B- Ctrl + A
C- Ctrl + F
D- Ctrl + N
Ans- B

4. Which key is used to increase left Indent ?

A- Ctrl + I
B- Ctrl + M
C- Alt + I
D- F10
Ans- B

5. Which language does MS word use to creat macros ?

A- Visual C++
B- Visual Basic
C- FoxPro
D- Access
Ans- B

6. Changing the appearance of a Documents is called ?

A- Proofing
B- Editing
C- Formatting
D- All of These
Ans- C

7. What is the Maximum scale percentage available in Scale drop down box ?
A- 500
B- 200
C- 100
D- 90
Ans- B

8. Which of the Following Position is not available for Fonts on MS Word ?

A- Normal
B- Raised
C- Lowered
D- Centered
Ans- D

9. Which of the Following is not available in font spacing ?

A- Normal
B- Loosely
C- Condensed
D- Expanded
Ans- B

10. How much space in minimum must be provided columns ?

A- 0"
B- 0.5"
C- 1"
D- 1.5"
Ans- A

11. What is the smallest width of a column ?

A- 0"
B- 0.5"
C- 1"
D- 1.5"
Ans- B

12. How can you increase the font Size of Selected text by one point every time ?
A- By pressing Ctrl + ]
B- By pressing Ctrl + [
C- By pressing Ctrl + }
D- By pressing Ctrl + {
Ans- A

13. What does Ctrl + = key effect ?

A- Superscript
B- Subscript
C- All Caps
D- Shadow
Ans- B

14. How can you make the Selected character Superscripted ?

A- Ctrl + =
B- Ctrl + Shift + =
C- Alt + Ctrl + Shift + =
D- None of These
Ans- B

15. How can you access the font Size tool on Formatting toolbar ?
A- Ctrl + S
B- Ctrl + Shift + S
C- Ctrl + P
D- Ctrl + Shift + P
Ans- D

16. When assigning a Shortcut key to a symbol, you should always try to select a
key or key combination that is :
A- Unassigned
B- Located on the ten-key pad section of your keyboard
C- Assigned to another task
D- From the same font family as the symbol
Ans- A

17. What is the Shortcut key you can press to creat a copyright symbol ?
A- Alt+Ctrl+C
B- Alt + C
C- Ctrl + C
D- Ctrl + Shift + C
Ans- A

18. What happens if you press Ctrl + Shift + F8

A- It activates extended Selection
B- It activates the rectangle Selection
C- It selects the Paragraph on which the
Insertion line is
D- None of These
Ans- B

19. A feature of MS Word that saves the Document automatically after certain
interval is available on :
A- Save tab on Options dialog box
B- Save As dialog box
C- Both A and B
D- None of These
Ans- A

20. The feature of Word that automatically adjusts the amount of space between
certain combination of Characters so that an entire word looks more evenly spaced.
What is that feature called ?
A- Spacing
B- Keming
C- Positioning
D- Scaling
Ans- B
21. Shimmer, Sparkle text, Blinking Background
etc. are known as :
A- Word art
B- Font Styles
C- Text Effects
D- Font Effects
Ans- C

22. Superscript, Subscript, Outline, emboss,

engrave are known as :
A- Font Effects
B- Text Effects
C- Font Styles
D- Word Art
Ans- A
23. Where can you find the draw Table tool button ?
A- Formatting toolbar
B- Drawing toolbar
C- Standard toolbar
D- Tables and Formatting toolbar
Ans- D

24. Which of the Following is not the Part of Standard Office suite ?
A- Database
B- File Manager
C- Image Editor
D- Word Processor
Ans- B

25. You wished to justify text Over the Height of Paper, which Option will you choose
A- From Formatting toolbar
B- Page Setup From File Menu
C- Font From Format Menu
D- Paragraph From Format Menu
Ans- B

26. Text boundary Can be displayed or hidden from :

A- Customize from Tools Menu
B- Auto text Option from Insert Menu
C- Options from Tools Menu
D- All of These
Ans- C

27. To open Columns dialog box quickly :

A- Double Click the space between area on ruler
B- Double Click the right margin in ruler
C- Double Click on the left margin area of ruler
D- All of These
Ans- A
28. You can Jump to the next Column by :
A- Press Alt + Down Arrow
B- Clicking With your Mouse on the next Column
C- Both A and B
D- None of These
Ans- C

29. Columns dialog box Can be opened from :

A- Press Alt + O + C
B- Format Menu Columns submenu
C- Double Click on the column Space in ruler
D- All of These
Ans- D

30. Which of the Following is used to creat newspaper Style Columns ?

A- Format Columns
B- Table Insert Table
C- Format Tabs
D- Insert Textbox
Ans- A

31. How many different positions Can you set for drop cap ?
A- 1
B- 2
C- 3
D- 4
Ans- B

32. Which of the Following Option is not available in Insert >>Picture ?

A- Chart
B- Clip Art
C- Graph
D- Word Art
Ans- C

33. Which indent Marker controls All the Lines except First Line ?
A- Left Indent Marker
B- First Line Indent Marker
C- Right Indent Marker
D- Hanging Indent Marker
Ans- D

34. Columns dialog box Can be opened :

A- Format Menu Columns Submenu
B- Double Click on Column Space in ruler
C- Press Alt + O + C
D- All of These
Ans- D
35. The ____, or typeface, defines the appearance and shape of Letters, numbers,
and special Characters ?
A- font
B- Font Size
C- point
D- Paragraph Formatting
Ans- A

36. Which Operation you will perform If you Need to move A block of text ?
A- Copy and Paste
B- Cut and Paste
C- Paste and Delete
D- Paste and Cut
Ans- B

37. The word Count Command on the Tools Menu displays the number of words as
well as the number of ____ in the Current Document ?
A- Lines
B- Characters
C- Paragraphs
D- All of These
Ans- D

38. ____ Formatting is the process of changing the way Letters, numbers,
punctuation Marks, and symbols appear on the screen and in print ?
A- Document
B- Character
C- Paragraph
D- Object
Ans- B

39. Change the ____ to creat a Document in wide format ?

A- Page Orientation
B- Page margins
C- Paper Style
D- Paper Source
Ans- A

40. A ___ is a collection of predefined design elements and color schemes ?

A- Feature
B- Hyperlink
C- Palette
D- Theme
Ans- D

41. Where Can you change the vertical alignment ?

A- Formatting toolbar
B- Paragraph dialog box
C- Page setup dialog box
D- Standard toolbar
Ans- C

42. Switching between Portrait and Landscape Modes involves the :

A- Header and Footer Toolbar
B- Print Layout View
C- Page setup dialog box
D- None of These
Ans- C

43. Which features helps you to Inserts the contents of the Clipboard as text without
any Formatting ?
A- Paste Special
B- Format Painter
C- Page Setup
D- Styles
Ans- A

44. To verify that the note text is Positioned correctly on the page, switch to ____
view or display the Document in print Preview ?
A- Normal
B- Print Layout
C- Page Layout
D- Page Edit
Ans- B

45. With Which View can you see how text and graphics will appear on the printed
page ?
A- Normal
B- Print Layout
C- Outline
D- Web Layout
Ans- B

46. When sharing data in Office, the ___ document is the document in which the
data was First entered ?
A- Source
B- Destination
C- Original
D- Primary
Ans- A

47. Short Cut Ctrl + T is used to :

A- Hanging Indent
B- Left Indent
C- Open Tabs Dialog box
D- Terminate all opened dialog box
Ans- A

48. Short Cut Ctrl + P used to :

A- Open Paragraph dialog box
B- Open Page Format Dialog box
C- Open Save Dialog Box
D- Open Print Dialog box
Ans- D

49. Ctrl + G is used to :

A- Open Paragraph dialog box activating Goto Tab
B- Open page Setup dialog box activating Goto Tab
C- Open find and Replace Dialog box with activating Goto Tab
D- Open Goto Dialog Box
Ans- C

50. Where Can you find the horizontal split bar on MS word screen ?
A- On the left of horizontal scroll bar
B- On the right of horizontal scroll bar
C- On the top of vertical scroll bar
D- On the bottom of vertical scroll bar
Ans- C

51. By default, on Which page the header or the Footer is printed ?

A- On First Page
B- On alternate page
C- On every Page
D- None of These
Ans- C

52. Which of the Following is not the Section Break Option ?

A- Next Page
B- Previous Page
C- Odd Page
D- Even Page
Ans- B

53. What are inserted as cross-reference in word ?

A- Placeholder
B- Bookmark
C- Objects
D- Word Files
Ans- D

54. Ctrl + N is used to :

A- Save Document
B- Open Document
C- New Document
D- Close Document
Ans- C

55. Which file Starts MS Word ?

A- Winword.exe
B- Word.exe
C- Msword.exe
D- Word2003.exe
Ans- A

56. Which of the Following are word Processing Software ?

A- Wordperfect
B- Wordpad
C- MS Word
D- All of These
Ans- D

57. The ability to combine Name and address with a standard Document is called
___ ?
A- Document Formatting
B- Database Management
C- Mail Merge
D- Form Letters
Ans- C

58. Which enables us to send the same letters to different Persons ?

A- Macros
B- Template
C- Mail Merge
D- None of These
Ans- C

59. A word Processor would most likely be used to do :

A- Keep an Account of money spent
B- Do a Computer search in Media Center
C- Maintain an Inventory
D- Type a biography
Ans- D

60. Which Can be used for quick access to commonly used Commands and Tools ?
A- Status Bar
B- Tool Bar
C- Menu Bar
D- Title Bar
Ans- B

61. Which of the Following is not essential component to perform a mail merge
operation ?
A- Main Document
B- Data Source
C- Merge Fields
D- Word Fields
Ans- D

62. When the Language bar is ____, it means that you do not see it on the screen
but it will be displayed the next time you start your computer ?
A- Restored
B- Hidden
C- Minimized
D- Closed
Ans- B

63. Autocorrect was originally designed to replace ____ words as you Type ?
A- Short, repetitive
B- Grammatically Incorrect
C- Misspelled
D- None of These
Ans- C

64. Home key uses for :

A- Moves the cursor beginning of the Document
B- Moves the cursor beginning of the Paragraph
C- Moves the cursor beginning of the Screen
D- Moves the cursor beginning of the line
Ans- D

65. "Ctrl + Right Arrow" is used to :

A- Moves the cursor one word right
B- Moves the cursor end of the line
C- Moves the cursor end of the Document
D- Moves the cursor One Paragraph down
Ans- A

66. End key is used to :

A- Moves the cursor end of the line
B- Moves the cursor end of the Document
C- Moves the cursor end of the Paragraph
D- Moves the cursor end of the Screen
Ans- A

67. "Ctrl + PageDown" is used to :

A- Moves the cursor One Paragraph down
B- Moves the cursor One page down
C- Moves the cursor One line down
D- Moves the cursor One screen down
Ans- B

68. "Ctrl + Down Arrow" is used to :

A- Moves the cursor One Paragraph down
B- Moves the cursor One page down
C- Moves the cursor One line down
D- Moves the cursor One screen down
Ans- A

69. Page Up key uses for :

A- Moves the cursor One Line up
B- Moves the cursor One Screen up
C- Moves the cursor One page up
D- Moves the cursor One Paragraph up
Ans- B

70. "Ctrl + Left Arrow" is used to :

A- Moves the cursor beginning of the line
B- Moves the cursor One word left
C- Moves the cursor One Paragraph up
D- Moves the cursor One Paragraph down
Ans- B

71. Page Down Key is used to :

A- Moves the cursor One Line down
B- Moves the cursor One page down
C- Moves the cursor One screen down
D- Moves the cursor One Paragraph down
Ans- C

72. "Ctrl + PageUp" is used to :

A- Moves the cursor One page up
B- Moves the cursor One Paragraph up
C- Moves the cursor One screen up
D- Moves the cursor One Line up
Ans- A

73. "Ctrl + Up Arrow" is used to :

A- Moves the cursor One page up
B- Moves the cursor One Line up
C- Moves the cursor One screen up
D- Moves the cursor One Paragraph up
Ans- D

74. "Ctrl + Home" is used to :

A- Moves the cursor to the beginning of
Document
B- Moves the cursor to the beginning of Line
C- Moves the cursor to the beginning of
Paragraph
D- All of These
Ans- A

75. "Ctrl + End" is used to :

A- Moves the cursor to the end of Line
B- Moves the cursor To the end of Document
C- Moves the cursor to the end of Paragraph
D- None of These
Ans- B

76. Ctrl + N is used to :

A- Save Document
B- Open Document
C- New Document
D- Close Document
Ans- C

77. To exit from the resume wizard and return to the Document window without
creating a resume, click the ___ button in any panel in the Resume Wizard dialog
box ?
A- Cancel
B- Back
C- Next
D- Finish
Ans- D

78. What are inserted as cross-reference in word ?

A- Placeholders
B- Bookmarks
C- Objects
D- Word Fields
Ans- D

79. Which of the Following is not the Section Break Option ?

A- Next Page
B- Previous Page
C- Odd Page
D- Even Page
Ans- B

80. By default, on Which page the header or the Footer is printed ?

A- On First Page
B- On alternate Page
C- On every Page
D- None of These
Ans- C

81. When sharing Data in office, the ___ Document is the Document in which the
data was First entered ?
A- Source
B- Destination
C- Original
D- Primary
Ans- A

82. With Which view can you see how text and Graphics will appear on the printed
page ?
A- Normal
B- Print Layout
C- Outline
D- Web Layout
Ans- B

83. Which features helps you to Insert the contents of the Clipboard as text without
any Formatting ?
A- Paste Special
B- Format Painter
C- Page Setup
D- Styles
Ans- A

84. Switching between Portrait and Landscape Modes involves the :

A- Header and Footer Toolbar
B- Print Layout View
C- Page Setup Dialog box
D- None of These
Ans- C

85. Where Can you Change the Vertical alignment ?

A- Formatting Toolbar
B- Paragraph dialog box
C- Page Setup dialog box
D- Standard toolbar
Ans- C

86. A ____ is a collection of predefined design elements and Color schemes ?

A- Feature
B- Hyperlink
C- Palette
D- Theme
Ans- D

87. Change the ____ to creat A Document in Wide Format.

A- Page Orientation
B- Page Margins
C- Paper Style
D- Paper Source
Ans- A

88. _____ Formatting is the Process of changing the way Letters, Numbers,
punctuation Marks and symbols appear on the screen and in Print.
A- Document
B- Character
C- Paragraph
D- Object
Ans- B

89. Which Operation you will perform If you Need to move A Block of text ?
A- Copy and Paste
B- Cut and Paste
C- Paste and Delete
D- Paste and Cut
Ans- B

90. You can detect Spelling and grammar errors by :

A- Press Shift + F7
B- Press Ctrl + F7
C- Press Alt + F7
D- Press F7
Ans- D

91. How Can you break the Current column ?

A- Press Ctrl + Shift + Enter
B- Press Alt + Enter
C- Press Ctrl + Enter
D- Press Alt + Shift + Enter
Ans- A

92. How Can you disable extended Selection Mode ?

A- Press F8 again to disable
B- Press Del to disable
C- Press Esc to disable
D- Press Enter to disable
Ans- C

93. Which of These toolbars allows changing of Fonts and their sizes ?
A- Standard
B- Formatting
C- Print Preview
D- None of These
Ans- B

94. To view headers and footers, you must switch to :

A- Normal View
B- Print Layout View
C- Print Preview Mode
D- Both B and C
Ans- D

95. Background color or effects applied on a Document is not visible in :

A- Web Layout View
B- Print Layout View
C- Reading View
D- Print Preview
Ans- D

96. Which of the Following is not a font Style ?

A- Bold
B- Italics
C- Regular
D- Superscript
Ans- D

97. Ctrl + M is used to :

A- New Document
B- Close Document
C- Right Indent
D- Left Indent
Ans- D

98. Which of the Following is not available on the Ruler of MS word screen ?
A- Tab stop box
B- Left Indent
C- Right Indent
D- Center Indent
Ans- D

99. In MS Word, Ctrl + S is used to :

A- Scenarios
B- Size
C- Save
D- Spelling Check
Ans- C

100. From where you Can access Save Command ?

A- Home Tab
B- Insert Tab
C- Review Tab
D- None of These
Ans- D
COMPUTER MCQ
SET - 5
1. what is the extension file excel 2004 ?
a) .xls b) .excel c) .xcel d) .xcl
Ans. A

2. what is the extension file excel 2007 and above ?

a) .xls b) .excel c) .xlsx d) .xcl
Ans. C

3. Worksheet is also called an array of____.

a) column b) cells c) box d) formula
Ans. b

4. How Cells are named in MS Excel?

A- Alphabetically B- Numerically C- Alphanumerically D- Special Character
Ans. c

5. What is the maximum limit of rows in MS Excel 2010?

A- 1084567 B- 1048567 C- 1048576 D- 1084576
Ans. c

6. What is the maximum limit of column in MS Excel 2010?

A- 16384 B- 16438 C- 16843 D- 16348
Ans. a

7. Which bar lies top of the window in Excel Screen?

A- Status Bar B- Ruler C- Title Bar D- Scroll Bar
Ans. c

8. How rows are numbered in MS Excel?

A- Alphabetically B- Numerically C- Alphanumerically D- Special characters
Ans. b

9. How columns are named in MS Excel?

A- Alphabetically B- Numerically C- Alphanumerically D- Special characters
Ans. a

10. Which tab is used to include pivot table, charts, hyperlinks to a spread sheet?
A- Insert B- Page Layout C- Data D- Review
Ans. a

11. Which tab in Excel is used when importing, querying, outlining and subtotaling the
data placed into a worksheet‟s data list?
A- Formula B- Data C- Review D- Insert
Ans. b

12. Which tab in Excel is used for proofing, protecting, and marking up a spread sheet?
A- Formula B- Data C- Review D- View
Ans. c
13. Which tool in Ms office is best for organizing data and making lists?
A- Access B- Excel C- Power Point D- Word
Ans. b

14. What is the file extension of Excel 2010?

A- xls B- xlsb C- xlsm D- xlsx
Ans. d

15. How does the single element in a worksheet known as in Excel?

A- Cell B- Column C- Range D- Row
Ans. a

16. What do you mean by A3,B13:B20,C7 reference in Excel?

A- Range B- Union C- Formula D- General
Ans. a

17. Which type of key should combine with ctrl key to create a macro key in Excel?
A- Numeric B- Alphabetic C- Alphanumeric D- Special characters
Ans. b

18. Which bar is used to display the sheet information and insertion point location in MS
Excel?
A- Ruler B- Scroll Bar C- Status Bar D- Title Bar
Ans. c

19. Which tab is used to change the display of worksheet area and the data it contains?
A- Page Layout B- Data C- Review D- View
Ans. d

20. Which view in Excel displays the pages exactly as they appear when printed?
A- Custom View B- Full screen View C- Page Break View D- Page Layout view
Ans. d

21. Which tab is used for creating, formatting and editing a spreadsheet?
A- Data B- Home C- Insert D- Review
Ans. b

22. Which function is used to count the number of cells that contain numbers, in a
range?
A- Count () B- Countif() C- Sum() D- Sumif()
Ans. a

23. Which function is used to add the values in a range?

A- Count() B- Sum() C- ABS() D- Sumif()
Ans. b

24. which symbol is used to excute formulas in MS Excel?

A- = B- „ C- # D- “
Ans. a

25. Where does the result displays when a formula is entered in Excel?
A- Current Cell B- Next Cell C- Previous Cell D- Formula Bar
Ans. a
26. Which function in Excel is used to find the biggest value in a range?
A- Ceiling B- DMAX C- LEN D- MAX
Ans. D

27. Which one of the following is a text function in MS Excel?

A- MID() B- NOW() C- COUNT() D- SIGN
Ans. a

28. Which one of the following is a „Date & Time‟ function in Excel?
A- FIND() B- MOD() C- NOW() D- MID()
Ans. c

29. Which function is used to find the middle number in a range?

A- MEDIAN() B- MID() C- TRIM() D- MODE()
Ans. a

30. What is the purpose „Tab‟ key in MS Excel?

A- Moves cell pointer to previous column
B- Moves cell pointer to next column
C- Moves cell pointer previous row
D- Moves cell pointer next row
Ans. b

31. What is the purpose of „Enter Key‟ in MS Excel?

A- Moves cell pointer to previous column
B- Moves cell pointer to next column
C- Moves cell pointer to previous row
D- Moves cell pointer to next row
Ans. d

32. Which function key is used to open goto dialogue box in MS Excel?
A- F2 B- F5 C- F7 D- F11
Ans. b

33. Which option in MS Excel is used to display the rows that meet certain conditions?
A- Find B- Filter C- Format D- Sort
Ans. b

34. Which option in Excel is used to rearrange the rows base on the content of a
particular column?
A- Find B- Filter C- Sort D- Format
Ans. c

35. Which type of addressing is used to keep rows constant and column changes and
vice versa while copying a formula from one area of the worksheet to another in Excel?
A- Mixed B- General C- Relative D- Absolute
Ans. a

36. Which one of the following is „no argument‟ function?

A- Now() B- Lower() C- Max() D- IF()
Ans. A
37. Which key is used to move the insertion point to the beginning of the current sheet?
A- Pageup B- Home C- Ctrl + pageup D- Ctrl + Home
Ans. d

38. Which key is used to make multiple line in a single cell?

A- Alt+ ↵ B- Tab+↵ C- Ctrl+ ↵ D- Shift+ ↵
Ans. A
39. Columns in MS Excel are named in the form of ______.
(a) alphabets (A, B, C, D,...)
(b) numbers (1,2,3,4,...)
(c) roman numerals (I,II, III, IV,...)
(d) none of them
Ans. a
40. Rows in MS Excel are named in the form of_____ .
(a) alphabets (A, B, C, D,...)
(b) numbers (1,2,3,4,...)
(c) roman numerals (I,II, III, IV,...)
(d) none of them
Ans. b

41. The intersection of a row and column in MS Excel is called _______ .

(a) spreadsheet (b) workbook (c) document (d) cell
Ans. d

42. The cell having and column number 3 and row number 6 is denoted by the name
______.
(a) F3 (b) C6 (c) C3 (d) F6
Ans. b

43. In MS Excel, a function is entered by typing ______ symbol first.

(a) @ (b) $ (c) # (d) =
Ans. d

44. MS Excel can ______ given data.

(a) sort (b) statistically analyze (c) draw graphs for (d) all of them
Ans. d

45. The latest version of MS Excel can have ______rows.

(a) 10,48,576 (b) 16,384 (c) 1024 (d) 512
Ans. a

46. The latest version of MS Excel can have ______columns.

(a) 10,48,576 (b) 16,384 (c) 1024 (d) 512
Ans. b

47. Excel supports recording of repeated actions with the help of ______.
(a) graph (b) chart (c) macro (d) other applications
Ans. c

48. MS Excel macros can be invoked using_______.

(a) button (b) keystroke (c) both a & b (d) neither a nor b
Ans. c
49. MS Excel supports a version of Visual Basic called ______for programming.
(a) Javascript
(b) Visual Basic for Applications (VBA)
(c) ASP.NET
(d) C#.NET
Ans. b

50. Each sheet in MS Excel file is called a ______.

(a) workbook (b) worksheet (c) notesheet (d) notebook
Ans. B

51. By default, Excel worksheets are named _______.

(a) book1, book2, book3, ...
(b) sheet1, sheet2, sheet3,...
(c) page1, page2, page3, ...
(d) note1, note2, note3, ...
Ans. b

52. Excel file without any macros has the default extension of ______.
(a) .xlsx (b) .xls (c) .xlsm (d) .xlst
Ans. a

53. Excel file containing macros has the default extension of______ .
(a) .xlsx (b) .xls (c) .xlsm (d) .xlst
Ans. c

54. MS Excel can reference data in _______.

(a) the same sheet
(b) different sheet in the same workbook
(c) different sheet in a different workbook
(d) all of them
Ans. d

55. In MS Excel, the common type of data applicable to any cell is called _____ data
type.
(a) General (b) Number (c) Currency (d) Text
Ans. a

56. In MS Excel, the data type suitable for handling numbers is called _______data type.
(a) General (b) Number (c) Currency (d) Text
Ans. b

57. In MS Excel, number data type can control the ________.

(a) digit grouping
(b) number of decimal places
(c) both a & b
(d) neither a nor b
Ans. C
58. In MS Excel, numbers can be grouped and prefixed with a currency symbol using
_____ data type.
(a) Accounting (b) Currency (c) both a & b (d) neither a nor b
Ans. C
59. In MS Excel, ______data type is suitable for handling dates.
(a) Date (b) Time (c) Percentage (d) Fraction
Ans. a

60. In MS Excel, _______data type is suitable for handling time values.

(a) Date (b) Time (c) Percentage (d) Fraction
Ans. b

61. In MS Excel, _______ data type takes values between 0 and 1 and displays them in
percentage format.
(a) Date (b) Time (c) Percentage (d) Fraction
Ans. c

62. In MS Excel,_______ data type displays decimal fractions as vulgar or mixed

fractions.
(a) Date (b) Time (c) Percentage (d) Fraction
Ans. D
63. In MS Excel, ______data type displays numbers in scientific notation.
(a) Scientific (b) Text (c) Custom (d) Date
Ans. a

64. In MS Excel, _____data type is suitable for names and other character sequences.
(a) Scientific (b) Text (c) Custom (d) Date
Ans. b

65. In MS Excel, _____data type supports formatting of numbers with suitable

customization.
(a) Scientific (b) Text (c) Custom (d) Date
Ans. c

66. In MS Excel, for the number 45453453 to be displayed as 4,54,53,453.0, the custom
format could be________ .
(a) ##,##,##,##0.0 (b) ###,###,##0.0 (c) ########0.0 (d) ##,##,##,###.#
Ans. a

67. In custom formatting of numbers, an optional digit is denoted by ________symbol.

(a) 0 (b) # (c) $ (d) ^
Ans. b

68. In custom formatting of numbers, a compulsory/ mandatory digit is denoted by_____

symbol.
(a) 0 (b) # (c) $ (d) ^
Ans. A
69. When copying and pasting an excel formula, the method which permits formula to
progressively update cell references is called ______ referencing system.
(a) static (b) semi-relative (c) relative (d) none of them
Ans. C
70. When copying and pasting an excel formula, the method which permits formula to
progressively update either column reference or row reference (but not both column and
row references) is called ________referencing system.
(a) static (b) semi-relative (c) relative (d) none of them
Ans. B
71. When copying and pasting an excel formula, the method which keeps references to
a particular cell address is called ______ referencing system.
(a) static (b) semi-relative (c) relative (d) none of them
Ans. a

72. The formula = A5 * 5 is written in ______system.

(a) static (b) semi-relative (c) relative (d) none of them
Ans. c

73. The formula = A5 * 5, when copied to the next row of the same column, will become
_______ system.
(a) = A4 * 5 (b) = B5 * 5 (c) = A7 * 5 (d) = A6 * 5
Ans. d
74. In MS Excel, _______ functions help to access databases stored in spreadsheets.
(a) Cube/ Database (b) Date/ Time (c) Engineering (d) Financial
Ans. A
75. ______functions help to access date and time functions in MS Excel.
(a) Cube/ Database (b) Date/ Time (c) Engineering (d) Financial
Ans. b

76. _______ functions help to access base conversion, logarithmic and other
Engineering features in MS Excel.
(a) Cube/ Database (b) Date/ Time (c) Engineering (d) Financial
Ans. c

77. In MS Excel, ______functions help to access interest calculation, accounting and

currency related calculations.
(a) Cube/ Database (b) Date/ Time (c) Engineering (d) Financial
Ans. d

78. In MS Excel, ______functions help to check the status of cells, as to whether the cell
is blank, contains a number, text, type of data, etc.
(a) Information (b) Logical (c) Lookup & reference (d) Math & Trigonometric
Ans. a

79. In MS Excel, _______ functions help to make logical functions like AND, OR, NOT,
etc.
(a) Information (b) Logical (c) Lookup & reference (d) Math & Trigonometric
Ans. b

80. In MS Excel, ______functions help to make lookup in other sheets and references.
(a) Information (b) Logical (c) Lookup & reference (d) Math & Trigonometric
Ans. c
81. In MS Excel, mathematical functions like round, absolute, ceiling, floor, etc. and
trigonometric functions like sin, cos, tan, asin, acos, atan, etc are containing the category
of _______.
(a) Information (b) Logical (c) Lookup & reference (d) Math & Trigonometric
Ans. d

82. In MS Excel, statistical functions like average, standard deviation, median, mode,
etc. can be accessed under the category ________ .
(a) Logical (b) Lookup & reference (c) Math & Trigonometric (d) Statistical
Ans. D

83. In MS Excel, functions for length of text, text search, text concatenation, upper, lower
and proper, etc. can be accessed under the category _______ .
(a) Text (b) Logical (c) Lookup & reference (d) Math & Trigonometric
Ans. A
84. _______ function in MS Excel takes year, month and date values and displays given
date.
(a) DATE (b) DATEDIF (c) DATEVALUE (d) DAY
Ans. a

85. _______ function in MS Excel takes a date value and returns the day of month.
(a) DATE (b) DATEDIF (c) DATEVALUE (d) DAY
Ans. D
86. _____function in MS Excel takes 2 date values and calculates the difference
between the dates in years ("Y"), months ("M") or days ("D").
(a) DATE (b) DATEDIF (c) DATEVALUE (d) DAY
Ans. b

87. _____function in MS Excel takes a date string and returns parsed date value.
(a) DATE (b) DATEDIF (c) DATEVALUE (d) DAY
Ans. c

88. ______function in MS Excel returns number of days between given dates.

(a) DAYS/ DAYS360 (b) EDATE (c) EOMONTH (d) HOUR
Ans. a

89. ______function in MS Excel takes a date, number of months to offset from that date
and returns new date.
(a) DAYS/ DAYS360 (b) EDATE (c) EOMONTH (d) HOUR
Ans. b

90. ______ function in MS Excel returns last date of the month represented by given
date.
(a) DAYS/ DAYS360 (b) EDATE (c) EOMONTH (d) HOUR
Ans. c

91. _______ function in MS Excel returns the hour represented by the given time.
(a) DAYS/ DAYS360 (b) EDATE (c) EOMONTH (d) HOUR
Ans. d

92. ______function in MS Excel returns minutes from a time value.

(a) MINUTES (b) SECOND (c) EOMONTH (d) HOUR
Ans. a

93. ______ function in MS Excel returns seconds from a time value.

(a) MINUTES (b) SECOND (c) EOMONTH (d) HOUR
Ans. B
94. ______function in MS Excel returns current time.
(a) MINUTES (b) SECOND (c) NOW (d) HOUR
Ans. c

95. ______function in MS Excel returns current date.

(a) MINUTES (b) SECOND (c) NOW (d) TODAY
Ans. d

96. _____function in MS Excel returns day of week for given date.

(a) WEEKDAY (b) WORKDAY (c) YEAR (d) YEARFRAC
Ans. a

97. _______ function in MS Excel returns the date after given number of working days.
(a) WEEKDAY (b) WORKDAY (c) YEAR (d) YEARFRAC
Ans. b

98. ______ function in MS Excel returns the year part of given date.
(a) WEEKDAY (b) WORKDAY (c) YEAR (d) YEARFRAC
Ans. C
99. ______function in MS Excel returns fractional year between given dates.
(a) WEEKDAY (b) WORKDA (c) YEAR (d) YEARFRAC
Ans. d

100. In MS Excel, _______function converts a binary number to decimal number.

(a) BIN2DEC (b) BIN2HEX (c) BIN2OCT (d) BITAND
Ans. a
COMPUTER MCQ
SET - 6
1. In MS Excel, _______function converts a binary number to hexadecimal number.
(a) BIN2DEC (b) BIN2HEX (c) BIN2OCT (d) BITAND
Ans. b
2. In MS Excel, ______function converts a binary number to octal number.
(a) BIN2DEC (b) BIN2HEX (c) BIN2OCT (d) BITAND
Ans. c

3. In MS Excel, _______function performs bitwise AND operation.

(a) BIN2DEC (b) BIN2HEX (c) BIN2OCT (d) BITAND
Ans. d

4. In MS Excel, ______function performs bitwise OR operation.

(a) BITOR (b) BITSHIFT (c) BITXOR (d) BITAND
Ans. a

5. In MS Excel, function performs bitwise right shift operation.

(a) BITOR (b) BITSHIFT (c) BITXOR (d) BITAND
Ans. B

6. In MS Excel,_______ function performs bitwise XOR operation.

(a) BITOR (b) BITSHIFT (c) BITXOR (d) BITAND
Ans. c

7. In MS Excel, ________ function converts decimal number to binary number.

(a) COVNERT (b) DEC2BIN (c) DEC2HEX (d) DEC2OCT
Ans. b

8. In MS Excel, _______function converts decimal number to hexadecimal number.

(a) COVNERT (b) DEC2BIN (c) DEC2HEX (d) DEC2OCT
Ans. c
9. In MS Excel, _______function converts decimal number to octal number.
(a) COVNERT (b) DEC2BIN (c) DEC2HEX (d) DEC2OCT
Ans. d

10. In MS Excel, _______ function returns 1 if given values are equal.

(a) DELTA (b) DEC2BIN (c) DEC2HEX (d) DEC2OCT
Ans. a

11. In MS Excel, _______ function converts hexadecimal number to binary number.

(a) DELTA (b) HEX2BIN (c) HEX2DEC (d) HEX2OCT
Ans. B
12. In MS Excel, ______ function converts hexadecimal number to decimal number.
(a) DELTA (b) HEX2BIN (c) HEX2DEC (d) HEX2OCT
Ans. c

13. In MS Excel, ______function converts hexadecimal number to octal number.

(a) DELTA (b) HEX2BIN (c) HEX2DEC (d) HEX2OCT
Ans. d

14. In MS Excel, ______ function returns true if a cell is blank.

(a) ISBLANK (b) ISERR (c) ISEVEN (d) ISODD
Ans. a
15. In MS Excel, ______function returns true if there is an error in the formula contained
in given cell.
(a) ISBLANK (b) ISERR (c) ISEVEN (d) ISODD
Ans. b

16. In MS Excel, ______function returns true if the given cell contains an even number.
(a) ISBLANK (b) ISERR (c) ISEVEN (d) ISODD
Ans. c

17. In MS Excel, ________function returns true if the given cell contains an odd number.
(a) ISBLANK (b) ISERR (c) ISEVEN (d) ISODD
Ans. d

18. In MS Excel, ______function returns true if the given cell contains a formula.
(a) ISFORMULA (b) ISERR (c) ISEVEN (d) ISODD
Ans. a

19. In MS Excel, _______function returns true if the given cell a logical value (TRUE or
FALSE).
(a) ISNUMBER (b) ISNONTEXT (c) ISNA (d) ISLOGICAL
Ans. d

20. In MS Excel, ______ function returns true if the given cell contains a number.
(a) ISNUMBER (b) ISNONTEXT (c) ISNA (d) ISLOGICAL
Ans. a

21. In MS Excel, ______ function returns true if the given cell contains Logical value
(TRUE or FALSE).
(a) ISNUMBER (b) ISNONTEXT (c) ISNA (d) ISLOGICAL
Ans. d

22. In MS Excel, _______function returns true if the given cell contains a value other
than text (number, logical, etc.).
(a) ISNUMBER (b) ISNONTEXT (c) ISNA (d) ISLOGICAL
Ans. b

23. In MS Excel, _______function returns true if #NA error has occurred.

(a) ISNUMBER (b) ISNONTEXT (c) ISNA (d) ISLOGICAL
Ans. c

24. In MS Excel, _______ function returns number equivalent of text value.

(a) N (b) NA (c) TYPE (d) AND
Ans. A
25. In MS Excel, _______function returns #NA error number.
(a) N (b) NA (c) TYPE (d) AND
Ans. b
26. In MS Excel, _______function returns a number corresponding to the data type of
the cell.
(a) N (b) NA (c) TYPE (d) AND
Ans. c
27. In MS Excel, ________function returns true only if all the given conditions are true.
(a) OR (b) FALSE (c) TRUE (d) AND
Ans. d

28. In MS Excel, ________function returns true even if just one of the given conditions is
true.
(a) OR (b) FALSE (c) TRUE (d) AND
Ans. a

29. In MS Excel, ______function tests the condition given in the first part, executes
second part if the condition is true or executes third part if the condition is false.
(a) OR (b) IF (c) TRUE (d) AND
Ans. b

30. In MS Excel, ________function returns positive value irrespective of whether the

input is positive or negative.
(a) ABS (b) ASIN (c) ACOS (d) ATAN
Ans. a

31. In MS Excel, ______ function returns aggregate value like count, sum, average, etc.
(a) ARABIC (b) ASINH (c) ATANH (d) AGGREGATE
Ans. d

32. In MS Excel, ______function returns hyperbolic sin value.

(a) ACOSH (b) ASINH (c) ATANH (d) AGGREGATE
Ans. b

33. In MS Excel, ______function returns hyperbolic cosine value.

(a) ACOSH (b) ASINH (c) ATANH (d) AGGREGATE
Ans. a

34. In MS Excel, ______function returns hyperbolic tan value.

(a) ACOSH (b) ASINH (c) ATANH (d) AGGREGATE
Ans. c

35. In MS Excel, ________function returns the integer just above a fractional number.
(a) CEILING (b) FLOOR (c) ROUND (d) ROUNDDOWN
Ans. a

36. In MS Excel, ______function returns the integer just below a fractional number.
(a) CEILING (b) FLOOR (c) ROUND (d) ROUNDDOWN
Ans. B

37. In MS Excel, ______function returns the number rounded to the given digits.
(a) CEILING (b) FLOOR (c) ROUND (d) ROUNDDOWN
Ans. c
38. In MS Excel, _____function returns the number rounded DOWN to the given digits,
simply discarding the trailing value even if it is greater than or equal to 5.
(a) CEILING (b) FLOOR (c) ROUND (d) ROUNDDOWN
Ans. d
39. In MS Excel, ______function returns the number rounded UP to the given digits,
simply discarding the trailing value even if it is greater than or equal to 5.
(a) ROUNDUP (b) FLOOR (c) ROUND (d) ROUNDDOWN
Ans. a

40. In MS Excel, ______function converts given angle from radian to degrees.

(a) DEGREES b) RADIANS (c) EVEN (d) ODD
Ans. a

41. In MS Excel, ______function converts given angle from degrees to radians.

(a) DEGREES (b) RADIANS (c) EVEN (d) ODD
Ans. b

42. In MS Excel, ______ function returns the nearest even number.

(a) DEGREES (b) RADIANS (c) EVEN (d) ODD
Ans. c

43. In MS Excel, ______function returns the nearest odd number.

(a) DEGREES (b) RADIANS (c) EVEN (d) ODD
Ans. d

44. In MS Excel, _____function returns the exponential value for given number.
(a) EXP (b) LN (c) LOG/ LOG10 (d) FACT
Ans. a

45. In MS Excel, _______function returns the natural logarithm for given number.
(a) EXP (b) LN (c) LOG/ LOG10 (d) FACT
Ans. b

46. In MS Excel, _____function returns the common logarithm (to the base 10) for given
number.
(a) EXP (b) LN (c) LOG/ LOG10 (d) FACT
Ans. c

47. In MS Excel, _______function returns the factorial of given number in integer format.
(a) FACTDOUBLE (b) LN (c) LOG/ LOG10 (d) FACT
Ans. d

48. In MS Excel, ______function returns the factorial of given number in double number
format.
(a) FACTDOUBLE (b) LN (c) LOG/ LOG10 (d) FACT
Ans. a

49. In MS Excel, ______function returns the greatest common divisor for given numbers.
(a) FACTDOUBLE (b) GCD (c) LCM (d) INT
Ans. B
50. In MS Excel, _____ function returns the least common multiple for given numbers.
(a) FACTDOUBLE (b) GCD (c) LCM (d) INT
Ans. c

51. In MS Excel, ______function returns the integer equivalent of given number, after
discarding fractional parts.
(a) FACTDOUBLE (b) GCD (c) LCM (d) INT
Ans. d

52. In MS Excel, _____function returns the determinant of given matrix.

(a) MDTERM (b) MINVERSE (c) MMUL (d) MOD
Ans. a

53. In MS Excel, ______function returns the module remainder for given number and
divisor.
(a) QUOTIENT (b) MINVERSE (c) MMUL (d) MOD
Ans. d

54. In MS Excel, _______function returns the quotient for given number and divisor.
(a) QUOTIENT (b) MINVERSE (c) MMUL (d) MOD
Ans. a

55. In MS Excel, _____function returns the number rounded to the nearest multiple of
the second argument.
(a) PI (b) POWER (c) MROUND (d) RAND
Ans. c

56. In MS Excel, ______function returns the power of given number raised by second
argument.
(a) PI (b) POWER (c) MROUND (d) RAND
Ans. b

57. In MS Excel, ______function returns a random number.

(a) PI (b) POWER (c) MROUND (d) RAND
Ans. d

58. In MS Excel, ___function returns a random number between given lower limit and
upper limit.
(a) PI (b) POWER (c) MROUND (d) RANDBETWEEN
Ans. d

59. In MS Excel, ______function converts a number from Roman numeral to Arabic

numeral.
(a) ROMAN (b) ARABIC (c) SIGN (d) SQRT
Ans. b

60. In MS Excel, _______function converts a number from Arabic numeral to Roman

numeral.
(a) ROMAN (b) ARABIC (c) SIGN (d) SQRT
Ans. A
61. In MS Excel, ______ function returns the square root of the given number.
(a) ROMAN (b) ARABIC (c) SIGN (d) SQRT
Ans. d
62. In MS Excel, ______function returns the subtotal of given numbers.
(a) SUBTOTAL (b) SUM (c) SUMIF (d) SUMSQ
Ans. a

63. In MS Excel, ______function returns the sum of given numbers.

(a) SUBTOTAL (b) SUM (c) SUMIF (d) SUMSQ
Ans. b

64. In MS Excel, _____function returns the sum of squares of given numbers.

(a) SUBTOTAL (b) SUM (c) SUMIF (d) SUMSQ
Ans. d

65. In MS Excel, _____function returns the sum of those numbers that fulfill given
condition.
(a) SUBTOTAL (b) SUM (c) SUMIF d) SUMSQ
Ans. c

66. In MS Excel, _____function truncates decimal digits of given real number to produce
an integer value.
(a) TRUNC (b) SUM (c) SUMIF (d) SUMSQ
Ans. a

67. In MS Excel, ______ function calculates the average absolute (unsigned) deviation.
(a) AVERAGE (b) AVEDEV (c) AVERAGEIFS (d) CORREL
Ans. b

68. In MS Excel, ______function calculates the average of given numbers.

(a) AVERAGE (b) AVEDEV (c) AVERAGEIFS (d) CORREL
Ans. a

69. In MS Excel, _______ function calculates the average of given numbers which fulfill
the given conditions.
(a) AVERAGE (b) AVEDEV (c) AVERAGEIFS (d) CORREL
Ans. c

70. In MS Excel, _______ function calculates the coefficient of correlation.

(a) AVERAGE (b) AVEDEV (c) AVERAGEIFS (d) CORREL
Ans. d

71. In MS Excel, _______function counts the number of objects.

(a) COUNT (b) DEVSQ (c) FORECAST (d) COUNTBLANK
Ans. a

72. In MS Excel, ______function counts the number of blank cells.

(a) COUNT (b) DEVSQ (c) FORECAST (d) COUNTBLANK
Ans. d
73. In MS Excel, ______function returns the sum of squares of deviations.
(a) COUNT (b) DEVSQ (c) FORECAST (d) COUNTBLANK
Ans. b

74. In MS Excel, ______function counts the items based on given condition.

(a) COUNT (b) DEVSQ (c) FORECAST (d) COUNTIF
Ans. d

75. In MS Excel, ______function counts the items based on given conditions.

(a) COUNT (b) DEVSQ (c) FORECAST (d) COUNTIFS
Ans. d

76. In MS Excel, ______function provides a linear estimate of the result expected for
given input.
(a) COUNT (b) DEVSQ (c) FORECAST (d) COUNTIFS
Ans. c

77. In MS Excel, _______function provides an exponential estimate of the result

expected for given input.
(a) GROWTH (b) GEOMEAN (c) LARGE (d) MEDIAN
Ans. a

78. In MS Excel, ______function returns the median value of a list.

(a) GROWTH (b) GEOMEAN (c) LARGE (d) MEDIAN
Ans. D

79. In MS Excel, ______function returns geometric mean.

(a) GROWTH (b) GEOMEAN (c) LARGE (d) MEDIAN
Ans. b

80. In MS Excel, ______function returns the largest value from a list.

(a) MAX (b) MIN (c) PERMUT (d) RANK
Ans. a

81. In MS Excel, ______function returns the smallest value from a list.

(a) MAX (b) MIN (c) PERMUT (d) RANK
Ans. b

82. In MS Excel, ______function returns result of permutations.

(a) MAX (b) MIN (c) PERMUT (d) RANK
Ans. c

83. In MS Excel, _______function returns the rank of given number when compared to a
list of numbers.
(a) MAX (b) MIN (c) PERMUT (d) RANK
Ans. d

84. In MS Excel, _______ function returns the nth smallest value from a sorted list.
(a) MAX (b) SMALL (c) PERMUT (d) RANK
Ans. b

85. In MS Excel, ______function returns the standard deviation of given numbers.

(a) MAX (b) SMALL (c) PERMUT (d) STDEV
Ans. d

86. In MS Excel, _______function returns the character equivalent of numeric ASCII value
(a) CHAR (b) CODE (c) DOLLAR (d) CONCATENATE
Ans. a
87. In MS Excel, ______function returns the ASCII code for given character value.
(a) CHAR (b) CODE (c) DOLLAR (d) CONCATENATE
Ans. b
88. ASCII stands for ______.
(a) American Standard Code for Information Interface
(b) African Standard Code for Information Interchange
(c) American Standard Code for Information Interchange
(d) American Standard Character for Information Interchange
Ans. c

89. In MS Excel, ______function formats a number as currency and prefixes the

currency symbol of the locale.
(a) CHAR (b) CODE (c) DOLLAR (d) CONCATENATE
Ans. c

90. In MS Excel, ______function appends several strings one after the other.
(a) CHAR (b) CODE (c) DOLLAR (d) CONCATENATE
Ans. d

91. In MS Excel, _______function compares two text values.

(a) FORMAT (b) LEFT (c) EXACT (d) FIND
Ans. c

92. In MS Excel, ______ function returns the location of the first string occurring within
the second, larger string.
(a) FORMAT (b) LEFT (c) EXACT (d) FIND
Ans. d

93. In MS Excel, _______function formats given number based on rules provided using
# and 0 characters.
(a) FORMAT (b) LEFT (c) EXACT (d) FIND
Ans. a

94. In MS Excel, ______function returns the leftmost character of a string.

(a) FORMAT (b) LEFT (c) EXACT (d) RIGHT

95. In MS Excel,______ function returns the rightmost character of a string.

(a) FORMAT (b) LEFT (c) EXACT (d) RIGHT
Ans. d

96. In MS Excel, ______function returns the length of given string.

(a) LOWER (b) UPPER (c) PROPER (d) LEN
Ans. d

97. In MS Excel, ______function returns the lower case version of given string.
(a) LOWER (b) UPPER (c) PROPER (d) LEN
Ans. A
98. In MS Excel, ______function returns the upper case version of given string.
(a) LOWER (b) UPPER (c) PROPER (d) LEN
Ans. b
99. In MS Excel, ______ function returns the first letter capitalized version of given
string.
(a) LOWER (b) UPPER (c) PROPER (d) LEN
Ans. c
100. In MS Excel, ______function returns a string after replacing given characters of first
string using the last string.
(a) SEARCH (b) REPLACE (c) REPT (d) LOWER
Ans. b