Office Automation Tools Multiple Choice Questions
1. What is the function of Ctrl + B in Ms-Word
A. it converts selected text into the next larger size of the same font
B. it adds a line break to the document
C. it makes the selected text bold
D. it applies italic formatting t the selected text
Answer: C.it makes the selected text bold
2. Graphics for word processor is
A. peripheral
B. clip art
C. highlight
D. execute
Answer: B.clip art
3. What is the function of CTRL+R in MS-Word
A. open the print dialog box
B. update the current web page
C. close the current window
D. none of these
Answer: D.none of these
4. Which of the following is / are the additional features of Ms Word 2007?
A. quick access toolbar
B. ms button
C. ribbon
D. all the above
Answer: D.all the above
5. In Microsoft Word shortcut key CTRL+W is used for
A. open the print dialog box
B. update the current web page
C. close the current window
D. none of these
Answer: C.close the current window
6. Which shortcut key is used to spell check in MS-Word?
A. f1
B. f2
C. f7
D. f9
Answer: C.f7
7. Why headers and footers used in MS -Word
A. to enhance the overall appearance of the document
B. to mark the starting of a page
C. to make large document more readable
D. to allow page headers and footers to appear on document when it is printed
Answer: D.to allow page headers and footers to appear on document when it is printed
8. The minimum number of rows and columns a word table can have is
A. zero
B. 2 rows and 1 column
C. 2 rows and 2 column
D. 1 row and 1 column
Answer: D.1 row and 1 column
9. In MS-Word shortcut SHIFT+DELETE is used to
A. delete the selected item permanently without placing the item in the recycle bin
B. copy the selected item
C. rename the selected item
D. create a shortcut to the selected item
Answer: A.delete the selected item permanently without placing the item in the recycle bin
10. In MS Word to move the insertion point to the beginning of the next word commandused is
A. ctrl+rightarrow
B. ctrl+left arrow
C. ctrl+down arrow
D. none of these
Answer: A.ctrl+rightarrow
11. Which of the following line spacing is invalid?
A. multiple
B. double
C. triple
D. single
Answer: C.triple
12. How can you apply exactly the same formatting you did to another text?
A. copy the text and click on paste special tool on new place
B. select the text then click on format painter and select the new text
C. copy the text and paste in new location. then type the new text again
D. all of above
Answer: B.select the text then click on format painter and select the new text
13. What should you do if you require pasting the same format in many places?
A. double click the format painter then go on pasting in many places
B. click the format painter then go on pasting to many places holding ctrl key
C. click the format painter and go on pasting in many places holding alt key
D. all of above
Answer: A.double click the format painter then go on pasting in many places
14. On which toolbar can you find Format Painter tool?
A. formatting toolbar
B. picture toolbar
C. drawing toolbar
D. standard toolbar
Answer: D.standard toolbar
15. Which indent marker controls all the lines except first line?
A. left indent marker
B. first line indent marker
C. right indent marker
D. hanging indent marker
Answer: A.left indent marker
16. Which operation you will perform if you need to move a block of text?
A. copy and paste
B. paste and cut
C. cut and paste
D. paste and delete
Answer: C.cut and paste
17. What is the extension of Word files?
A. dot
B. txt
C. fil
D. doc
Answer: D.doc
18. Which of the following option is not available in Insert >> Picture?
A. chart
B. graph
C. clip art
D. word art
Answer: B.graph
19. To insert a drop cap in one of the paragraph you should access
A. format
B. tools
C. insert menu
D. none of above
Answer: A.format
20. How many different positions can you set for drop cap?
A. 1
B. 2
C. 3
D. 4
Answer: B.2
21. Which of the following can NOT be used to create parallel style column?
A. insert textbox
B. table insert table
C. format tabs
D. format columns
Answer: D.format columns
22. Which of the following is used to create newspaper style columns?
A. format columns
B. table insert table
C. format tabs
D. insert textbox
Answer: A.format columns
23. Columns dialog box can be opened from…
A. press alt + o + c
B. format menu columns submenu
C. double click on column space in ruler
D. all of above
Answer: D.all of above
24. You can jump to the next column by
A. press alt + down-arrow
B. clicking with your mouse on the next column
C. both of above
D. none of above
Answer: C.both of above
25. To open Columns dialog box quickly..
A. double click the space between area on ruler
B. double click the right margin in ruler
C. double click on the left margin area of ruler
D. all of above
Answer: A.double click the space between area on ruler
26. Which of the following command is not available in Tools menu?
A. auto summarize
B. macro
C. autocorrect
D. auto text
Answer: D.auto text
27. Text boundary can be displayed or hidden from
A. customize from tools menu
B. auto text option from insert menu
C. options from tools menu
D. all of above
Answer: C.options from tools menu
28. Which of the following is / are word processing software?
A. ms word
B. easy word
C. wordperfect
D. all of above
Answer: D.all of above
29. MS Office provides help in many ways, which of these is one of them?
A. help menu
B. what is this?
C. office assistant
D. all of the above
Answer: D.all of the above
30. What is the maximum scale percentage available in Scale drop down box?
A. 300
B. 200
C. 100
D. 50
Answer: B.200
31. Bold, Italic, Regular are known as
A. text effects
B. font effects
C. font styles
D. word art
Answer: C.font styles
32. Changing the appearance of a document is called
A. editing
B. proofing
C. formatting
D. all of above
Answer: C.formatting
33. In a document what is the maximum number of columns that can be inserted in MSWord Table?
A. 31
B. 32
C. 63
D. 64
Answer: C.63
34. A screen element of MS Word that is usually located below the title bar that providescategorized options is…
A. status bar
B. menu bar
C. tool bar
D. all of the above
Answer: B.menu bar
35. A ____________ is a small program that helps to automate a frequently used series ofcommands in most productivity software tools.
A. macro
B. utility
C. template
D. wizard
Answer: A.macro
36. Which of the following is the second step in creating a macro?
A. using your mouse or keyboard, perform the task you want to automate
B. give the macro a name
C. assign a keyboard shortcut to the macro
D. start recording
Answer: C.assign a keyboard shortcut to the macro
37. If you will be displaying or printing your document on another computer, you’ll wantto make sure and select the _____________ option under the ‘Save’ tab.
A. embed true type fonts
B. embed fonts
C. save true type fonts
D. save fonts
Answer: A.embed true type fonts
38. In Word, the mailing list is known as the ____________.
A. data source
B. sheet
C. data sheet
D. source
Answer: A.data source
39. Which of the following button will allow you to add, delete, or change records in yourData Source?
A. ‘edit’ button
B. ‘data editing’ button
C. ‘data source’ button
D. ‘edit data source’ button
Answer: D.‘edit data source’ button
40. It is possible to _______ a data source before performing a merge.
A. modify
B. sort
C. create
D. all of the above
Answer: D.all of the above
41. What is the default font size of a new Word document based on Normal template?
A. 9 pt
B. 12 pt
C. 14 pt
D. none of above
Answer: B.12 pt
42. What is the default font used in MS Word document?
A. times new roman
B. arial
C. algerian
D. none of the above
Answer: A.times new roman
43. Which tab in Font dialog box contains options to apply font effects?
A. text effects
B. standard toolbar
C. font tab
D. character spacing
Answer: C.font tab
44. Drop Cap means
A. small caps
B. title case
C. all caps
D. none of above
Answer: D.none of above
45. Which function of Ms Word enables you to create multiple mails at a time?
A. macro
B. mail merge
C. scenario manager
D. pivot table
Answer: B.mail merge
46. Which of the following is not valid version of MS Office?
A. office xp
B. office vista
C. office 2007
D. none of above
Answer: D.none of above
47. 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
Answer: D.from file menu choose close submenu
48. The key F12 opens a
A. save as dialog box
B. open dialog box
C. save dialog box
D. close dialog box
Answer: A.save as dialog box
49. What is the short cut key to open the Open dialog box?
A. f12
B. shift f12
C. alt + f12
D. ctrl + f12
Answer: D.ctrl + f12
50. A feature of MS Word that saves the document automatically after certain interval isavailable on
A. save tab on options dialog box
B. save as dialog box
C. both of above
D. none of above
Answer: A.save tab on options dialog box
51. Where can you find the horizontal split bar on MS Word screen?
A. on the left of horizontal scroll bar
B. on the right of horizontal scroll bar
C. on the top of vertical scroll bar
D. on the bottom of vertical scroll bar
Answer: C.on the top of vertical scroll bar
52. Which of the following is not available on the Ruler of MS Word screen?
A. tab stop box
B. left indent
C. right indent
D. center indent
Answer: D.center indent
53. What is place to the left of horizontal scroll bar?
A. tab stop buttons
B. view buttons
C. split buttons
D. indicators
Answer: B.view buttons
54. Which file starts MS Word?
A. winword.exe
B. word.exe
C. mswo
D. exe
Answer: A.winword.exe
55. How many ways you can save a document?
A. 3
B. 4
C. 5
D. 6
Answer: A.3
56. If you want to keep track of different editions of a document which features will youuse?
A. editions
B. versions
C. track change
D. all of above
Answer: B.versions
57. Background colour or effects applied on a document is not visible in
A. web layout view
B. print layout view
C. reading view
D. print preview
Answer: D.print preview
58. What is a portion of a document in which you set certain page formatting options?
A. page
B. document
C. section
D. page setup
Answer: C.section
59. Borders can be applied to
A. cells
B. paragraph
C. text
D. all of above
Answer: D.all of above
60. Which of the following is not a type of page margin?
A. left
B. right
C. centre
D. top
Answer: C.centre
61. What is the default left margin in Word 2007document?
A. 1″
B. 1.25″
C. 1.5″
D. 2″
Answer: B.1.25″
62. What is gutter margin?
A. margin that is added to the left margin when printing
B. margin that is added to right margin when printing
C. margin that is added to the binding side of page when printing
D. margin that is added to the outside of the page when printing
Answer: C.margin that is added to the binding side of page when printing
63. Portrait and Landscape are
A. page orientation
B. paper size
C. page layout
D. all of above
Answer: A.page orientation
64. If you need to change the typeface of a document, which menu will you choose?
A. edit
B. view
C. format
D. tools
Answer: C.format
65. Which of the following is not a font style?
A. bold
B. italics
C. regular
D. superscript
Answer: D.superscript
66. ————- is a spread sheet application
A. ms word
B. ms access
C. ms excel
D. all of these
Answer: C.ms excel
67. Who is considered as father of electronic spread sheet?
A. dan bricklin
B. allen turing
C. winton serf
D. charles babbage
Answer: A.dan bricklin
68. Which of the following is / are the additional features of Ms Excel 2007?
A. quick access toolbar
B. ms button
C. ribbon
D. all the above
Answer: D.all the above
69. A file in Ms Excel is Called———-
A. work sheet
B. work book
C. work field
D. work file
Answer: B.work book
70. A work book is a collection of ———– used in a single file
A. work sheet
B. work record
C. work field
D. work file
Answer: A.work sheet
71. A function inside another function is called _______
A. nested function
B. round function
C. sum function
D. text function
Answer: A.nested function
72. Which of the following is not an underline option in the format cells dialog box?
A. double
B. single accounting
C. double accounting
D. single engineering
Answer: D.single engineering
73. Formulas in Excel start with
A. %
B. =
C. +
D. –
Answer: B.=
74. The default header for a worksheet is
A. username
B. date and time
C. sheet tab name
D. none
Answer: C.sheet tab name
75. Which of the following is not an option of the spelling dialog box?
A. ignore
B. ignore all
C. edit
D. change
Answer: C.edit
76. Which of the following methods will not enter data in a cell?
A. pressing the esc key
B. pressing an arrow key
C. pressing the tab key
D. clicking the enter button to the formula bar
Answer: A.pressing the esc key
77. The cell reference for cell range of F2 to P12 is _______
A. f2.p12
B. f;p12
C. f2:p12
D. f2-p12
Answer: C.f2:p12
78. What is the keyboard shortcut for creating a chart from the selected cell range?
A. f2
B. f4
C. f8
D. f11
Answer: D.f11
79. The Software which contains rows and columns is called ______
A. database
B. drawing
C. spreadsheet
D. word processing
Answer: C.spreadsheet
80. You can group non-contiguous worksheets with
A. the alt+enter key
B. the ctrl key and mouse
C. the shift key and the mouse
D. the group button on the standard toolbar
Answer: B.the ctrl key and mouse
81. Which of the following is not a valid Zoom percentage in Excel?
A. 75
B. 100
C. 200
D. 500
Answer: D.500
82. The spelling tool is placed on ______ toolbar
A. standard
B. formatting
C. drawing
D. reviewing
Answer: A.standard
83. If you need a text to show vertically in a cell. How will you achieve this?
A. choose vertical on text alignment in format cells dialog box
B. choose 90 degrees in orientation of format cells dialog box
C. choose distributed from the vertical drop down list of format cells dialog box
D. choose centre across selection from horizontal combo box in format cells dialog box
Answer: B.choose 90 degrees in orientation of format cells dialog box
84. Can you set 0.5 inch left indentation for a cell in Excel?
A. excel does not have indentation feature
B. you can specify indentation only if you turn the rulers on
C. indentation can be set from format cells dialog box
D. the indentation can be specified only when printing
Answer: C.indentation can be set from format cells dialog box
85. You can automatically adjust the size of text in a cell if they do not fit in width by
A. double clicking on the right border of column header
B. from format choose columns and then auto fit selection
C. from format cells dialog box mark shrink to fit check box
D. all of above
Answer: C.from format cells dialog box mark shrink to fit check box
86. Formatting a cell in Currency, you can specify
A. decimal places
B. currency symbol
C. both of above
D. none of above
Answer: C.both of above
87. Formatting a cell in Number format you can’t set
A. decimal places
B. use 1000 separator
C. negative numbers
D. currency symbol
Answer: D.currency symbol
88. What is entered by the function =today()
A. the date value for the day according to system clock
B. the time value according to system clock
C. today’s date as text format
D. all of above
Answer: B.the time value according to system clock
89. Which function will you use to enter current time in a worksheet cell?
A. today()
B. =now()
C. =time()
D. =current time()
Answer: C.=time()
90. Special category of Number tab in Format Cells dialog box can be used to applyformats like
A. zip code
B. phone number
C. both of above
D. none of above
Answer: C.both of above
91. Merge cells option can be applied from
A. format cells dialog box alignment tab
B. formatting toolbar
C. both of above
D. none of above
Answer: C.both of above
92. Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be appliedfrom
A. from format >> cells
B. from format >> auto format
C. from table >> auto format
D. all of above
Answer: B.from format >> auto format
93. Which of the following format you can decide to apply or not in AutoFormat dialogbox?
A. number format
B. border format
C. font format
D. all of above
Answer: D.all of above
94. How can you remove borders applied in cells?
A. choose none on border tab of format cells
B. open the list on border tool in formatting toolbar then choose first tool (no border)
C. both of above
D. none of above
Answer: C.both of above
95. Where can you set the shedding colour for a range of cells in Excel?
A. choose required colour form patterns tab of format cells dialog box
B. choose required colour on fill colour tool in formatting toolbar
C. choose required colour on fill colour tool in drawing toolbar
D. all of above
Answer: D.all of above
96. You can set Page Border in Excel from
A. from border tab in format cells dialog box
B. from border tool in formatting toolbar
C. from line style tool in drawing toolbar
D. you cannot set page border in excel
Answer: D.you cannot set page border in excel
97. When all the numbers between 0 and 100 in a range should be displayed in RedColour, apply
A. use =if() function to format the required numbers red
B. apply conditional formatting command on format menu
C. select the cells that contain number between 0 and 100 then click red colour on text colour tool
D. all of above
Answer: B.apply conditional formatting command on format menu
98. You can check the conditions against __________ when applying conditionalformatting
A. cell value
B. formula
C. both of above
D. none of above
Answer: C.both of above
99. Which of the following is not true regarding Conditional Formatting?
A. you can add more than one condition to check
B. you can set condition to look for bold and apply italics on them.
C. you can apply font, border and pattern formats that meets the specified conditions
D. you can delete any condition from conditional formatting dialog box if it is not required
Answer: C.you can apply font, border and pattern formats that meets the specified conditions
100. In Microsoft Excel 2007, the ———– is used to issue commands
A. quick access tool bar
B. formula bar
C. ribbon
D. ms button
Answer: C.ribbon
101. You can auto fit the width of column by
A. double clicking on the column name on column header
B. double click on the cell pointer in worksheet
C. double clicking on column right border on column header
D. double clicking on the column left border of column header
Answer: C.double clicking on column right border on column header
102. Long text can be broken down into many lines within a cell. You can do this through
A. wrap text in format >> cells
B. justify in edit >> cells
C. text wrapping in format >> cells, layout tab
D. all of above
Answer: A.wrap text in format >> cells
103. MS Excel provides the default value for step in Fill Series dialog box
A. 0
B. 1
C. 5
D. 10
Answer: B.1
104. Ctrl + D shortcut key in Excel will
A. open the font dialog box
B. apply double underline for the active cell
C. fill down in the selection
D. none of above
Answer: C.fill down in the selection
105. The short cut key Ctrl + R is used in Excel to
A. right align the content of cell
B. remove the cell contents of selected cells
C. fill the selection with active cells to the right
D. none of above
Answer: C.fill the selection with active cells to the right
106. The command Edit >> Fill Across Worksheet is active only when
A. one sheet is selected
B. when many sheets are selected
C. when no sheet is selected
D. none of above
Answer: B.when many sheets are selected
107. Which of the following series type is not valid for Fill Series dialog box?
A. linear
B. growth
C. auto fill
D. time
Answer: D.time
108. Which of the following you can paste selectively using Paste Special command?
A. validation
B. formats
C. formulas
D. all of above
Answer: D.all of above
109. Paste Special allows some operation while you paste to new cell. Which of thefollowing operation is valid?
A. square
B. percentage
C. goal seek
D. divide
Answer: D.divide
110. Edit >> Delete command
A. deletes the content of a cell
B. deletes formats of cell
C. deletes the comment of cell
D. deletes selected cells
Answer: D.deletes selected cells
111. To remove the content of selected cells you must issue ______ command
A. edit >> delete
B. edit >> clear >> contents
C. edit >> clear >> all
D. data >> delete
Answer: B.edit >> clear >> contents
112. The Delete key of keyboard is assigned to which command in Excel?
A. edit >> clear >> contents
B. edit >> clear >> all
C. edit >> delete
D. all of above
Answer: A.edit >> clear >> contents
113. If you need to remove only the formatting done in a range (numbers and formulatyped there should not be removed), you must
A. from edit menu choose clear and then formats
B. from edit menu choose delete
C. click on remove formatting tool on standard toolbar
D. double click the format painter and then press esc key in keyboard
Answer: A.from edit menu choose clear and then formats
114. By default Excel provides 3 worksheets. You need only two of them, how willyou delete the third one?
A. right click on sheet tab of third sheet and choose delete from the context menu
B. click on sheet 3 and from edit menu choose delete
C. both of above
D. none of above
Answer: A.right click on sheet tab of third sheet and choose delete from the context menu
115. Which of the following action removes a sheet from workbook?
A. select the sheet, then choose edit >> delete sheet
B. select the sheet then choose format >> sheet >> hide
C. both of above
D. none of above
Answer: A.select the sheet, then choose edit >> delete sheet
116. While finding and replacing some data in Excel, which of the followingstatement is valid?
A. you can find and replace within the sheet or workbook
B. excel does not have option to match case for find
C. both are valid
D. none are valid
Answer: A.you can find and replace within the sheet or workbook
117. Which of the following is not true about Find and Replace in Excel
A. you can search for bold and replace with italics
B. you can decide whether to look for the whole word or not
C. you can search in formula too
D. you can search by rows or columns or sheets
Answer: D.you can search by rows or columns or sheets
118. You can move a sheet from one workbook into new book by
A. from edit menu choose move or copy sheet, mark the create a copy and click ok
B. from edit menu choose move of copy then choose (move to end) and click ok
C. from edit menu choose move or copy then select (new book) from to book list and click ok
D. none of above
Answer: C.from edit menu choose move or copy then select (new book) from to book list and click ok
119. What is the short cut key to replace a data with another in sheet?
A. ctrl + r
B. ctrl + shift + r
C. ctrl + h
D. ctrl + f
Answer: C.ctrl + h
120. To start Microsoft PowerPoint application
A. click on start >> programs >> all programs >> microsoft powerpoint
B. hit ctrl + r then type ppoint.exe and enter
C. click start >> run then type power point then press enter
D. all of above
Answer: D.all of above
121. Which tab is not available on left panel when you open a presentation?
A. outline
B. slides
C. notes
D. all of above are available
Answer: C.notes
122. Which of the following statements is not true?
A. you can type text directly into a powerpoint slide but typing in text box is more convenient.
B. from insert menu choose picture and then from file to insert your images into slides.
C. you can display a powerpoint presentation in normal, slide sorter or slide show view.
D. you can show or hide task pane from view >> toolbars
Answer: A.you can type text directly into a powerpoint slide but typing in text box is more convenient.
123. Which of the following section does not exist in a slide layout?
A. titles
B. lists
C. charts
D. animations
Answer: D.animations
124. PowerPoint presentations are widely used as
A. note outlines for teachers
B. project presentations by students
C. communication of planning
D. all of above
Answer: D.all of above
125. _______ controls all the main slide control tasks for your presentation.
A. task pane
B. task bar
C. control panel
D. none of above
Answer: A.task pane
126. Which of the following cannot be toggled from View >> Toolbars?
A. control toolbox
B. slides
C. revisions
D. reviewing
Answer: B.slides
127. Which of the following pane is not available in Task Pane?
A. getting started
B. clip art
C. word art
D. search results
Answer: C.word art
128. Which of the following pane is NOT available in Task Pane?
A. slide design
B. master slide
C. slide layout
D. slide transition
Answer: B.master slide
129. A new presentation can be created from
A. blank presentation
B. from existing presentation
C. from design template
D. all of above
Answer: D.all of above
130. In slide layout panel how many layouts are available for text layout by default?
A. 4
B. 7
C. 12
D. none of above
Answer: A.4
131. Which of the following statement is false?
A. if you choose to select from one of the pre-made slide layouts, you can change the positioning
B. if you choose to select from the pre-made slide layouts, you cannot delete the objects in the layout.
C. blank slide is at the top of the ‘content layouts’ area in the slide layout panel.
D. all of above are false statements
Answer: B.if you choose to select from the pre-made slide layouts, you cannot delete the objects in the layout.
132. What lets you to create new presentation by selecting ready-made font color andgraphics effects?
A. presentation template
B. master slide
C. design template
D. animation scheme
Answer: C.design template
133. Which command will you use in PowerPoint if you need to change the color ofdifferent objects without changing content?
A. design template
B. colour scheme
C. font colour
D. object colour
Answer: B.colour scheme
134. What PowerPoint feature will you use to apply motion effects to differentobjects of a slide?
A. slide transition
B. slide design
C. animation objects
D. animation scheme
Answer: D.animation scheme
135. What feature will you use to apply motion effects in between a slide exits andanother enters?
A. slide transition
B. slide design
C. animation objects
D. animation scheme
Answer: A.slide transition
136. The selected design template can be applied
A. to current slide only
B. to all the slides
C. to all the new presentation you create
D. all of above
Answer: D.all of above
137. The difference between Slide Design and Auto Content Wizard is
A. both are same
B. auto content wizard is just the wizard version of slide design
C. slide design does not provide sample content but auto content wizard provides sample content too!
D. slide design asks your choice in steps but auto content wizard does not let
Answer: C.slide design does not provide sample content but auto content wizard provides sample content too!
138. In which menu can you find features like Slide Design, Slide Layout etc.?
A. insert menu
B. format menu
C. tools menu
D. slide show menu
Answer: B.format menu
139. Which menu provides you options like Animation Scheme, custom Animation,Slide Transition?
A. insert menu
B. format menu
C. tools menu
D. slide show menu
Answer: D.slide show menu
140. What is the extension of power point file?
A. .pmt
B. .pnt
C. .ppt
D. .pdf
Answer: C..ppt
141. How many steps are there between Start and Finish in AutoContent Wizard?
A. 3
B. 4
C. 5
D. 6
Answer: A.3
142. Which short cut key inserts a new slide in current presentation?
A. ctrl+n
B. ctrl+m
C. ctrl+s
D. all of above
Answer: B.ctrl+m
143. What happens if you select first and second slide and then click on New Slidebutton on toolbar?
A. a new slide is inserted as first slide in presentation
B. a new slide is inserted as second slide in presentation
C. a new slide is inserted as third slide in presentation
D. none of above
Answer: C.a new slide is inserted as third slide in presentation
144. Which of the following method can insert a new slide in current presentation?
A. right click on the slide panel and choose new slide
B. from insert menu choose new slide
C. click on new slide button on toolbar
D. all of above
Answer: D.all of above
145. Which of the following is not a part of Slide Design
A. design template
B. colour scheme
C. animation scheme
D. slide layout
Answer: D.slide layout
146. What is the best way to create another copy of a slide?
A. click the slide then press ctrl+a and paste in new slide
B. from insert menu choose duplicate slide
C. redo everything on a new slide that you had done on previous slide
D. none of above
Answer: B.from insert menu choose duplicate slide
147. From which menu you can access Picture, Test Box, and Chart etc?
A. file
B. edit
C. insert
D. view
Answer: C.insert
148. If you want to insert some slides from other presentation into current one choose
A. from insert menu choose slides from files
B. from insert menu choose slides from presentation
C. from insert menu choose slides
D. none of above
Answer: A.from insert menu choose slides from files
149. What are the three options available in Insert >> Picture menu?
A. clipart, pictures, shapes
B. clipart, from file, shapes
C. clipart, from files, autoshapes
D. clipart, pictures, autoshapes
Answer: C.clipart, from files, autoshapes
150. To insert slide numbers
A. insert a text box and select insert >> page number
B. insert a textbox and select insert >> number >> page number
C. choose insert >> slide number
D. insert a new text box and select insert >> slide number
Answer: D.insert a new text box and select insert >> slide number
151. In a PowerPoint presentation
A. sound clips can be inserted but not movie clips
B. movie clips can be inserted but not sound clips
C. both cannot be inserted
D. both can be inserted
Answer: D.both can be inserted
152. To insert a hyperlink in a slide
A. choose insert >> hyperlink
B. press ctrl + k
C. hyperlinks can’t be inserted in slides
D. both a & b
Answer: D.both a & b
153. List Box and Text box
A. are some other than that in a list box the bullets are enabled
B. are different. list boxes are used to present lists and can’t be created with text boxes.
C. both of above
D. none of above
Answer: A.are some other than that in a list box the bullets are enabled
154. Which of the following statement is true
A. you can insert text boxes from drawing toolbar in powerpoint
B. you cannot insert text boxes from drawing toolbar in powerpoint
C. text boxes are provides when you choose a layout and can’t be inserted afterwards
D. none of above
Answer: A.you can insert text boxes from drawing toolbar in powerpoint
155. When you delete a text box object from a slide in PowerPoint Presentation
A. the object is deleted but text box and the text inside is left on the slide
B. the text box is deleted and the text is pasted on the slide
C. the text box and text both are deleted
D. none of above
Answer: B.the text box is deleted and the text is pasted on the slide
156. Which of the following font effect is not available in PowerPoint Font dialogbox?
A. underline
B. shadow
C. emboss
D. strikethrough
Answer: D.strikethrough
157. What happens if you edited an image inserted in Power Point?
A. the original file that was inserted is not changed
B. the original file that was inserted is changed
C. the original file is changed when you save presentation
D. none of above
Answer: A.the original file that was inserted is not changed
158. If you select Insert >> Picture >> From File
A. you can insert pictures and clipart
B. you can insert clipart only
C. you can insert pictures only
D. none of above
Answer: C.you can insert pictures only
159. The effect applied to display when slides changes in slide show view is
A. slide animation
B. custom animation
C. custom transition
D. slide transition
Answer: D.slide transition
160. To start slide show of a presentation
A. hit f5 key
B. from slide show menu choose view show option
C. from slide show menu choose rehearse timing
D. both a & b
Answer: D.both a & b
161. Which file format can be added to a PowerPoint show?
A. .jpg
B. .giv
C. .wav
D. all of the above
Answer: D.all of the above
162. In Microsoft PowerPoint two kind of sound effects files that can be added to thepresentation are
A. .wav files and .mid files
B. .wav files and .gif files
C. .wav files and .jpg files
D. .jpg files and .gif files
Answer: A..wav files and .mid files
163. What is a motion path?
A. a type of animation entrance effect
B. a method of advancing slides
C. a method of moving items on a slide
D. all of the above
Answer: C.a method of moving items on a slide
164. What is a slide-title master pair?
A. the title area and text area of a specific slide
B. a slide master and title master merged into a single slide
C. a slide master and title master for a specific design template
D. all of above
Answer: C.a slide master and title master for a specific design template
165. Which of the following should you use if you want all the slide in thepresentation to have the same “look”?
A. the slide layout option
B. add a slide option
C. outline view
D. a presentation design template
Answer: D.a presentation design template
166. In the context of animations, what is a trigger?
A. an action button that advances to the next slide
B. an item on the slide that performs an action when clicked
C. the name of a motion path
D. all of above
Answer: B.an item on the slide that performs an action when clicked
167. If you have a PowerPoint show you created and want to send using email toanother person you can add the show to your email message as a (an)
A. inclusion
B. attachment
C. reply
D. forward
Answer: B.attachment
168. In order to edit a chart, you can
A. triple click the chart object
B. click and drag the chart object
C. double click the chart object
D. click the chart object
Answer: C.double click the chart object
169. To exit the PowerPoint
A. click the application minimize button
B. click the document close button
C. double click the applications control menu icon
D. double click the document control menu icon
Answer: C.double click the applications control menu icon
170. special effects used to introduce slides in a presentation are called
A. effects
B. custom animations
C. transitions
D. present animations
Answer: C.transitions
171. What is the term used when you press and hold the left mouse key and more themouse around the slide?
A. highlighting
B. dragging
C. selecting
D. moving
Answer: B.dragging
172. Which of the following toolbars provide different options in various masterviews?
A. common tasks toolbar
B. drawing toolbar
C. formatting toolbar
D. standard toolbar
Answer: A.common tasks toolbar
173. In Ms Excel ————– are text entries
A. labels
B. tupple
C. attributes
D. character
Answer: A.labels
174. Which of the following is not a financial function in Excel?
A. pv
B. count
C. pmt
D. rate
Answer: B.count
175. Which of the following is not a database function in excel?
A. dmax
B. dmin
C. dcount
D. ddb
Answer: D.ddb
176. In Excel, we can use ——— function to calculate EMI of loan.
A. ipmt
B. pmt
C. goal seek
D. correl
Answer: B.pmt
177. Which of the following is not a statistical function in excel?
A. average
B. correl
C. stdev
D. sum
Answer: D.sum
178. Which of the following coming under “What-If –Analysis” in excel?
A. goal seek
B. scenario manager
C. data table
D. all the above
Answer: D.all the above
179. ———- is a method to find a specific value of cell by adjusting the value ofanother cell.
A. goal seek
B. scenario manager
C. data table
D. macro
Answer: A.goal seek
180. Which of the following is not a logical function in excel?
A. and
B. false
C. or
D. none of these
Answer: D.none of these
181. By default an excel work book displays——— work sheets
A. 1
B. 2
C. 3
D. 5
Answer: C.3
182. “Auto fill” is a unique feature of:
A. ms word
B. ms excel
C. ms powerpoint
D. all of these
Answer: B.ms excel
183. Which of the following is not a basic mathematical function in Excel?
A. addition
B. division
C. exponential
D. none of these
Answer: D.none of these
184. In Excel row’s heading is known as
A. field
B. tupple
C. domain
D. attributes
Answer: B.tupple
185. In email, addresses separate the user name from the ISP using the __________symbol.
A. &
B. @
C. %
D. $
Answer: B.@
186. The mail server as defined in the text uses the __________ protocol.
A. http
B. ftp
C. pop
D. smtp
Answer: C.pop
187. News servers utilize __________ to distribute documents to readers.
A. nntp
B. news
C. http
D. ftp
Answer: A.nntp
188. To search FTP archives for a file, you should use the __________ tool.
A. gopher
B. jughead
C. archie
D. jalopy
Answer: B.jughead
189. __________ is often referred to as “the CB of the Internet.”
A. irc
B. ftp
C. e-mail
D. http
Answer: A.irc
190. discuss groups may have a __________ who monitors the postings andenforces the site’s rules.
A. judge
B. sysop
C. narrator
D. censor
Answer: B.sysop
191. A message with replies on a newsgroup is often called a __________.
A. post
B. list
C. thread
D. comment
Answer: C.thread
192. Internet is governed by_____________.
A. microsoft corporation.
B. adobe.
C. dish net.
D. none of these.
Answer: D.none of these.
193. Which of the following is not a web browser?
A. internet browser
B. netscape communicator.
C. netscape navigator
D. adobe pagemaker.
Answer: D.adobe pagemaker.
194. HTML means_______.
A. hyper text mark-up language.
B. hyper testing mark-up language.
C. hardware text mark-up language.
D. hyper testing mapping language.
Answer: A.hyper text mark-up language.
195. URL stands for____________.
A. uniform resource locator.
B. uniform resource ladder.
C. uniform resource locator.
D. uniform reserved locator.
Answer: C.uniform resource locator.
196. WWW means_______________.
A. world wide wan.
B. world wide web.
C. world wan web.
D. world wan web.
Answer: B.world wide web.
197. WWW uses the following protocol?
A. http.
B. ftp
C. wwwc
D. smtp.
Answer:
198. DSA stands for______________.
A. Digital Signature Algorithm.
B. Digital System architecture.
C. Digital system analysis.
D. Digital Signature Authentication.
Answer: A.Digital Signature Algorithm.
199. ISDN stands for ____.
A. Integrated Standard Digital Network.
B. Integrated Service Digital Networking
C. Integrated Service Digital Network.
D. Independent Standard Digital Network.
Answer: C.Integrated Service Digital Network.
200. ATM is a service that can run over____.
A. SONET.
B. SDH.
C. B-ISDN.
D. ISDN.
Answer: C.B-ISDN.
201. In the mda.edu, the component .edu signifies that_____________________.
A. mda is an educational institute.
B. mda is a commercial organization.
C. mda is a non profit organization.
D. mda is a government organization.
Answer: A.mda is an educational institute.
202. Internet can be used for____________.
A. uploading.
B. downloading.
C. chatting.
D. all of these.
Answer: D.all of these.
203. In an e-mail address @ is used. It represents________________.
A. domain name.
B. senders name.
C. recipients name.
D. network name
Answer: A.domain name.
204. Real time textual talk is called___________.
A. chatting.
B. browsing.
C. surfing.
D. www.
Answer: A.chatting.
205. Which of the following is a requirement for e-commerce?
A. paper.
B. internet connectivity.
C. usb.
D. digital signature.
Answer: B.internet connectivity.
206. The segment in which business directly sells to the end consumer iscalled____________.
A. c2c.
B. p2p.
C. b2c.
D. g2g.
Answer: C.b2c.
207. The payment on Internet is generally made through_________________.
A. cash card.
B. debit card.
C. credit ca
Answer: C.credit ca
208. _____________ governs cyber practices in India.
A. uncitral 1996.
B. it act 2000.
C. transfer of property law.
D. microsoft corporation.
Answer: B.it act 2000.
209. ___________ monitors all the traffic that flows between the two networks butblock certain traffic completely which may be intruder.
A. firewall.
B. anti-virus.
C. software.
D. hardware.
Answer: A.firewall.
210. WAN stands for________.
A. wire and network.
B. wire accessible network.
C. widely accessible network.
D. wide area network
Answer: D.wide area network
211. In which network the ends are not connected?
A. bus.
B. star.
C. ring.
D. token ring.
Answer: A.bus.
212. Using any host computer on the internet as if you were directly connected iscalled__________.
A. ftp.
B. telnet.
C. e mail.
D. ppp.
Answer: A.ftp.
213. GPRS refers to ___________.
A. global packet radio service
B. global potential radio service
C. global powerful radio service
D. global physical radio service
Answer: A.global packet radio service
214. HTTP refers to________.
A. hyper text transfer protocols
B. hyper text transfer procedure.
C. home text translating process.
D. hyper text translating process.
Answer: A.hyper text transfer protocols
215. The internet means__________.
A. network of computer.
B. network through links.
C. network of electronic devices.
D. network of electrical devices.
Answer: A.network of computer.
216. In internet terminologies, “IP” stands for_________.
A. intranet protocol.
B. internet protocol
C. individual protocol.
D. industrial protocol.
Answer: B.internet protocol
217. The web page means___________.
A. plain page.
B. hyperlink.
C. designed page.
D. pictures.
Answer: C.designed page.
218. The HTML programming uses__________.
A. tags.
B. numbers.
C. pictures.
D. tables.
Answer: A.tags.
219. The Hyperlink means_________________.
A. text connected to page.
B. plain text.
C. graphic text.
D. none of these.
Answer: A.text connected to page.
220. The use of integrated services digital network is____________.
A. more faster
B. slower.
C. free service.
D. constant access.
Answer: C.free service.
221. E-commerce means________________.
A. business through internet.
B. commercial activities through electronic media.
C. electrical commerce.
D. commercial transaction.
Answer: B.commercial activities through electronic media.
222. ______ provides the continuous access to the wireless network services and theflexible communication between the people.
A. network.
B. laptop.
C. mobile computing.
D. personal computing.
Answer: C.mobile computing.
223. _______ refers to using the small portable and hand held computing devicessuch as PDA laptops mobile phones MP3 players digital cameras tablet PC and Palmtops in a wireless enabled network.
A. personal computing
B. digital computing.
C. network computing.
D. mobile computing.
Answer: D.mobile computing.
224. A___________ identifies a user’s personal preferences and settings and allowsthe web site’s server to retrieve your information from its database.
A. cookie.
B. view history.
C. prototype.
D. profile.
Answer: A.cookie.
225. The area that contains the URL or web address of the active web page is calledthe___________ bar.
A. address
B. menu.
C. link.
D. browser.
Answer: A.address
226. A_________ engine is a software program used by a search site to retrieve webpages from a search database that match certain criteria.
A. multimedia.
B. virtual.
C. serf.
D. search.
Answer: D.search.
227. _________ is a software program that secretly collects information and monitorsyour actions without your knowledge.
A. ad ware.
B. freeware.
C. spy ware.
D. hidden ware
Answer: C.spy ware.
228. Electronic mail cannot be used for______________.
A. scanning pictures.
B. sending documents.
C. sending attachments.
D. sending messages
Answer: A.scanning pictures.
229. ___________ is a type of Internet connection in which the PC must connect to aservice provider using standard telephone lines.
A. http.
B. wireless.
C. dsl.
D. dial-up.
Answer: D.dial-up.
230. The Internet began as an experimental network called as_______________.
A. extranet
B. arpanet.
C. milnet.
D. infranet.
Answer: B.arpanet.
231. A_____ room or online forum allows users to communicate through typedmessages which are displayed almost instantly.
A. mail.
B. buddy.
C. chat.
D. message.
Answer: C.chat.
232. A_________ is a software program used for viewing various kinds of Internetresources found on the World Wide Web.
A. bookmark.
B. intranet.
C. domain.
D. browser.
Answer: D.browser.
233. . Where is the Internets central hub and control centre located?
A. near washington d.c.
B. near the microsoft campus in redmond washington.
C. in a top-secret location.
D. in silicon valley.
Answer: B.near the microsoft campus in redmond washington.
234. Which of these domains is restricted to qualified organizations?
A. .com
B. .org
C. .net
D. .edu
Answer: C..net
235. Which of these services would you probably not be able to get from a typicalInternet service provider (ISP)?
A. an email address.
B. access to a web server.
C. a connection to the internet.
D. technical help.
Answer: D.technical help.
236. The first Web pages were____________.
A. strictly hypertext with no multimedia content.
B. designed to simulate printed pages using html table tools.
C. the first true multimedia documents to be published on the internet.
D. viewable only with proprietary microsoft software.
Answer: B.designed to simulate printed pages using html table tools.
237. What do you call software that prevents certain Web pages from beingdisplayed?
A. child safe software.
B. dutch dike software.
C. filtering software.
D. spam blockers.
Answer: D.spam blockers.
238. ____________ ensures the privacy and confidentiality in electronic messages.
A. client server security.
B. data and transaction security.
C. software security holes.
D. physical security holes.
Answer: B.data and transaction security.
239. One major threat to data security is unauthorized network monitoring is alsocalled as_____________.
A. packet sniffing.
B. message security.
C. message confidentiality.
D. system integrity.
Answer: A.packet sniffing.
240. DES stands for____________.
A. data encryption standard.
B. data encryption system.
C. data enabling system.
D. data enabled system.
Answer: A.data encryption standard.
241. DSA stands for______________.
A. digital signature algorithm.
B. digital system architecture.
C. digital system analysis.
D. digital signature
Answer: A.digital signature algorithm.
242. MAN stands for……………
A. metropolitan area network
B. mass area network
C. middle area network
D. maximum area network
Answer: A.metropolitan area network
243. Trojan Horse is a—————
A. accounting software
B. search engine
C. portal
D. none of these
Answer: D.none of these
244. ISDN stands for ____.
A. integrated standard digital network.
B. integrated service digital networking
C. integrated service digital network.
D. independent standard digital
Answer: C.integrated service digital network.
245. ATM is a service that can run over____.
A. sonet.
B. sdh.
C. b-isdn.
D. isdn
Answer: C.b-isdn.
246. If a computer on the network shares resources for others to use, it is called ____.
A. server.
B. client.
C. mainframe.
D. super.
Answer: A.server.
247. Who is the father of internet?
A. charles babbage
B. tim burners lee
C. winton serf
D. simur cray
Answer: C.winton serf
248. …………. is a word processing application from Microsoft
A. Ms Office
B. Ms Access
C. Ms Excel
D. None of the above
Answer: D.None of the above
249. A ____________ is a small program that helps to automate a frequently used seriesof commands in most productivity software tools.
A. Macro
B. Utility
C. Template
D. Wizard
Answer: A.Macro
250. Which of the following button will allow you to add, delete, or change records inyour Data Source?
A. ‘Edit’ button
B. ‘Data editing’ button
C. ‘Data Source’ button
D. ‘Edit Data Source’ button
Answer: D.‘Edit Data Source’ button
251. Which function will you use to enter current time in a worksheet cell?
A. =today()
B. =now()
C. =time()
D. =current Time()
Answer: C.=time()
252. Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can beapplied from
A. from Format >> Cells
B. from Format >> Auto format
C. from Table >> Auto format
D. All of above
Answer: B.from Format >> Auto format
253. Which of the following is not true regarding Conditional Formatting?
A. You can add more than one condition to check
B. You can set condition to look for Bold and apply Italics on them.
C. You can apply Font, border and pattern formats that meets the specified conditions
D. You can delete any condition from Conditional Formatting dialog box if
Answer: C.You can apply Font, border and pattern formats that meets the specified conditions
254. By default Excel provides 3 worksheets. You need only two of them, how will youdelete the third one?
A. Right click on Sheet Tab of third sheet and choose Delete from the context menu
B. Click on Sheet 3 and from Edit menu choose Delete
C. Both of above
D. None of above
Answer: A.Right click on Sheet Tab of third sheet and choose Delete from the context menu
255. While finding and replacing some data in Excel, which of the following statement isvalid?
A. You can Find and Replace within the sheet or workbook
B. Excel does not have option to match case for find
C. Both are valid
D. None are valid
Answer: A.You can Find and Replace within the sheet or workbook
256. What PowerPoint feature will you use to apply motion effects to different objects of aslide?
A. Slide Transition
B. Slide Design
C. Animation Objects
D. Animation Scheme
Answer: D.Animation Scheme
257. The difference between Slide Design and Auto Content Wizard is
A. Both are same
B. Auto content Wizard is just the wizard version of Slide Design
C. Slide Design does not provide sample content but Auto Content Wizard provides sample content too!
D. Slide Design asks your choice in steps but Auto Content Wizard does not let you make choices
Answer: C.Slide Design does not provide sample content but Auto Content Wizard provides sample content too!
258. Which menu provides you options like Animation Scheme, custom Animation, SlideTransition?
A. Insert Menu
B. Format Menu
C. Tools Menu
D. Slide Show Menu
Answer: D.Slide Show Menu
259. What happens if you select first and second slide and then click on New Slide buttonon toolbar?
A. A new slide is inserted as first slide in presentation
B. A new slide is inserted as second slide in presentation
C. A new slide is inserted as third slide in presentation
D. None of above
Answer: C.A new slide is inserted as third slide in presentation
260. Which of the following font effect is not available in PowerPoint Font dialog box?
A. Underline
B. Shadow
C. Emboss
D. Strikethrough
Answer: D.Strikethrough
261. Material consisting of text and numbers is best presented as
A. A table slide
B. A bullet slide
C. A title slide
D. none
Answer: A.A table slide
262. Which of the following should you use if you want all the slide in the presentation tohave the same “look”?
A. the slide layout option
B. add a slide option
C. outline view
D. a presentation design template
Answer: D.a presentation design template
263. If you have a PowerPoint show you created and want to send using email to anotherperson you can add the show to your email message as a (an)
A. Inclusion
B. Attachment
C. Reply
D. Forward
Answer: B.Attachment
264. Which of the following toolbars provide different options in various master views?
A. Common tasks toolbar
B. Drawing toolbar
C. Formatting toolbar
D. Standard toolbar
Answer: A.Common tasks toolbar
265. ———- is a method to find a specific value of cell by adjusting the value of anothercell.
A. Goal seek
B. Scenario manager
C. Data table
D. Macro
Answer: A.Goal seek
266. _______ refers to using the small portable and hand held computing devices such asPDA laptops mobile phones MP3 players digital cameras tablet PC and Palmtops in a wireless enabled network.
A. Personal computing
B. Digital computing.
C. Network computing.
D. Mobile computing.
Answer: D.Mobile computing.
267. A___________ identifies a user’s personal preferences and settings and allows theweb site’s server to retrieve your information from its database.
A. Cookie.
B. View history.
C. Prototype.
D. Profile.
Answer: A.Cookie.