Computer Fundamental
Questions
1. UNIVAC is
A) Universal Automatic Computer
B) Universal Array Computer
C) Unique Automatic Computer
D) Unvalued Automatic Computer
2. The basic operations performed
by a computer are
A) Arithmetic operation
B) Logical operation
C) Storage and relative
D) All the above
3. The two major types of
computer chips are
A) External memory chip
B) Primary memory chip
C) Microprocessor chip
D) Both b and c
4. Microprocessors as switching
devices are for which generation computers
A) First Generation
B) Second Generation
C) Third Generation
D) Fourth Generation
5. What is the main difference
between a mainframe and a super computer?
A) Super computer is much larger than mainframe computers
B) Super computers are much smaller than mainframe computers
C) Supercomputers are focused to execute few programs as fast as possible while
mainframe uses its power to execute as many programs concurrently
D) Supercomputers are focused to execute as many programs as possible while
mainframe uses its power to execute few programs as fast as possible.
6. ASCII and EBCDIC are the
popular character coding systems. What does EBCDIC stand for?
A) Extended Binary Coded Decimal Interchange Code
B) Extended Bit Code Decimal Interchange Code
C) Extended Bit Case Decimal Interchange Code
D) Extended Binary Case Decimal Interchange Code
7. The brain of any computer
system is
A) ALU
B) Memory
C) CPU
D) Control unit
8. Storage capacity of magnetic
disk depends on
A) tracks per inch of surface
B) bits per inch of tracks
C) disk pack in disk surface
D) All of above
9. The two kinds of main memory
are:
A) Primary and secondary
B) Random and sequential
C) ROM and RAM
D) All of above
10. A storage area used to store
data to a compensate for the difference in speed at which the different units
can handle data is
A) Memory
B) Buffer
C) Accumulator
D) Address
11. Computer is free from
tiresome and boardoom. We call it
A) Accuracy
B) Reliability
C) Diligence
D) Versatility
12. Integrated Circuits (Ics) are
related to which generation of computers?
A) First generation
B) Second generation
C) Third generation
D) Fourth generation
13. CD-ROM is a
A) Semiconductor memory
B) Memory register
C) Magnetic memory
D) None of above
14. A hybrid computer
A) Resembles digital computer
B) Resembles analogue computer
C) Resembles both a digital and analogue computer
D) None of the above
15. Which type of computers uses
the 8-bit code called EBCDIC?
A) Minicomputers
B) Microcomputers
C) Mainframe computers
D) Super computer
16. The ALU of a computer
responds to the commands coming from
A) Primary memory
B) Control section
C) External memory
D) Cache memory
17. Chief component of first
generation computer was
A) Transistors
B) Vacuum Tubes and Valves
C) Integrated Circuits
D) None of above
18. To produce high quality
graphics (hardcopy) in color, you would want to use a/n
A) RGB monitor
B) Plotter
C) Ink-jet printer
D) Laser printer
19. What are the stages in the
compilation process?
A) Feasibility study, system design and testing
B) Implementation and documentation
C) Lexical Analysis, syntax analysis, and code generation
D) None of the above
20. Which of the following IC was
used in third generation of computers?
A) SSI
B) MSI
C) LSI
D) Both a and b
These 100 MCQ questions from fundamentals of computer is distributed through mcqSets.com. Fundamentals of Computer is one of the most weighted topic on most of the competitive computer jobs exams.
21. The main electronic component
used in first generation computers was
A) Transistors
B) Vacuum Tubes and Valves
C) Integrated Circuits
D) None of above
22. A dumb terminal has
A) an embedded microprocessor
B) extensive memory
C) independent processing capability
D) a keyboard and screen
23. One millisecond is
A) 1 second
B) 10th of a seconds
C) 1000th of a seconds
D) 10000th of a seconds
24. The output quality of a
printer is measured by
A) Dot per sq. inch
B) Dot per inch
C) Dots printed per unit time
D) All of the above
25. Which of the following was a
special purpose computer?
A) ABC
B) ENIAC
C) EDVAC
D) All of the above
26. What was the computer
invented by Attanasoff and Clifford?
A) Mark I
B) ABC
C) Z3
D) None of above
27. Which of the following
storage devices can store maximum amount of data?
A) Floppy Disk
B) Hard Disk
C) Compact Disk
D) Magneto Optic Disk
28. Which computer was considered
the first electronic computer until 1973 when court invalidated the patent?
A) ENIAC
B) MARK I
C) Z3
D) ABC
29. A physical connection between
the microprocessor memory and other parts of the microcomputer is known as
A) Path
B) Address bus
C) Route
D) All of the above
30. High density double sided
floppy disks could store _____ of data
A) 1.40 MB
B) 1.44 GB
C) 1.40 GB
D) 1.44 MB
31. A high quality CAD system
uses the following for printing drawing and graphs
A) Dot matrix printer
B) Digital plotter
C) Line printer
D) All of the above
32. Which of the following is not
an input device?
A) OCR
B) Optical scanners
C) Voice recognition device
D) COM (Computer Output to Microfilm)
33. The accuracy of the
floating-point numbers representable in two 16-bit words of a computer is
approximately
A) 16 digits
B) 6 digits
C) 9 digits
D) All of above
34. In most of the IBM PCs, the
CPU, the device drivers, memory, expansion slots and active components are
mounted on a single board. What is the name of the board?
A) Motherboard
B) Daughterboard
C) Bredboard
D) Fatherboard
35. In most IBM PCs, the CPU, the
device drives, memory expansion slots and active components are mounted on a
single board. What is the name of this board?
A) Motherboard
B) Breadboard
C) Daughter board
D) Grandmother board
36. Magnetic disks are the most
popular medium for
A) Direct access
B) Sequential access
C) Both of above
D) None of above
37. A technique used by codes to
convert an analog signal into a digital bit stream is known as
A) Pulse code modulation
B) Pulse stretcher
C) Query processing
D) Queue management
38. Regarding a VDU, Which
statement is more correct?
A) It is an output device
B) It is an input device
C) It is a peripheral device
D) It is hardware item
39. A modern electronic computer
is a machine that is meant for
A) Doing quick mathematical calculations
B) Input, storage, manipulation and outputting of data
C) Electronic data processing
D) Performing repetitive tasks accurately
40. When was vacuum tube
invented?
A) 1900
B) 1906
C) 1910
D) 1880
41. Which of the following
produces the best quality graphics reproduction?
A) Laser printer
B) Ink jet printer
C) Plotter
D) Dot matrix printer
42. Computers with 80286 microprocessor
is
A) XT computer
B) AT comptuers
C) PS/2 computer
D) None of above
43. An application suitable for
sequential processing is
A) Processing of grades
B) Payroll processing
C) Both a and b
D) All of above
44. Which of the following is not
processing?
A) arranging
B) manipulating
C) calculating
D) gathering
45. The digital computer was
developed primarily in
A) USSR
B) Japan
C) USA
D) UK
46. Software in computer
A) Enhances the capabilities of the hardware machine
B) Increase the speed of central processing unit
C) Both of above
D) None of above
47. Todays computer giant IBM
was earlier known by different name which was changes in 1924. What was that
name?
A) Tabulator Machine Co.
B) Computing Tabulating Recording Co.
C) The Tabulator Ltd.
D) International Computer Ltd.
48. Before a disk drive can
access any sector record, a computer program has to provide the records disk
address. What information does this address specify?
A) Track number
B) Sector number
C) Surface number
D) All of above
49. The arranging of data in a
logical sequence is called
A) Sorting
B) Classifying
C) Reproducing
D) Summarizing
50. What is the responsibility of
the logical unit in the CPU of a computer?
A) To produce result
B) To compare numbers
C) To control flow of information
D) To do maths works
These 100 MCQ questions from fundamentals of computer is distributed through mcqSets.com. Fundamentals of Computer is one of the most weighted topic on most of the competitive computer jobs exams.
51. Abacus was the first
A) electronic computer
B) mechanical computer
C) electronic calculator
D) mechanical calculator
52. If in a computer, 16 bits are
used to specify address in a RAM, the number of addresses will be
A) 216
B) 65,536
C) 64K
D) Any of the above
53. Instructions and memory
address are represented by
A) Character code
B) Binary codes
C) Binary word
D) Parity bit
54. The terminal device that
functions as a cash register, computer terminal, and OCR reader is the:
A) Data collection terminal
B) OCR register terminal
C) Video Display terminal
D) POS terminal
55. A set of flip flops
integrated together is called ____
A) Counter
B) Adder
C) Register
D) None of the above
56. People often call ______ as
the brain of computer system
A) Control Unit
B) Arithmetic Logic Unit
C) Central Processing Unit
D) Storage Unit
57. Which is used for
manufacturing chips?
A) Bus
B) Control unit
C) Semiconductors
D) A and b only
58. The value of each bead in
heaven is
A) 1
B) 3
C) 5
D) 7
59. The first computer introduced
in Nepal was
A) IBM 1400
B) IBM 1401
C) IBM 1402
D) IBM1402
60. Mnemonic a memory trick is
used in which of the following language?
A) Machine language
B) Assembly language
C) High level language
D) None of above
61. Instruction in computer
languages consists of
A) OPCODE
B) OPERAND
C) Both of above
D) None of above
62. Which generation of computer
is still under development
A) Fourth Generation
B) Fifth Generation
C) Sixth Generation
D) Seventh Generation
63. A register organized to allow
to move left or right operations is called a ____
A) Counter
B) Loader
C) Adder
D) Shift register
64. Which was the most popular
first generation computer?
A) IBM 1650
B) IBM 360
C) IBM 1130
D) IBM 2700
65. Which is considered a direct
entry input device?
A) Optical scanner
B) Mouse and digitizer
C) Light pen
D) All of the above
66. A set of information that
defines the status of resources allocated to a process is
A) Process control
B) ALU
C) Register Unit
D) Process description
67. Each set of Napiers bones
consisted of ______ rods.
A) 5
B) 9
C) 11
D) 13
68. BCD is
A) Binary Coded Decimal
B) Bit Coded Decimal
C) Binary Coded Digit
D) Bit Coded Digit
69. When was the worlds first
laptop computer introduced in the market and by whom?
A) Hewlett-Packard, 1980
B) Epson, 1981
C) Laplink Traveling Software Inc, 1982
D) Tandy Model-200, 1985
70. From which generation
operating systems were developed?
A) First
B) Second
C) Third
D) Fourth
71. The first firm to mass-market
a microcomputer as a personal computer was
A) IBM
B) Super UNIVAC
C) Radio Shaks
D) Data General Corporation
72. How many address lines are
needed to address each machine location in a 2048 x 4 memory chip?
A) 10
B) 11
C) 8
D) 12
73. Properly arranged data is
called
A) Field
B) Words
C) Information
D) File
74. A computer consists of
A) A central processing unit
B) A memory
C) Input and output unit
D) All of the above
75. Why are vacuum tubes also
called valves?
A) Because they can amplify the weak signals and make them strong
B) Because they can stop or allow the flow of current
C) Both of above
D) None of above
76. John Napier invented
Logarithm in
A) 1614
B) 1617
C) 1620
D) None of above
77. An integrated circuit is
A) A complicated circuit
B) An integrating device
C) Much costlier than a single transistor
D) Fabricated on a tiny silicon chip
78. What type of control pins are
needed in a microprocessor to regulate traffic on the bus, in order to prevent
two devices from trying to use it at the same time?
A) Bus control
B) Interrupts
C) Bus arbitration
D) Status
79. Where as a computer mouse
moves over the table surface, the trackball is
A) Stationary
B) Difficult to move
C) Dragged
D) Moved in small steps
80. Which of the following is
used as a primary storage device?
A) Magnetic drum
B) Hard Disks
C) Floppy
D) All of above
These 100 MCQ questions from fundamentals of computer is distributed through mcqSets.com. Fundamentals of Computer is one of the most weighted topic on most of the competitive computer jobs exams.
81. Multi user systems provided
cost savings for small business because they use a single processing unit to
link several
A) Personal computers
B) Workstations
C) Dumb terminals
D) Mainframes
82. What are the three decisions
making operations performed by the ALU of a computer?
A) Grater than
B) Less than
C) Equal to
D) All of the above
83. The word processing task
associated with changing the appearance of a document is
A) Editing
B) Writing
C) Formatting
D) All of above
84. Nepal brought a computer for
census of 2028 BS. This computer was of
A) first generation
B) second generation
C) third generation
D) fourth generation
85. Algorithm and Flow chart help
us to
A) Know the memory capacity
B) Identify the base of a number system
C) Direct the output to a printer
D) Specify the problem completely and clearly
86. Which statement is valid
about computer program?
A) It is understood by a computer
B) It is understood by programmer
C) It is understood user
D) Both a & b
87. The difference between memory
and storage is that memory is _____ and storage is __
A) Temporary, permanent
B) Permanent, temporary
C) Slow, fast
D) All of above
88. When was Pascaline invented?
A) 1617
B) 1620
C) 1642
D) 1837
89. Which of the following
statement is valid?
A) Lady Augusta is the first programmer
B) Ada is the daughter of Lord Byron, a famous English poet
C) ADA is a programming language developed by US Defense
D) All of above
90. A compiler is a translating
program which
A) Translates instruction of a high level language into machine language
B) Translates entire source program into machine language program
C) It is not involved in programs execution
D) All of above
91. 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
92. Which of the following is the
first computer to use Stored Program Concept?
A) UNIVAC
B) ENIAC
C) EDSAC
D) None of above
93. The term gigabyte refers to
A) 1024 bytes
B) 1024 kilobytes
C) 1024 megabytes
D) 1024 gigabyte
94. in which year was UKs
premier computing event called ?The which computer? started?
A) 1980
B) 1985
C) 1986
D) 1987
95. Once you load the suitable
program and provide required data, computer does not need human intervention.
This feature is known as
A) Accuracy
B) Reliability
C) Versatility
D) Automatic
96. What is a brand?
A) The name of companies that made computers
B) The name of product a company gives to identify its product in market
C) A name of class to indicate all similar products from different companies
D) All of above
97. Machine language is
A) Machine dependent
B) Difficult to program
C) Error prone
D) All of above
98. A byte consists of
A) One bit
B) Four bits
C) Eight bits
D) Sixteen bits
99. Modern Computers are very
reliable but they are not
A) Fast
B) Powerful
C) Infallible
D) Cheap
100. What is the date when Babbage
conceived Analytical engine
A) 1642
B) 1837
C) 1880
D) 1850
Correct Answers
1-A |
2-D |
3-D |
4-D |
5-C |
6-A |
7-C |
8-D |
9-C |
10-B |
11-C |
12-C |
13-D |
14-C |
15-C |
16-B |
17-B |
18-B |
19-C |
20-D |
21-B |
22-D |
23-C |
24-A |
25-A |
26-B |
27-B |
28-A |
29-B |
30-D |
31-B |
32-D |
33-B |
34-A |
35-A |
36-D |
37-A |
38-C |
39-B |
40-B |
41-C |
42-B |
43-C |
44-D |
45-C |
46-A |
47-B |
48-D |
49-A |
50-B |
51-D |
52-B |
53-B |
54-D |
55-C |
56-C |
57-C |
58-C |
59-B |
60-B |
61-C |
62-B |
63-D |
64-A |
65-D |
66-D |
67-C |
68-A |
69-B |
70-C |
71-C |
72-B |
73-C |
74-D |
75-B |
76-A |
77-D |
78-C |
79-A |
80-A |
81-C |
82-D |
83-C |
84-B |
85-D |
86-D |
87-A |
88-C |
89-D |
90-D |
91-D |
92-C |
93-C |
94-A |
95-D |
96-B |
97-D |
98-C |
99-C |
100-B |
Microsoft Word
1. How many different positions can you
set for drop cap?
a. 1
b. 2
c. 4
d. 6
2. How many ways you can save a
document?
a. 3
b. 4
c. 5
d. 6
3. What is the maximum number of lines
you can set for lines to drop box?
a. 3
b. 5
c. 10
d. 15
4. Single spacing in MS-WORD document
causes ____ point line spacing?
a. 10
b. 12
c. 14
d. 16
5. What is the default number of lines
to drop for drop cap
a. 3
b. 10
c. 15
d. 20
6. What is the maximum number of lines
you can set for a drop cap?
a. 3
b. 10
c. 15
d. 20
7. How many columns can you insert in a
word document in maximum?
a. 35
b. 45
c. 55
d. 65
8. In a document what is the maximum
number of columns that can be inserted in MS Word Table?
a. 35
b. 15
c. 63
d. 65
9. What is the maximum scale percentage
available in Scale drop down box?
a. 500
b. 200
c. 100
d. 90
10. What is the maximum font size you
can apply for any character
a. 163
b. 1638
c. 16038
d. None of above
11. Word, by default, places a tab stop
at every _____ mark on the ruler.
a. .25″
b. .5″
c. .75″
d. 1″
12. What is the default file extension
for all Word documents?
a. .txts
b. .word
c. .docs
d. .docx
13. The file type _____ indicates the
file is a Word document.
a. .msw
b. .wor
c. .wrd
d. .doc
14. With Words AutoCorrect entries, to
display an indifferent face ( ) type _____.
a. : )
b. : (
c. : |
d. : /
15. Which of the following button will
allow you to add, delete, or change records in your Data Source?
a. Data Source button
b. Edit button
c. Edit Data Source button
d. Data Editing button
16. How much space in minimum must be
provided between columns?
a. 0″
b. 0.5″
c. 1″
d. 1.5″
17. What is the smallest width of a
column?
a. 0″
b. 0.5″
c. 1″
d. 1.5″
18. By default, your document prints
with:
a. 1 inch top and bottom margins
b. a portrait orientation
c. 1.25 inches left and right margins
d. all of the above
19. Word is preset to use standard
8.5-by-11-inch paper with _____ margins.
a. 1-inch left, right, top, and bottom
b. 1.25-inch left, right, top, and bottom
c. 1.25-inch left and right margins and 1-inch top and bottom
d. 1-inch left and right margins and 1.25-inch top and bottom
20. What is the default left margin in
Word 2003 document?
a. 1″
b. 1.25″
c. 1.5″
d. 2″
21. 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. None of above
22. The Footnote Text style defines
characters as _____.
a. 12-point Times New Roman and paragraphs as single-spaced and right-aligned
b. 10-point Times New Roman and paragraphs as double-spaced and left-aligned
c. 12-point Times New Roman and paragraphs as double-spaced and right-aligned
d. 10-point Times New Roman and paragraphs as single-spaced and left-aligned
23. What is the default font size of a
new Word document based on Normal template in Word 2003?
a. 10 pt
b. 12 pt
c. 14 pt
d. None of above
24. The minimum number of rows and
columns in MS Word document is
a. 1 and 1
b. 2 and 1
c. 2 and 2
d. None of above
25. How will MS Word will respond in
repeated word.
a. A Red wavy line under the repeated word
b. A Green wavy line under the repeated word
c. A Blue wavy line under the repeated word
d. None of the above
26. In mail merge operation which of the
following might represent the main document?
a. A sales brochure
b. A form letter
c. A database of Names and Addresses
d. All of above
27. Pressing F8 key for three times
selects
a. a word
b. a sentence
c. a paragraph
d. entire document
28. What do you call a collection of
character and paragraph formatting commands?
a. the defaults
b. a template
c. a style
d. a boilerplate
29. What is a Document Outline View?
a. A preview in a full screen
b. A preview with margins
c. A View with a margins and gutter
d. A view with a structure of heading at various levels
30. Ctrl + Z
a. Undo the last Action
b. Redo the last Action
c. Add the new page
d. Paste the contents from clipboard
31. The _____ in the Resume Wizard
dialog box indicates the wizard is ready to create the document.
a. Start panel
b. Address panel
c. Add/Sort Heading panel
d. Finish panel
32. What does Ctrl + = key effect?
a. Superscript
b. Subscript
c. All Caps
d. Shadow
33. The spike
a. Allows you to combine text from several documents and tehn insert all the
text into one document at onwe time
b. Allows you to edit auto text entries
c. Allows you to format uto text entries
d. All of above
34. The word wrap reature
a. Automatically move text to the next line when necessary
b. Appears at the bottom of the document
c. Allows you to type over text
d. is the short horizontal line
35. How can you make the selected
character superscripted
a. Ctrl + =
b. Ctrl + Shift + =
c. Alt + Ctrl + Shift + =
d. None of above
36. When typing in a word field
manually, what must you press to insert the codes braces?
a. Ctrl + F6
b. Ctrl + F9
c. Alt + F11
d. Shift + F12
37. What is the short cut key to open
the Open dialog box?
a. F12
b. Shift F12
c. Alt + F12
d. Ctrl + F12
38. What is the shortcut key to split a
table?
a. Ctrl + Alt + Enter
b. Ctrl + Shift + Enter
c. Alt + Shift + Enter
d. Alt + Space + Enter
39. Which key is used to increase left
indent?
a. Ctrl+I
b. Ctrl+M
c. Alt+I
d. F10
40. When the same word is used in
multiple locations or a word is used that was not quite appropriate, a
thesaurus can be used to look up a (n) _____ or a word similar in meaning.
a. synonym
b. homonym
c. antonym
d. metronym
41. How many different documents you can
open at one time?
a. No more than three
b. Only one
c. As many as your computer memory will hold
d. As many as your taskbar can display
42. Which of the following is the second
step in creating a macro?
a. Start recording
b. Using your mouse or keyboard, perform the task you want to automate
c. Assign a keyboard shortcut to the macro
d. Give the macro a name
43. 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.
44. Which feature is used to replace
straight quotes with smart quotes as you type?
a. Auto Correct as you type
b. Auto Change as you type
c. Auto Format as you type
d. Smart Tags as you type
45. Which of the following command is
not available in Tools menu?
a. Auto text
b. Autocorrect
c. Auto summarize
d. Macro
46. Word has a list of predefined
typing, spelling, capitalization, and grammar errors that _____ can detect and
correct.
a. AutoEntry
b. AutoCorrect
c. AutoAdd
d. AutoSpell
47. If you want to convert a symbol or
several lines of text into an AutoCorrect entry, you should:
a. Insert the symbol or type the text in a Word document first. Then, select
the text or symbol and go to the AutoCorrect dialog box.
b. Click the Tools menu and choose AutoCorrect Options. Then, click the Insert
menu and choose Symbol (or click the Format menu and choose Paragraph) to add
the symbol or paragraph to AutoCorrect.
c. AutoCorrect can only accommodate one line of text. It is not possible to
convert a symbol or multiple lines of text into an AutoCorrect entry.
d. Insert the symbol or type the text in a Word document first. Then, select
the text or symbol and click the Edit menu followed by Paste Special. Select
New AutoCorrect Entry and then click OK.
48. Which option is not available in
Insert Table Autofit behavior?
a. Fixed Column Width
b. AutoFit to Contents
c. Autofit to Window
d. Autofit to Column
49. When you click on File menu in Word
2010, it opens
a. File menu
b. File Commands
c. Backstage View
d. File Ribbon
50. Tabs stop position cannot be the
following alignment
a. Decimal Alignment
b. Center Alignment
c. Bar Alignment
d. Justify Alignment
51. Why the document you created at home
displays with a different font at school?
a. Because you have a different printer at school than at home
b. Because you have a different monitor at school than at home
c. Because the font you used at home is not installed on your school computer
d. Because the version of Windows is different
52. Ctrl + B
a. Search the selected text
b. Paste the selected text
c. Bold the selected text
d. Open the specified file
53. A master document contains_________,
each of which contains a pointer to a file on a disk?
a. Placeholders
b. subdocuments
c. bookmarks
d. references
54. If the number of columns is selected
1 and the line between check box is marked, where is the line drawn?
a. in the left margin
b. in the right margin
c. both in left and right margin
d. None of Above
55. 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 of above
d. None of above
56. After typing header text, how can
you quickly enter footer text?
a. Press PageDown key and type the text for footer
b. Click on Switch between Heeder & Footer then type the text
c. Both of above
d. None of above
57. To move the cursor page to page of
document
a. Ctrl+PgDn
b. Ctrl+PgUp
c. Both of above
d. None of above
58. You can jump to the next column by
a. Clicking with your mouse on the next column
b. Press Alt + Down-arrow
c. Both of above
d. None of Above
59. Which of the following enables you
to paste data multiple times?
a. Windows Clipboard
b. Office Clipboard
c. Both Windows & Office Clipboard
d. None of the all
60. You need to jump to the next column
breaking current column right at the cursor position. How can you break column?
a. Pressing Ctrl+Enter
b. Pressing Alt+Shift+Enter
c. Break command from Insert menu
d. Both b and c
61. In Word you can force a page break
a. By positioning your cursor at the appropriate place and pressing the F1 key
b. By using the Insert/Section break on the Insert tab
c. By positioning your cursor at the appropriate place and pressing Ctrl+Enter
d. By changing the font size of your document
62. 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 + {
63. How to use Format Painter multiple times
a. By Click on Lock Format Painter Icon
b. By Double Click on the Format Painter Icon
c. By Selecting Edit -> Format Painter -> Multiple Use
d. Format Painter cannot be use multiple times
64. What is the default font used in MS
Word 2007 document?
a. Times New Roman
b. Arial
c. Calibri
d. Preeti
65. Word includes a series of predefined
graphics called _____ that can be inserted into a Word document.
a. clip art
b. hyperlinks
c. captions
d. bookmarks
66. A (n) _____is a dot or other symbol
positioned at the beginning of a paragraph.
a. bullet
b. logo
c. cell
d. target
67. Which of the following is not a type
of page margin?
a. Left
b. Right
c. Center
d. Top
68. Uppercase on Change Case dialog box
and All Caps on Fonts dialog box both converts selected text into Capital
Letters. Whats the difference between the two?
a. Both are same. They are only two different ways of capitalize text.
b. It is faster to convert from Change Case than from Font dialog box
c. Change Case makes conversion permanent but All Caps on Font can always be
reverted
d. All Caps on Font dialog box makes the change permanent where Change Case can
be always reverted
69. Ctrl + A
a. Align Right
b. Select All
c. Change font
d. Save document
70. Which of the following is not on
Home ribbon?
a. Columns
b. Font color
c. Change Style
d. Font
71. When three hyphens, underscores,
equal signs, asterisks, or number signs are typed and then the enter key is
pressed, the AutoFormat feature _____.
a. places a border above a paragraph
b. creates a numbered list
c. changes the characters to an em dash
d. creates a bulleted list
72. Microsoft Office Word is a (n)
_____.
a. area in the computers main memory in which Microsoft Office text files are
stored temporarily
b. program included with Windows 2000 that can be used only to create or edit
text files, smaller than 64K, that do not require formatting
c. classified password that prevents unauthorized users from accessing a
protected Microsoft Office item or document
d. full-featured word processing program that can be used to create and revise
professional looking documents easily
73. Ctrl + E
a. Exit Application
b. Select All
c. Clear All
d. Align Center
74. When a custom tab stop is set, Word
_____.
a. clears all default tab stops
b. clears all default tab stops to the right of the custom tab stop
c. clears all default tab stops to the left of the custom tab stop
d. does not clear any default tab stops
75. When inserting Page number in footer
it appeared 1 but you wish to show a. How can you do that?
a. From format menu choose bullets and Numbering and configure necessary
setting
b. From Insert menu choose Page Number and specify necessary setting
c. Click on Page Number Format tool and specify required setting
d. All of above
76. How do you close a word document
without closing Word window?
a. Click on the Close button on the title bar
b. Click on Xminimize button on the title bar
c. Click on the Close command on Office menu
d. Click Exit on the File menu
77. To switch between insert mode and
overtype mode, _____.
a. click Caption on the Insert menu
b. double-click the OVR status indicator on the status bar
c. click Text Box on the Insert menu
d. double-click the INS status indicator on the status bar
78. What should you do if you require to
paste the same format in many places?
a. Click the Format painter and go on pasting in many places holding Alt Key
b. Double click the format painter then go on pasting in many places
c. Click the format painter then go on pasting to many places holding Ctrl Key
d. All of above
79. Which would you choose to save a
document with a new name?
a. Press Ctrl+S
b. Click File, Save
c. Click Tools, Options, Save
d. Click File, Save As
80. You cannot close MS Word application
by
a. Choosing File menu then Exit submenu
b. Press Alt+F4
c. Click X button on title bar
d. From File menu choose Close submenu
81. Which of the following option is not
available in Insert >> Picture ?
a. Chart
b. Word Art
c. Clip Art
d. Graph
82. Which option in File pull-down menu
is used to close a file in MSWord?
a. New
b. Quit
c. Close
d. Exit
83. Ctrl + O
a. Save Document
b. Print Document
c. Close Document
d. Open Document
84. Which feature do you use to create a
newspaper like document?
a. Bullets & numbering
b. Tables
c. Columns
d. Tab stops
85. A _____ contains buttons, boxes, and
menus that allow tasks to be performed more quickly than using the menu bar.
a. format bar
b. status bar
c. command bar
d. toolbar
86. A letterhead should contain all of
the following EXCEPT ____.
a. full street address
b. logo
c. complete legal name of the company, group, or individual
d. None of the above
87. Which of the following is not
available in Font Spacing?
a. Normal
b. Loosely
c. Condensed
d. Expanded
88. To convert a hyperlink e-mail
address to regular text, right-click the e-mail address and then click _____ on
the shortcut menu.
a. Edit Hyperlink
b. Select Hyperlink
c. Convert Hyperlink
d. Remove Hyperlink
89. Which enables you to move directly
to specific location in a document?
a. Subdocuments
b. Bookmarks
c. Cross-references
d. Outlines
90. Each time the _____ key is pressed,
the paragraph formatting in the previous paragraph is carried forward to the
next paragraph.
a. enter
b. shift
c. ctrl
d. alt
91. What is the shortcut key you can
press to create a copyright symbol?
a. Alt+Ctrl+C
b. Alt + C
c. Ctrl + C
d. Ctrl + Shift + C
92. What is the short cut key to open
Font dialog box?
a. Ctrl + F
b. Alt + Ctrl + F
c. Ctrl + D
d. Ctrl + Shift + D
93. What is the shortcut key to Center
Align the selected text?
a. Ctrl + C
b. Ctrl + E
c. Ctrl + F
d. None of above
94. What is the shortcut key
for Spelling Check in document?
a. F7
b. Shift + F7
c. Ctrl + F7
d. Alt + F7
95. What is the shortcut key
to Update Formula in a table?
a. F9
b. Alt + F9
c. Ctrl + F9
d. Shift + F9
96. What is the shortcut key for Font
dialog box?
a. Ctrl + F
b. Ctrl + D
c. Ctrl + G
d. None of the above
97. What is the shortcut key for Find
and Replace dialog box?
a. Ctrl + F
b. Ctrl + R
c. Ctrl + H
d. Ctrl + Shift + F
98. What is the shortcut key to Insert
Hyperlink in a document?
a. Ctrl + H
b. Ctrl + L
c. Ctrl + K
d. None of above
99. 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
100. What is the shortcut key for
Subscript the selected text?
a. Ctrl + =
b. Ctrl +
c. Ctrl + Shift + =
d. Ctrl + Shift +
Correct Answers to MS Word MCQ Questions
Q.No Correct Answers
1 B |
2 A |
3 C |
4 B |
5 A |
6 B |
7 B |
8 C |
9 B |
10 B |
11 B |
12 D |
13 D |
14 C |
15 C |
16 A |
17 B |
18 D |
19 C |
20 B |
21 A |
22 D |
23 B |
24 A |
25 A |
26 A |
27 B |
28 C |
29 D |
30 A |
31 D |
32 B |
33 A |
34 A |
35 B |
36 B |
37 D |
38 B |
39 B |
40 A |
41 C |
42 D |
43 A |
44 C |
45 A |
46 B |
47 A |
48 D |
49 C |
50 D |
51 C |
52 C |
53 B |
54 D |
55 A |
56 C |
57 C |
58 C |
59 C |
60 C |
61 C |
62 A |
63 B |
64 C |
65 A |
66 A |
67 C |
68 C |
69 B |
70 A |
71 A |
72 D |
73 D |
74 C |
75 C |
76 C |
77 B |
78 B |
79 D |
80 D |
81 D |
82 C |
83 D |
84 C |
85 D |
86 D |
87 B |
88 D |
89 C |
90 a |
91 A |
92 C |
93 B |
94 A |
95 A |
96 B |
97 C |
98 C |
99 D |
100 A |
Microsoft Excel
1. Which of the following methods cannot be used to enter data in a cell
a. Pressing an arrow key
b. Pressing the Tab key
c. Pressing the Esc key
d. Clicking on the formula bar
These MS Excel multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
2. Which of 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
3. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
4. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
5. Text formulas:
a. Replace cell references
b. Return ASCII values of characters
c. Concatenate and manipulate text
d. Show formula error value
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
6. 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
These Microsoft Excel MCQ Questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
7. Which of 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
8. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
9. 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 Kinkos and have 2 more copies made
d. Press Ctrl+P+3
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
10. 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 youre 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
These ms excel mcq questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
11. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
12. 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 delete and select delete from the shortcut menu
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
13. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
14. When integrating word and excel, word is usually the
a. Server
b. Destination
c. Client
d. Both b and c
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
15. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
16. The 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
17. Comments put in cells are called
a. Smart tip
b. Cell tip
c. Web tip
d. Soft tip
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
18. Which is used to perform what if analysis?
a. Solver
b. Goal seek
c. Scenario Manager
d. All of above
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
19. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
20. Multiple calculations can be made in a single formula using
a. standard formulas
b. array formula
c. complex formulas
d. smart formula
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
21. Hyperlinks can be
a. Text
b. Drawing objects
c. Pictures
d. All of above
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
22. To activate the previous cell in a pre-selected range, press
a. The Alt key
b. The Tab key
c. The Enter key
d. None of the above
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
23. Which button do you click to add up a series of numbers?
a. The autosum button
b. The Formula button
c. The quicktotal button
d. The total button
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
24. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
25. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
26. In a worksheet you can select
a. The entire worksheet
b. Rows
c. Columns
d. All of the above
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
27. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
28. Which area in an excel window allows entering values and formulas
a. Title bar
b. Menu bar
c. Formula bar
d. Standard toolbar
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
29. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
30. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
31. To create a formula, you can use:
a. Values but not cell references
b. C ell references but not values
c. Values or cell references although not both at the same time
d. Value and cell references
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
32. Status indicators are located on the
a. Vertical scroll bar
b. Horizontal scroll bar
c. Formula bar
d. Standard toolbar
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
33. Which of the following is the oldest spreadsheet package?
a. VisiCalc
b. Lotus 1-2-3
c. Excel
d. StarCalc
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
34. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
35. You can copy data or formulas
a. With the copy, paste and cut commands on the edit menu
b. With commands on the shortcut menu
c. With buttons on the standard toolbars
d. All of the above
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
36. 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.
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
37. Which of the following is a popular DOS based spreadsheet package?
a. Word
b. Smart cell
c. Excel
d. Lotus 1-2-3
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
38. An excel workbook is a collection of
a. Workbooks
b. Worksheets
c. Charts
d. Worksheets and charts
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
39. Excel files have a default extension of
a. Xls
b. Xlw
c. Wk1
d. 123
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
40. You can use the format painter multiple times before you 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
41. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
42. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
43. A 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
44. Which of following is Not one of Excels what-if function?
a. Goal seek
b. Solver
c. Scenario manager
d. Auto Outline
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
45. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
46. Which of the following is not information you can specify using the solver?
a. Input cells
b. Constraints
c. Target cell
d. Changing cells
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
47. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
48. Excel probably considers the cell entry January 1, 2000 to be a
a. Label
b. Value
c. Formula
d. Text string
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
49. You can enter which types of data into worksheet cells?
a. Labels, values, and formulas
b. Labe3ls and values but not formulas
c. Values and formulas but not labels
d. Formulas only
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
50. All worksheet formula
a. Manipulate values
b. Manipulate labels
c. Return a formula result
d. Use the addition operator
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
51. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
52. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
53. The numbers in our worksheet look like this: You want them to look like this: $1,000.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.
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
54. Which of the following is not a valid data type in excel
a. Number
b. Character
c. Label
d. Date/time
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
55. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
56. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
57. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
a. Pie chart
b. Row chart
c. Line chart
d. Column chart
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
58. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
59. Which of the following methods can not be used to edit the contents of a cell?
a. Press the Alt key
b. Clicking the formula bar
c. Pressing the F2 key
d. Double clicking the cell
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
60. If you begin typing an entry into a cell and then realize that you dont 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
61. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
62. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
63. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
64. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
65. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
66. Which elements of worksheet can be protected from accidental modification
a. Contents
b. Objects
c. Scenarios
d. All of above
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
67. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
68. 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 of the text
d. There is not time to format the next
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
69. 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
These MCQs are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
70. 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
These multiple choice questions are originally presented in mcqsets.com. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
71. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
72. Files created with Lotus 1-2-3 have an extension
a. DOC
b. XLS
c. 123
d. WK1
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
73. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
74. Comments can be added to cells using
a. Edit > Comments
b. Insert > Comments
c. File > Comments
d. View > Comments
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
75. Which of the following is not a worksheet design criterion?
a. Efficiency
b. Aditibility
c. Description
d. Clarity
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
76. To copy cell contents using drag and drop press the
a. End key
b. Shift key
c. Ctrl key
d. Esc key
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
77. Which of the following is the latest version of Excel
a. Excel 2000
b. Excel 2002
c. Excel ME
d. Excel XP
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
78. 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 doesnt adjust relative cell references
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
79. The 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
80. Which menu option can be sued to split windows into two
a. Format > window
b. View > window > split
c. Window > split
d. View > split
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
81. Which of the following is an absolute cell reference?
a. !A!1
b. $A$1
c. #a#1
d. A1
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
82. What symbol is used before a number to make it a label?
a. (quote)
b. = (equal)
c. _ (underscore)
d. (apostrophe)
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
83. Which symbol must all formula begin with?
a. =
b. +
c. (
d. @
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
84. Which of the following formulas is not entered correctly?
a. =10+50
b. =B7*B1
c. =B7+14
d. 10+50
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
85. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
86. A typical worksheet has . Number of columns
a. 128
b. 256
c. 512
d. 1024
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
87. How many characters can be typed in a single cell in Excel?
a. 256
b. 1024
c. 32000
d. 65535
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
88. A worksheet can have a maximum of . Number of rows
a. 256
b. 1024
c. 32000
d. 65535
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
89. Which of the following is not an example of a value?
a. 350
b. May 10, 2001
c. 0.57
d. Serial Number 50771
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
90. The 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
91. The Chart wizard term data categories refers to;
a. A chart plot area
b. A horizontal axis
c. The organization of individual values with a charts data series
d. The data range that supply chart data
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
92. A 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
93. Getting data from a cell located in a different sheet is called
a. Accessing
b. Referencing
c. Updating
d. Functioning
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
94. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
95. A numeric value can be treated as a label value if it precedes with
a. Apostrophe (&lsquo
b. Exclamation (!)
c. Hash (#)
d. Ampersand (&
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
96. Concatenation of text can be done using
a. Apostrophe (&lsquo
b. Exclamation (!)
c. Hash (#)
d. Ampersand (&
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
97. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
98. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
99. 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
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
100. Excel uniquely identifies cells within a worksheet with a cell name
a. Cell names
b. Column numbers and row letters
c. Column letters and row numbers
d. Cell locator coordinates
These multiple choice questions are originally presented in MCQ Sets. Please visit http://mcqSets.com for question banks, online quiz, downloads, subjective questions and answers . Prepare your exam better with MCQ Sets.
Answers:
Click the Like, Tweet or Google+ buttons below to show your support to MCQ Sets:
Thank you for liking this page! I truly appreciate your support.
Q.No-Correct Answer
1 c |
2 a |
3 d |
4 d |
5 c |
6 a |
7 d |
8 b |
9 b |
10 a |
11 a |
12 d |
13 d |
14 d |
15 b |
16 b |
17 b |
18 d |
19 b |
20 b |
21 d |
22 d |
23 a |
24 d |
25 d |
26 b |
27 b |
28 c |
29 b |
30 a |
31 d |
32 c |
33 a |
34 a |
35 d |
36 d |
37 d |
38 d |
39 a |
40 b |
41 b |
42 b |
43 c |
44 d |
45 b |
46 a |
47 c |
48 b |
49 a |
50 c |
51 d |
52 d |
53 c |
54 b |
55 c |
56 a |
57 c |
58 a |
59 a |
60 b |
61 c |
62 a |
63 a |
64 b |
65 d |
66 d |
67 d |
68 b |
69 b |
70 c |
71 d |
72 c |
73 d |
74 b |
75 c |
76 a |
77 d |
78 b |
79 d |
80 c |
81 b |
82 d |
83 a |
84 d |
85 a |
86 b |
87 d |
88 d |
89 d |
90 b |
91 b |
92 c |
93 b |
94 d |
95 a |
96 d |
97 d |
98 a |
99 b |
100 c |