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. Today’s 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 record’s 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 math’s 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 Napier’s 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 world’s 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 program’s 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 UK’s 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 Word’s AutoCorrect entries, to display an indifferent face ( Description: 😐) 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 code’s 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. What’s 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 computer’s 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 Kinko’s 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 you’re about to enter a formula

c. Enter the formula using any input values and the appropriate mathematical operators that make up your formula

d. Choose the new command from the file menu

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 Excel’s 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 don’t want your entry placed into a cell, you:

a. Press the Erase key

b. Press Esc

c. Press the Enter button

d. Press the Edit Formula button

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 doesn’t 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 chart’s 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